Jeff D. Hanson

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...

I'm seeing something similar with an IIF (… IS NULL) statement of the form: VAL( IIF( VARCHAR IS NULL, '0', VARCHAR) * IIF( DOUBLE IS NULL, 0, DOUBLE) If the double precision value is between 0 and 1 then the result is 0 which is wrong.

I'm seeing something similar with an IFF (… IS NULL) statement of the form: VAL( IFF( VARCHAR IS NULL, '0', VARCHAR) * IFF( DOUBLE IS NULL, 0, DOUBLE) If the double precision value is between 0 and 1 then the result is 0 which is wrong.

UCanAccess 5.0.1 Win10 and Xubuntu 20.04 DBeaver 21.2.5 and LibreOffice 7.2.2.2 OpenJDK 11.0.12+7 (DBeaver), Temurin-11.0.13+8 (LibreOffice) ACE12 DB SELECT (something), NZ (constants), FROM (whatever) NZ(1, 0) = 1 NZ(1) = 1 NZ(0.1, 0) = 0.1 NZ(0.1) = 0 <<< WAT? Encountered this with a query that was checking a double-precision column value. Result was as expected unless the value was less than 1 and the optional null return value wasn't specified.

Need deterministic machine-readable log

I tried x86 DA on Wine 1.7.34 (Xubuntu 14.04) with MAPV (http://www.abhisoft.net/mapv/)...

I tried x86 DA on Wine 1.7.34 (Xubuntu 14.04) with MAPV (http://www.abhisoft.net/mapv/)...