Issue Bug Closed

#25878Problem with strings in WHERE clause on Oracle databases

Tjorben Wridt 04/11/11, 11:52 updated 12/08/13, 11:44

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.

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.