[CONJ-106] JAVA Lib: Fails to parse query containing outer join syntax "{OJ ... }" blocks use LibreOffice Base-created LEFT/RIGHT join queries Created: 2014-08-15 Updated: 2014-10-21 Resolved: 2014-10-10 |
|
| Status: | Closed |
| Project: | MariaDB Connector/J |
| Component/s: | None |
| Affects Version/s: | 1.1.7 |
| Fix Version/s: | 1.1.8 |
| Type: | Bug | Priority: | Major |
| Reporter: | Doug | Assignee: | Massimo Siani (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
Windows 7 |
||
| Description |
|
LibreOffice Base creates queries in a GUI and supports LEFT and RIGHT joins. Base uses the syntax " { OJ ... }", which I guess means outer join. The queries are executed correctly and without error in native and MySQL JDBC drivers, but on execution using Maria DB client java library 1.1.7 returns error: "The data content could not be loaded." "unknown escape sequence { OJ ... }" the "..." being the contents of the table names and whatnot in that part of the query bracketed by "{ }". Never seen that OJ syntax before, but apparently it is supported by MariaDB and other java connectors. This issue blocks use of the Java Client Library with LibreOffice Base, to the extent using LEFT and RIGHT JOIN queries created by the LO query builder. |
| Comments |
| Comment by Vladislav Vaintroub [ 2014-08-19 ] |
|
According to JDBC spec (section 13.4.3) , escape sequence {oj ...}is written in lower case. Actually, all JDBC escape sequences are lowercase . |
| Comment by Massimo Siani (Inactive) [ 2014-09-18 ] |
|
I think we should support uppercase sequences for compatibility. Do you agree? |
| Comment by Vladislav Vaintroub [ 2014-09-18 ] |
|
Te fix is low overhead, so it should be fine . |
| Comment by Massimo Siani (Inactive) [ 2014-10-10 ] |
|
1.1.8 will accept any case, the guys at Libreoffice have fixed it anyway (see bug https://bugs.freedesktop.org/show_bug.cgi?id=84073). |