Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » Remote data and bulk operations » Remote data access » Internal operations » Internal operations performed on queries


Query normalization

Referenced objects in the query are verified and some data type compatibility is checked.

For example, consider the following query:

WHERE c1 = 10;

The query normalization stage verifies that table t1 with a column c1 exists in the system tables. It also verifies that the data type of column c1 is compatible with the value 10. If the column's data type is TIMESTAMP, for example, this statement is rejected.