[TYPO3-core] RFC #12897: Cannot parse SQL hints

[Xavier Perseguers]

Hi,

This is an SVN patch request.

Type: bugfix

BT reference:
http://bugs.typo3.org/view.php?id=12897

Branches: trunk, 4_3

Problem:

RealURL uses SQL hint in method encodeSpURL_encodeCache (line 664 of class.tx_realurl.php):

$res = $GLOBALS['TYPO3_DB']->exec_SELECTquery('/*! SQL_NO_CACHE */ content', ...

This cannot be parsed and gives a fatal error in FE:

PHP Catchable Fatal Error: Argument 1 passed to ux_t3lib_DB::_quoteFieldNames() must be an array, string given, called in /path/to/dbal/class.ux_t3lib_db.php on line 978 and defined in 
/path/to/dbal/class.ux_t3lib_db.php line 990

Solution:

Allow hints to be parsed, in DBAL, simply drop them as remapping should be done in order to support different DBMS. This is a bit tricky thus, simply drop them ATM.

I enclosed DBAL patch for the sake of completeness.

Regards

-- 
Xavier Perseguers
http://xavier.perseguers.ch/en

One contribution a day keeps the fork away
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 12897_core.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091203/6e329d6b/attachment.asc>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 12897_dbal.diff
URL: <http://lists.typo3.org/pipermail/typo3-team-core/attachments/20091203/6e329d6b/attachment.txt>