Uploaded image for project: 'mod-source-record-manager'
  1. mod-source-record-manager
  2. MODSOURMAN-419

SQL Exception WRT count function

    XMLWordPrintable

Details

    • Folijet Sprint 111, Folijet Sprint 112
    • 1
    • Folijet
    • R1 2021 Bug Fix

    Description

      When importing a record . The change manager returns 200/201 all along.. But under the hood something is terribly wrong.

      ERROR PostgresClient       [618919eqId] query with count: { "message": "syntax error at end of input", "severity": "ERROR", "code": "42601", "internalPosition": "109", "internalQuery": "EXPLAIN SELECT jsonb FROM diku_mod_source_record_manager.job_execution_source_chunks WHERE (jsonb->>'id') = ", "where": "PL/pgSQL function count_estimate_smart2(bigint,bigint,text) line 7 at FOR over EXECUTE statement\nPL/pgSQL function count_estimate(text) line 7 at assignment", "file": "scan.l", "line": "1115", "routine": "scanner_yyerror" } - SELECT diku_mod_source_record_manager.count_estimate('SELECT jsonb FROM diku_mod_source_record_manager.job_execution_source_chunks WHERE (jsonb->>''id'') = ')
      

      mod-source-record-manager-2.5.0-SNAPSHOT.362

      See attached full log.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                VRohach Volodymyr Rohach
                adam Adam Dickmeiss
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases