Skip to content

Missing support for COLLATE inside WHERE #491

Closed
@BackEndTea

Description

@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 = ?

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions