Version 4.0.5
Predicate was missed during query rewrite
SQL Error: DATA_READ ERROR: The JDBC storage plugin failed while trying setup the SQL query.
sql SELECT *
FROM (SELECT [PartiesID], [IsUnique], [PartyAddressCountryISOCode] COLLATE LATIN1_GENERAL_BIN2 AS [PartyAddressCountryISOCode]
FROM [PartiesCurrent]) AS [PartiesCurrent]
WHERE [IsUnique]
plugin *****
SqlOperatorImpl JDBC_SUB_SCAN
Location 22:0:3
SqlOperatorImpl JDBC_SUB_SCAN
Location 22:0:3
Fragment 22:0
(com.microsoft.sqlserver.jdbc.SQLServerException) An expression of non-boolean type specified in a context where a condition is expected, near ‘IsUnique’
in original query table in joined like that
inner join [PartiesCurrent] PC ON PC.IsUnique = 1
in the case I move “PC.IsUnique = 1” to the where condition is ignored completely
Current workaround -> is to use raw reflection