Bug #87710

DB check module: Building a database query where sys_language_uid=-1 not possible

Added by Josef Glatz about 1 month ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Database API (Doctrine DBAL)
Target version:
-
Start date:
2019-02-13
Due date:
% Done:

0%

TYPO3 Version:
8
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

Problem/Description

If you use the DB check > Full search > Advanced Query module in the TYPO3 backend it's actually not possible to build a SELECT query on a table where the WHERE clause has to be equal -1.

The resulting SQL query is

SELECT `uid`, `type`, `sys_language_uid`, `pid`, `deleted`
FROM `tx_theme_feature_teaser`
WHERE (tx_theme_feature_teaser.sys_language_uid = '1550085900') AND (`tx_theme_feature_teaser`.`deleted` = 0) LIMIT 100

This is the sent form data:

SET[search]: query
SET[search_query_makeQuery]: all
storeControl[STORE]: 0
storeControl[title]: 
SET[queryTable]: tx_theme_feature_teaser
SET[queryFields]: uid,type,sys_language_uid
queryConfig[0][operator]: 
queryConfig[0][type]: FIELD_sys_language_uid
queryConfig[0][comparison]: 6
queryConfig[0][inputValue]: -1
just_update: 
SET[queryGroup]: 
SET[queryOrder]: 
SET[queryLimit]: 100

The expectation is

the where clause must query sys_language_uid = -1

Also available in: Atom PDF