Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-106

JAVA Lib: Fails to parse query containing outer join syntax "{OJ ... }" blocks use LibreOffice Base-created LEFT/RIGHT join queries

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.1.7
    • Fix Version/s: 1.1.8
    • Component/s: None
    • 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.

        Attachments

          Activity

            People

            Assignee:
            massimo.siani Massimo Siani (Inactive)
            Reporter:
            dougt901 Doug
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.