Uploaded image for project: 'RAML Module Builder'
  1. RAML Module Builder
  2. RMB-179

net.sf.jsqlparser does not support "IS TRUE" and "a@>b"

    XMLWordPrintable

Details

    • Core: Platform

    Description

      PostgresClient.parseQuery(String sqlQuery) uses net.sf.jsqlparser to parse the SQL query returned by CQL2PgJson.

      net.sf.jsqlparser does not support these features:

      • Postgres' JSON operator. Example: The JSON operator "@>" in the query "SELECT * FROM t WHERE a@>b" is split into two operators and results in "SELECT * FROM t WHERE a@ > b"

      Both features are used by CQL2PgJson.

      Suggestion: Drop net.sf.jsqlparser and let CQL2PgJson return a data structure where the caller has access to the where, order by, limit and offset clause. That way the caller does not need to parse the sql string.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                shale99 shale99
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                6 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases