Missing support for COLLATE inside WHERE

[BackEndTea]

The following query results in 3 unexpected token errors, and 1 unrecognized keyword.

Is this intentional that this is considered an error?

SELECT  1
FROM   my_table
WHERE   first_col = ?
AND     second_col COLLATE utf8_bin = ?

Without the COLLATE everything is fine:

SELECT  1
FROM   my_table
WHERE   first_col = ?
AND     second_col = ?

[williamdes]

Hi,
It's probably something to be fixed or added for COLLATE

[BackEndTea]

I'll give this a try to fix

[williamdes]

The PR description should have closed it at merge time 🤔