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

Syntax error: Encountered \"<\"

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 2.6.2
    • N/A
    • Other
    • None
    • 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

            diego dupin Diego Dupin
            DaMaAFO Daniel Mack
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.