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
function_name(
[ DISTINCT ]
function_arguments
[ { IGNORE | RESPECT } NULLS ]
[ HAVING { MAX | MIN } having_expression ]
)
I think
{IGNORE | RESPECT } NULLS
HAVING {MAX | MIN}
are missing in memefish.
$ go run ./tools/parse --mode statement 'SELECT ARRAY_AGG(x IGNORE NULLS)'
2024/08/21 18:08:23 syntax error::1:20: expected token: ), but: IGNORE
1: SELECT ARRAY_AGG(x IGNORE NULLS)
^~~~~~
exit status 1
$ go run ./tools/parse --mode statement 'SELECT ANY_VALUE(year HAVING MAX inches)'
2024/08/21 18:07:17 syntax error::1:23: expected token: ), but: HAVING
1: SELECT ANY_VALUE(year HAVING MAX inches)
^~~~~~
exit status 1
The text was updated successfully, but these errors were encountered:
Aggregate function calls have several optional clauses.
https://cloud.google.com/spanner/docs/reference/standard-sql/aggregate-function-calls
I think
{IGNORE | RESPECT } NULLS
HAVING {MAX | MIN}
are missing in memefish.
The text was updated successfully, but these errors were encountered: