c-treeACE V10.3 Release Notes

SQL - Query containing scalar subquery with outer references returns incorrect NULL column values

Certain SQL queries were returning rows in which some columns erroneously contained NULLs. When c-treeACE SQL is run with pushdown expression support disabled (by adding SQL_OPTION NO_PUSHDOWN to ctsrvr.cfg), the query returns the expected results. The logic has been changed to correct the erroneous NULLs.