Issue Bug Closed

#70556FIND_IN_SET on PostgreSQL fails on table_name.field_name identiefiers

Morton Jonuschat 10/09/15, 22:14 updated 10/21/17, 17:43

Description

The DBAL SqlParser / SqlCompiler fails when a MySQL FIND_IN_SET Statements needs to be rewritten for PostgreSQL to include a CAST statement.

This results in rewritten SQL fragments like this:

FIND_IN_SET('0', "pages".CAST("fe_group" AS CHAR)) != 0

Reviews 1