Store and search text properties with empty String

Created by: Timm Fitschen

    r = db.Record()
    r.add_parent("Test")
    r.add_property("te", value="leer")
    r.insert()
    assert_equals(db.execute_query("FIND Test with te='leer'")[0].id, r.id)
    r.delete()
    r = db.Record()
    r.add_parent("Test")
    r.add_property("te", value="")
    r.insert()
    assert_equals(db.execute_query("FIND Test with te=''")[0].id, r.id)
    r.delete()

fails with

 caosdb.exceptions.TransactionError: TransactionError: An error occured during the parsing of this query. Maybe you use a wrong syntax?

Another problem with list of empty strings:

    r = db.Record()
    r.add_parent("Test")
    r.add_property("tl", value=["bla", "", None], datatype=db.LIST(db.TEXT))
    r.insert()

Imported comments:

By Henrik tom Wörden on 2020-05-06T06:13:23.515Z

mentioned in commit caosdb-pylib@d658f0c3

By Timm Fitschen on 2020-05-04T13:55:25.418Z

mentioned in merge request caosdb-pylib!22 (merged)

By Timm Fitschen on 2020-02-14T13:48:49.201Z

closed

By Timm Fitschen on 2020-02-14T11:13:11.777Z

mentioned in merge request !36 (merged)

By Timm Fitschen on 2020-02-12T08:35:09.092Z

changed the description

By Timm Fitschen on 2020-01-27T08:54:13.489Z

changed due date to February 07, 2020

By Timm Fitschen on 2019-09-11T15:04:18.997Z

changed due date to September 18, 2019

By Timm Fitschen on 2019-09-03T07:38:49.993Z

changed due date to September 11, 2019