Skip to content

Adding filter using an empty array throws error #57

@patchthecode

Description

@patchthecode
let operationalModes = try RestaurantOperationalHourMode.query(on: req).filter(\.id ~~ opertionHrModeIds).all()

opertionHrModeIds is an empty array

Thrown error log is shown below

[psql] [2018-05-18 04:34:25 +0000] select oid, relname from pg_class []
[psql] [2018-05-18 04:34:25 +0000] SELECT * FROM "tokens" WHERE ("tokens"."value" = $1) LIMIT 1 OFFSET 0 ["TEXT (binary) 7278D68E-1A48-495B-BD69-AA12489E20CB)"]
[psql] [2018-05-18 04:34:25 +0000] SELECT * FROM "users" WHERE ("users"."id" = $1) LIMIT 1 OFFSET 0 ["UUID (binary) »ïJé�$OG²\rvCñËÚY)"]
Getting restaurant
[psql] [2018-05-18 04:34:25 +0000] SELECT * FROM "restaurants" WHERE ("restaurants"."userId" = $1) ["UUID (binary) »ïJé�$OG²\rvCñËÚY)"]
[psql] [2018-05-18 04:34:25 +0000] SELECT * FROM "restaurantoperationalhourmodes" WHERE (0) []
[ ERROR ] PostgreSQLDiagnosticResponse.coerce_to_boolean: ERROR: argument of WHERE must be type boolean, not type integer (Logger+LogError.swift:17)
[ DEBUG ] Possible causes for PostgreSQLDiagnosticResponse.coerce_to_boolean: argument of WHERE must be type boolean, not type integer (Logger+LogError.swift:23)

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

No type

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions