Bug #19385

SQL LIKE wildcards are not escaped correctly for list queries

Added by Oliver Hader over 12 years ago. Updated over 12 years ago.

Status:
Closed
Priority:
Should have
Assignee:
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2008-09-28
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
4.2
PHP Version:
5.2
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Using t3lib_db::listQuery('some_Tag') - and knowing that "_" and "%" are wildcard characters in SQL LIKE statements - will produce wrong result sets.

The solution is to escape these wildcard characters correctly.

(issue imported from #M9442)


Files

0009442_v2.patch (833 Bytes) 0009442_v2.patch Administrator Admin, 2008-09-29 11:47

Related issues

Related to TYPO3 Core - Bug #19366: Selecting by tag using wildcards does not work with database disposal of t3lib_cacheClosedOliver Hader2008-09-22

Actions
#1

Updated by Oliver Hader over 12 years ago

Committed to SVN:
  • TYPO3_4-2 (rev. 4265)
  • Trunk (rev. 4266)

Also available in: Atom PDF