phpmyadmin/sql-parser

Missing support for COLLATE inside WHERE

BackEndTea opened this issue · 3 comments

BackEndTea commented

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 commented

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

BackEndTea commented

I'll give this a try to fix

  • 🚀1
williamdes commented

The PR description should have closed it at merge time 🤔