JDBC returns false for all booleans

[bshalke]

Describe the bug When requesting values from the ML JDBC server, all booleans will be returned as false

To Reproduce Install the ML JDBC driver Insert the test TDE found here: https://github.com/marklogic-community/ml-jdbc-driver/blob/master/TDE_JDBCTestDataTypes.xml View TDE Observe that all boolean values are false, even though the TDE explicitly sets them to true

Calling the same TDE from the Query Console results in the correct behavior.

Expected behavior Boolean values should match what is in the database

Screenshots

Desktop (please complete the following information):

• OS: Windows 10
• Version ML 9-7, JDBC 42.2, DbVisualizer 10.0.24

Additional context Reproduced on multiple ML clusters, with multiple TDE definitions, with DbVisualizer and Coveo consumers.

[bobstarbird]

ml-jdbc-driver\src\main\java\org\postgresql\jdbc\PgResultSet.java

if (Oid.BOOL == fields[col].getOID()) { final byte[] v = this_row[col]; return (1 == v.length) && (116 == v[0]); // 116 = 't' }

So PostgeSQL vs MarkLogic (xquery) would suggest a quick hack but not a kludge return (116 == v[0]); // 116 = 't'