Uploaded image for project: 'mod-users'
  1. mod-users
  2. MODUSERS-95

Empty result for WHERE id='ba6baf95-bf14-4020-b44c-0cad269fb5c9'

    XMLWordPrintable

Details

    • Core: Platform
    • Very Small (VS) < 1day

    Description

      CQL2PG converts CQL "id==ba6baf95-bf14-4020-b44c-0cad269fb5c9" to SQL "WHERE id='ba6baf95-bf14-4020-b44c-0cad269fb5c9'".
      This is correct because id is the primary key, no need to look into the jsonb field.
      PostgresClient always returns an empty result set for this, see this commented out test case:
      https://github.com/folio-org/mod-users/blob/f9f1ab8d108d7d507e4df7eb703d001a7b8909a1/src/test/java/org/folio/moduserstest/RestVerticleIT.java#L311-L331

      PostgresClient logs this in the log:
      Skipping query due to no results expected! SELECT * FROM diku_mod_users.users WHERE id='ba6baf95-bf14-4020-b44c-0cad269fb5c9' LIMIT 10 OFFSET 0

      TestRail: Results

        Attachments

          Issue Links

            is blocked by

            Bug - A problem which impairs or prevents the functions of the product. CQLPG-67 default pkColumnName = "id"

            • 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-274 Implement PostgresClient::save(sqlConnection, table, id, entity, replyHandler)

            • 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-277 id for primary key name, drop configuration option

            • 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. CQLPG-58 ID searches way too slow

            • 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. MODUSERS-94 pkColumnName missing: GET on resource 'createdBy' failed, saying: Internal Server Error

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

            Activity

              People

                julianladisch Julian Ladisch
                julianladisch Julian Ladisch
                Kurt Nordstrom Kurt Nordstrom
                Julian Ladisch Julian Ladisch
                Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases