Give the following
Table with:
1) primary key "key_uuid"
2) another field named "some_key_uuid"
3) 20-records
4) 12 of 20 have value assigned to "some_key_uuid"
5) 8 of 20 have no value assigned to "Some_key_uuid". Field value is 32-zeroes
Code to locate the 8-records whose "some_key_uuid" contains 32-zeroes:
------------
C_OBJECT($not_assigned1_eso)
C_OBJECT($not_assigned2_eso)
C_TEXT($key_t)
$not_assigned1_eso:=ds[Table name(->[test])].query(Field
name(->[test]some_uuid_key)+" = :1";String(32*"0"))
$key_t:=(32*"0")
$not_assigned2_eso:=ds.test.query("some_uuid_key = :1";$key_t)
QUERY([test];[test]some_uuid_key=(32*"0"))
------------
Why does ORDA **fail** to locate the entities with 32-zeroes in
"some_key_uuid", but legacy 4D **does** locate the 8-records?
Here's what I see in the debugger:
https://i.postimg.cc/Pfy88KhZ/p01-orda-vs-legacy-query.png
**********************************************************************
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
