Bug #70556: FIND_IN_SET on PostgreSQL fails on table_name.field_name identiefiers - TYPO3 Core - TYPO3 Forge

Actions

Bug #70556

closed

Status:

Closed

Priority:

Must have

Assignee:

Category:

Database API (Doctrine DBAL)

Target version:

Start date:

2015-10-09

Due date:

% Done:

100%

Estimated time:

TYPO3 Version:

PHP Version:

5.6

Tags:

Complexity:

Is Regression:

Sprint Focus:

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

Actions

Also available in: Atom PDF