Project

General

Profile

Actions
Copy link

Bug #16672

closed

parseWhereClause throws sql error with function in where clause on Oracle database

Added by Marion Schr¶der about 18 years ago. Updated about 11 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2006-10-27
Due date:
% Done:

0%

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

Description

The function parseWhereClause in class.t3lib_sqlparser.php does not parse for functions in the where clause at all.

The returned error message is not delivered to the user frontend (function quoteWhereClause in dbal/class.ux_t3lib_db.php).

We found this error while searching for the reason that web mounts are not shown for non administrative users. For the webmounts to be seen, the permission are checked with bitwise "and". In oracle the function "bitand" would be used for that.

We are running Typo3 4.0.1 versus an oracle database with dbal.
(issue imported from #M4441)

Actions
Copy link

Also available in: Atom PDF