Issue Bug Closed

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

Josef Glatz 02/13/19, 18:34 updated 04/27/20, 06:02

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

Reviews 0

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