Server cannot parse NaNs in lists
In [21]: r = db.Record().add_parent("Guitar").add_property("ticket_sales", value=["nan"],datatype="LIST<DOUBLE>").insert()
---------------------------------------------------------------------------
TransactionError Traceback (most recent call last)
<ipython-input-21-4c8204136846> in <module>
----> 1 r = db.Record().add_parent("Guitar").add_property("ticket_sales", value=["nan"],datatype="LIST<DOUBLE>").insert()
~/CaosDB/caosdb-pylib/src/caosdb/common/models.py in insert(self, raise_exception_on_error, unique, sync, strict, flags)
1113 """
1114
-> 1115 return Container().append(self).insert(
1116 strict=strict,
1117 raise_exception_on_error=raise_exception_on_error,
~/CaosDB/caosdb-pylib/src/caosdb/common/models.py in insert(self, strict, raise_exception_on_error, unique, sync, flags)
3429
3430 if raise_exception_on_error:
-> 3431 raise_errors(self)
3432
3433 return self
~/CaosDB/caosdb-pylib/src/caosdb/common/models.py in raise_errors(arg0)
4337
4338 if len(transaction_error.all_errors) > 0:
-> 4339 raise transaction_error
4340 # Cover the special case of an empty container with error
4341 # message(s) (e.g. query syntax error)
TransactionError: TransactionError: One or more entities are not qualified. None of them have been inserted/updated/deleted.
+--| REASONS |--
| -> RECORD (id: -1) CAUSED |UnqualifiedPropertiesError: Entity has unqualified properties.
| +--| REASONS |--
| | -> PROPERTY (id: 104, name: 'ticket_sales') CAUSED | |EntityError: Cannot parse value to double.
| +----------------
+----------------
In [22]: r = db.Record().add_parent("Guitar").add_property("ticket_sales", value="nan",datatype="DOUBLE").insert()
If you compare the failing with the successful line, you see, that giving NaN within a list leads to an error