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

            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