Project

General

Profile

Actions

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 #1

Updated by Alexander Opitz over 11 years ago

  • Category changed from Database API (Doctrine DBAL) to 999
  • Target version deleted (0)
  • PHP Version deleted (5)

The issue is very old, does this issue exists in newer versions of TYPO3 CMS (4.5 or 6.1)?

Actions #2

Updated by Alexander Opitz over 11 years ago

  • Status changed from New to Needs Feedback
Actions #3

Updated by Alexander Opitz about 11 years ago

  • Status changed from Needs Feedback to Closed

No feedback for over 90 days.

Actions

Also available in: Atom PDF