Details
-
Bug
-
Status: Closed (View Workflow)
-
P3
-
Resolution: Done
-
None
-
customfield_11100 20607
-
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
-
CQLPG-67 default pkColumnName = "id"
-
- Closed
-
-
RMB-274 Implement PostgresClient::save(sqlConnection, table, id, entity, replyHandler)
-
- Closed
-
- relates to
-
RMB-277 id for primary key name, drop configuration option
-
- Closed
-
-
CQLPG-58 ID searches way too slow
-
- Closed
-
-
MODUSERS-94 pkColumnName missing: GET on resource 'createdBy' failed, saying: Internal Server Error
-
- Closed
-