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

Replace JSQL parser by using SqlSelect from CQL2PgJSON

    XMLWordPrintable

Details

    • CP: sprint 75, CP: sprint 76
    • 5
    • Core: Platform

    Description

      PostgresClient.parseQuery parses a query that we build. This should be avoided. The parser doesn't understand the complete PostgreSQL syntax and therefore causes several errors: RMB-179, RMB-180, RMB-492.
      Use SqlSelect from CQL2PgJSON instead.

      TestRail: Results

        Attachments

          Issue Links

            blocks

            Task - A task that needs to be done. MODINVSTOR-256 Improve performance of /instance-storage/instances?query=holdingsRecords.permanentLocationId=abc*

            • P2 - normal priority level, must be included in the current development cycle
            • Closed
            relates to

            Bug - A problem which impairs or prevents the functions of the product. RMB-179 net.sf.jsqlparser does not support "IS TRUE" and "a@>b"

            • P2 - normal priority level, must be included in the current development cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-180 net.sf.jsqlparser.JSQLParserException

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-492 Remove unnecessary JSQLParserException error log if query was parsed successfully

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Task - A task that needs to be done. RMB-506 estimate hit counts

            • TBD - To be determined
            • Closed

            Bug - A problem which impairs or prevents the functions of the product. RMB-532 Criterion get does not select id (only jsonb)

            • TBD - To be determined
            • Closed

            Tech Debt - RMB-817 Remove broken PostgresClient.get(String table, Object entity, ...) methods

            • P3 - low priority level, item will be considered for inclusion in the next dev cycle
            • Closed

            Activity

              People

                adam Adam Dickmeiss
                julianladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases