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