You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
However, in-query does not work correctly. If you write what you would expect, e.g.
(for/list ([(uuid name email grouped)
(in-query db
select-statement
"1a2b3c"
#:group #("userUUID"
"userName"
"userEmailAddress"))])
(vector uuid name email grouped))
you get the following error from in-query:
in-query: query returned wrong number of columns
statement: "SELECT\nuserUUID,\nuserName,\nuserEmailAddress,\nuserAccessSeconds,\nuserAccessIP\nFROM tUsers\nNATURAL LEFT OUTER JOIN tLogEntries\nWHERE userUUID = ?"
expected: 4
got: 5
This error message is incorrect, however. If you instead write:
(for/list ([(uuid name email four five)
(in-query db
select-statement
"1a2b3c"
#:group #("userUUID"
"userName"
"userEmailAddress"))])
(vector uuid name email four five))
you get this error instead:
result arity mismatch;
expected number of values not received
expected: 5
received: 4
from:
in: local-binding form
values...
The text was updated successfully, but these errors were encountered:
When using
in-query
with a#:group
option, there are mutually contradictoryresult arity mismatch
andwrong number of columns
errors.Here is a (relatively) short program to illustrate:
Given the above,
group-rows
demonstrates the correct grouping behavior, soevaluates to
However,
in-query
does not work correctly. If you write what you would expect, e.g.you get the following error from
in-query
:This error message is incorrect, however. If you instead write:
you get this error instead:
The text was updated successfully, but these errors were encountered: