Bug #67385

SQL parser does not support string as join condition

Added by Xavier Perseguers about 1 month ago. Updated about 1 month ago.

Status:Resolved Start date:2015-06-10
Priority:Should have Due date:
Assigned To:Xavier Perseguers % Done:

100%

Category:DBAL Spent time: -
Target version:6.2.13
TYPO3 Version:6.2 Is Regression:No
PHP Version:5.3 Sprint Focus:Stabilization Sprint
Complexity:

Description

SQL parser is capable of parsing

JOIN T1 ON T1.some_field = T2.some_other_field

and

JOIN T1 ON T1.some_field = 4

(thus using an integer)

but not

JOIN T1 ON T1.some_field = 'some string'

Related issues

related to Core - Bug #66614: FAL processed files are deleted Resolved 2015-04-27

Associated revisions

Revision 9067813e
Added by Xavier Perseguers about 1 month ago

[BUGFIX] SQL parser does not support string as join condition

The SQL parser is capable of parsing

JOIN T1 ON T1.some_field = T2.some_other_field

and

JOIN T1 ON T1.some_field = 4

but not

JOIN T1 ON T1.some_field = 'some string'

Change-Id: I7806699ea44685ab717cc0e8a75f7b53a1b2b1cc
Resolves: #67385
Related: #66614
Releases: master, 6.2
Reviewed-on: http://review.typo3.org/40144
Reviewed-by: Andreas Fernandez <>
Tested-by: Andreas Fernandez <>
Reviewed-by: Alexander Opitz <>
Reviewed-by: Xavier Perseguers <>
Tested-by: Xavier Perseguers <>

Revision 6d44ed99
Added by Xavier Perseguers about 1 month ago

[BUGFIX] SQL parser does not support string as join condition

The SQL parser is capable of parsing

JOIN T1 ON T1.some_field = T2.some_other_field

and

JOIN T1 ON T1.some_field = 4

but not

JOIN T1 ON T1.some_field = 'some string'

Change-Id: I7806699ea44685ab717cc0e8a75f7b53a1b2b1cc
Resolves: #67385
Related: #66614
Releases: master, 6.2
Reviewed-on: http://review.typo3.org/40145
Reviewed-by: Xavier Perseguers <>
Tested-by: Xavier Perseguers <>

History

#1 Updated by Gerrit Code Review about 1 month 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/40144

#2 Updated by Gerrit Code Review about 1 month ago

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

#3 Updated by Xavier Perseguers about 1 month ago

  • Status changed from Under Review to Resolved
  • % Done changed from 0 to 100

Also available in: Atom PDF