No STRAIGHT_JOIN ?
108 views
Skip to first unread message
Julien Delafontaine
Dec 13, 2016, 11:32:55 PM12/13/16
to H2 Database
I am using
"com.h2database" % "h2" % "1.4.192",
MySQL mode with JDBC driver:
jdbc:h2:mem:test;MODE=MYSQL;
I cannot find any information about the support for STRAIGHT_JOIN neither on the web nor in H2 docs. I am getting a SyntaxError both if I add it to a query after a SELECT, or if I replace a JOIN with it.
Is this intended ? Even in case it makes no sense to H2's query optimizer, the term should be ignored and maybe output a warning instead of an error.
"com.h2database" % "h2" % "1.4.192",
MySQL mode with JDBC driver:
jdbc:h2:mem:test;MODE=MYSQL;
I cannot find any information about the support for STRAIGHT_JOIN neither on the web nor in H2 docs. I am getting a SyntaxError both if I add it to a query after a SELECT, or if I replace a JOIN with it.
Is this intended ? Even in case it makes no sense to H2's query optimizer, the term should be ignored and maybe output a warning instead of an error.
Noel Grandin
Dec 14, 2016, 1:43:42 AM12/14/16
to h2-da...@googlegroups.com
that appears to be a MySQL-specific thing which we don't currently support.
Noel Grandin
Dec 17, 2016, 4:00:24 AM12/17/16
to h2-da...@googlegroups.com
for which I'd be happy to accept a patch, since it looks like a simple change to the Parser (assuming that we don't implement the actual semantics, which would be a much more complicated thing)
Julien Delafontaine
Dec 22, 2016, 6:14:01 AM12/22/16
to H2 Database
I'd like to contribute this, if you could just tell me where is the relevant parser code, and how you run tests after cloning the project (a CONTRIBUTE.md would be useful if you accept external PRs).
Noel Grandin
Dec 22, 2016, 6:20:17 AM12/22/16
to h2-da...@googlegroups.com
Reply all
Reply to author
Forward
0 new messages