Test for issue caosdb-server#192

Summary

The new function tests the behaviour after the fixed issue caosdb-server#277 (closed) (192 on gitlab.com)

Focus

• Is the test extensive enough?
• Is the expected outcome correct?

Test Environment

pytest -t tests/test_issues_server.py -k 192

Check List for the Author

Please, prepare your MR for a review. Be sure to write a summary and a focus and create gitlab comments for the reviewer. They should guide the reviewer through the changes, explain your changes and also point out open questions. For further good practices have a look at our review guidelines

• All automated tests pass
• Reference related issues
• Up-to-date CHANGELOG.md (or not necessary)
• Up-to-date JSON schema (or not necessary)
• Appropriate user and developer documentation (or not necessary)
  • How do I use the software? Assume "stupid" users.
  • How do I develop or debug the software? Assume novice developers.
• Annotations in code (Gitlab comments)
  • Intent of new code
  • Problems with old code
  • Why this implementation?

Check List for the Reviewer

• I understand the intent of this MR
• All automated tests pass
• Up-to-date CHANGELOG.md (or not necessary)
• Appropriate user and developer documentation (or not necessary)
• The test environment setup works and the intended behavior is reproducible in the test environment
• In-code documentation and comments are up-to-date.
• Check: Are there specifications? Are they satisfied?

For further good practices have a look at our review guidelines.

tests/test_issues_server.py

@@ -1134,3 +1134,45 @@ def test_135():
     r1 = db.Record().add_parent("TestRT1").insert()
     r2 = db.Record().add_parent("TestRT1").add_property("TestProp", r1).insert()
     assert len(db.execute_query("FIND ENTITY WHICH IS REFERENCED BY A TestRT1 AS TestProp")) == 1
+
+
+def test_192():
+    """Testing queries with Property by name.
+
+    See https://gitlab.com/caosdb/caosdb-server/-/issues/192
+
+    COUNT Record WHICH HAS price -> Results: 19
+    COUNT Record WHICH HAS Property price -> Results: 19
+    COUNT Record WITH price -> Results: 19
+    COUNT Record WITH Property price -> Results: 0
+    """
+    db.Property(name="testprop", datatype=db.DOUBLE).insert()
+    db.RecordType(name="TestRT").add_property("testprop").insert()
+    db.Record(name="Rec1").add_parent("TestRT").add_property("testprop", value=3.1).insert()
+
+    query1 = "COUNT RECORD WHICH HAS testprop"
+    query2 = "COUNT RECORD WHICH HAS A testprop"
+    query3 = "COUNT RECORD WHICH HAS Property testprop"
+    query4 = "COUNT RECORD WHICH HAS A Property testprop"
+    query5 = "COUNT RECORD WITH testprop"
+    query6 = "COUNT RECORD WITH A testprop"
+    query7 = "COUNT RECORD WITH Property testprop"
+    query8 = "COUNT RECORD WITH A Property testprop"
+
+    count1 = db.execute_query(query1)
+    count2 = db.execute_query(query2)
+    count3 = db.execute_query(query3)
+    count4 = db.execute_query(query4)
+    count5 = db.execute_query(query5)
+    count6 = db.execute_query(query6)
+    count7 = db.execute_query(query7)
+    count8 = db.execute_query(query8)
+
+    assert count1 == 1
+    assert count2 == 1
+    assert count3 == 1
+    assert count4 == 1
+    assert count5 == 1
+    assert count6 == 1
+    assert count7 == 1
+    assert count8 == 1