Bug #80874
closed
QueryBuilder::quoteIdentifiersForSelect - No subselects possible
0%
Description
Hello,
the hardcore quoting in TYPO3\CMS\Core\Database\Query\QueryBuilder of all fields don't allow any subselects (e.g.) when using the hook at
$GLOBALS['TYPO3_CONF_VARS']['SC_OPTIONS']["TYPO3\\CMS\\Recordlist\\RecordList\\DatabaseRecordList"]['buildQueryParameters']
because everything is quoted except the "*".
I am not sure if this is wanted but i am declaring this as a bug because subselects should be possible.
Updated by Bastian Zagar over 7 years ago
Problem is found in
QueryBuilder::quoteIdentifiersForSelect
Updated by Benni Mack over 7 years ago
- Target version changed from 8 LTS to next-patchlevel
Updated by Julian Mair almost 7 years ago
Is it not already possible to do exaclty that with QueryBuilder::selectLiteral and QueryBuilder::addSelectLiteral?
But nevertheless, for the 'FROM' clause it should be possible too ...
btw. even doctrine say, that we are not forced to quote everthing. In many cases they causing more problems than they solve...
@see: https://github.com/doctrine/dbal/blob/2.6/lib/Doctrine/DBAL/Connection.php#L806
Updated by Benni Mack over 5 years ago
- Target version changed from next-patchlevel to Candidate for patchlevel
Updated by Susanne Moog over 4 years ago
- Status changed from New to Closed
Fixed with #81651 - the complete $queryBuilder is now available and can be used / adjusted.
Updated by Susanne Moog over 4 years ago
- Related to Task #81651: Hand over whole querybuilder object into list-modul hook added