Project

General

Profile

Actions
Copy link

Bug #70556

closed

FIND_IN_SET on PostgreSQL fails on table_name.field_name identiefiers

Added by Morton Jonuschat about 9 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Must have
Assignee:
Morton Jonuschat
Category:
Database API (Doctrine DBAL)
Target version:
7 LTS
Start date:
2015-10-09
Due date:
% Done:

100%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.6
Tags:
Complexity:
Is Regression:
No
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
Copy link
 #1

Updated by Morton Jonuschat about 9 years ago

  • Description updated (diff)
Actions
Copy link
 #2

Updated by Gerrit Code Review about 9 years ago

  • Status changed from New to Under Review

Patch set 1 for branch master of project Packages/TYPO3.CMS has been pushed to the review server.
It is available at http://review.typo3.org/43952

Actions
Copy link
 #3

Updated by Morton Jonuschat about 9 years ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100
Actions
Copy link
 #4

Updated by Riccardo De Contardi about 7 years ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF