UCanAccess 5.0.1 Win10 and Xubuntu 20.04 DBeaver 21.3.3 and LibreOffice 7.2.5.2 OpenJDK 11.0.12+7 (DBeaver), Temurin-11.0.13+8 (LibreOffice) ACE (ODBC) 16.00.4999.1000 (x64), 14.00.7248.5000 (x32) ACE12 DB
SELECT [Something], StrComp('A','B',0) FROM [Table]
Basic comparison works normally for binary an text modes using characters but not if one of the values is changed to NULL.
ACE (using ODBC and LibreOffice Base) returns a null as expected.
UCanAccess (DBeaver and LibreOffice using JDBC) returns an SQL Error [46000].
Encountered this with a query against a field which had a null value in some records.
Log in to post a comment.
UCanAccess 5.0.1
Win10 and Xubuntu 20.04
DBeaver 21.3.3 and LibreOffice 7.2.5.2
OpenJDK 11.0.12+7 (DBeaver), Temurin-11.0.13+8 (LibreOffice)
ACE (ODBC) 16.00.4999.1000 (x64), 14.00.7248.5000 (x32)
ACE12 DB
SELECT
[Something],
StrComp('A','B',0)
FROM [Table]
Basic comparison works normally for binary an text modes using characters but not if one of the values is changed to NULL.
ACE (using ODBC and LibreOffice Base) returns a null as expected.
UCanAccess (DBeaver and LibreOffice using JDBC) returns an SQL Error [46000].
Encountered this with a query against a field which had a null value in some records.