Query Bug: "!="

Confirm with with https://demo.indiscale.com/ Queries FIND MusicalInstrument WITH Manufacturer = "Antonio Stradivari" and FIND MusicalInstrument WITH Manufacturer != "Antonio Stradivari" yield the same results (only the first is correct).

DoD

• review and merge caosdb-pyinttest!13 (merged)
• review and merge caosdb-mysqlbackend!5 (merged)

added Statusnext label

assigned to @timm

changed the description

added BugUnconfirmed label

added Statustodo label and removed Statusnext label

changed iteration to Sprint Jun 28, 2021 - Jul 9, 2021

added BugConfirmed label and removed BugUnconfirmed label

set weight to 12

added (- (E labels

added P2 label

added P3 label and removed P2 label

Responsible sources probably:

• A: caosdb-mysqlbackend/procedures/query/applyPOV.sql
• B: caosdb-server/src/main/java/org/caosdb/server/query/POV.java

B: 266 seems to correctly add the != operator: callPOV.setString(5, getOperator()); as it appears in the XML response as: <Filter><POV property="Manufacturer" operator="!=" value="Antonio Stradivari" /></Filter>

Check this query: FIND MusicalInstrument WITH price != 814873.0

-> It seems to work for double properties.

The problem seems to be the name resolving in reference properties, because this one also works: FIND MusicalInstrument WITH Manufacturer with name = "Antonio Stradivari" and FIND MusicalInstrument WITH Manufacturer with name != "Antonio Stradivari"

However it's weird that these two also yield the same results:

FIND MusicalInstrument WITH Manufacturer != 119

FIND MusicalInstrument WITH Manufacturer = 119

and furthermore this one: FIND MusicalInstrument WITH Manufacturer > 119

It seems like the operator is ignored in case of comparing reference properties.

That makes sense if I look at the SQL statement which does not involve the operator (called "o"):

SET sRefData = IF(vText IS NULL, ' UNION ALL SELECT DISTINCT domain_id, entity_id, _get_head_iversion(entity_id) AS _iversion, property_id FROM `reference_data` UNION ALL SELECT DISTINCT domain_id, entity_id, _iversion, property_id FROM `archive_reference_data`', IF(refIdsTable IS NULL, NULL, CONCAT(' UNION ALL SELECT DISTINCT domain_id, entity_id, _get_head_iversion(entity_id) AS _iversion, property_id FROM `reference_data` AS subdata WHERE EXISTS (SELECT 1 FROM `', refIdsTable, '` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1) UNION ALL SELECT DISTINCT domain_id, entity_id, _iversion, property_id FROM `archive_reference_data` AS subdata WHERE EXISTS (SELECT 1 FROM `', refIdsTable, '` AS refIdsTable WHERE subdata.value=refIdsTable.id LIMIT 1)')));

removed iteration Sprint Jun 28, 2021 - Jul 9, 2021

added Statusdoing label and removed Statustodo label

changed iteration to Sprint Jul 12, 2021 - Jul 23, 2021

added P2 label and removed P3 label

added Statustodo label and removed Statusdoing label

added P3 label and removed P2 label