Actions
Bug #98561
closedStyleguide updated menu dataprocessor do not work with PostgresSQL
Start date:
2022-10-09
Due date:
% Done:
100%
Estimated time:
TYPO3 Version:
11
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
Using PostgresSQL backend leads to error in menu processing, which can
be seen using the ext:styleguide extension frontend demo pages.
The background of this issue is, the PostgreSQL seems to lowercase fieldnames
if they are not properly quoted, and than cannot find them if the field is in
upper case, like for example pages.SYS_LASTCHANGED.
Due the nature of the system desing and historical reasons, sql parts are manually
build and injected in QueryBuilder instances, which prevents proper quoting of
identifiers and values - leading to this issue.
Files
Actions