Project

General

Profile

Actions

Bug #25878

closed

Problem with strings in WHERE clause on Oracle databases

Added by Tjorben Wridt over 13 years ago. Updated almost 11 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2011-04-11
Due date:
% Done:

0%

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

Description

Hello,

we discovered a problem with strings in WHERE clauses. They are enclosed by double qoutes which Oracle uses as an identifier not as a string value. This string values should be enclosed by single qoutes.

The following Oracle error message appeared when using the workspace functionality and publishing a content element:

ORA-00904: "sys_workspace": invalid identifier: SELECT * FROM "sys_workspace_stage" WHERE "parentid" = 22 AND "parenttable" = "sys_workspace" AND "deleted" = 0 ORDER BY "sorting"

This string "parenttable" = "sys_workspace" causes the problem.


Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #25887: Invalid use of double-quoteClosedOliver Hader2011-04-11

Actions
Actions

Also available in: Atom PDF