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; SQL Anywhere treats CHAR data as if it were VARCHAR.
When the RAND function is passed an argument, the behavior is deterministic in Sybase IQ and nondeterministic in SQL Anywhere.