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

Syntax error: Encountered \"<\"

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Incomplete
    • Affects Version/s: 2.6.2
    • Fix Version/s: N/A
    • Component/s: Other
    • Labels:
      None
    • Environment:
      OS. Suse Linux Enterprise Server 12.2

      Description

      Hello,

      we are trying to execute this query:
      select csc from cscs WHERE context = :source_host AND ((INET_NTOA((-1 << (33 - INSTR(BIN(INET_ATON(subnetmask)), '0')))&INET_ATON(:src_ip))=subnetmask) OR (INET_NTOA((-1 << (33 - INSTR(BIN(INET_ATON(subnetmask)), '0')))&INET_ATON(:dst_ip))=subnetmask))

      then we are getting this error message:
      Java::JavaSql::SQLSyntaxErrorException: Syntax error: Encountered \"<\" at line 1, column 73.

      We tried different mysql as well as mariadb connectors, but with the same result.
      It seems to be, that the connector thoughts that the < is not included in the sql syntax.

      Greetings

      Daniel

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            DaMaAFO Daniel Mack
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: