In a few unusual circumstances, differences in semantics between SQL Anywhere and Sybase IQ may produce unexpected query results. These circumstances are:
A query is issued from inside a user-defined function
A SELECT statement has no FROM clause
A FROM clause contains some tables that were created IN SYSTEM and others that were not created IN SYSTEM
In these circumstances, subtle differences between the semantics of SQL Anywhere and Sybase IQ may be exposed. These differences include:
Sybase IQ treats the CHAR and VARCHAR data types as distinct and different, and SQL Anywhere treats CHAR data as if it were VARCHAR
The behavior of the RAND function when passed an argument is deterministic in Sybase IQ and non-deterministic in SQL Anywhere