ESD #10 corrects a problem where Sybase IQ returned the same error (Error -845) for two different situations.
Now a database created with JAVA ON correctly reports a different error for incorrect dotted references than a database created with JAVA OFF.
In a database created with JAVA OFF,
the following statement reports error -845, SQLSTATE_INVALID_COLUMN_QUALIFICATION,
"Owner used in a qualified column reference does not match correlation name."
CREATE TABLE dot ( a int, b int ); INSERT dot VALUES ( 1, 1 ); COMMIT; SELECT * FROM dot WHERE dot..a = 100;
In a database created with JAVA ON, the
statement reports error -706, SQLSTATE_OMNI_SERVER_NOT_CAPABLE,
"Remote server does not have the ability to support this statement."