User Guide > User Guide > Analytics Engine and Ingres > Incompatibilities with Ingres Database > SQL Function Incompatibilities
Was this helpful?
SQL Function Incompatibilities
The following restrictions or incompatibilities between Analytics Engine and traditional Ingres are known:
• Analytics Engine supports constant LIKE patterns only. The LIKE predicate does not support a range of characters (separated by a dash within escaped brackets).
• The BEGINNING, CONTAINING, and ENDING predicates do not support the ESCAPE clause.
• The HASH function returns different results in Analytics Engine than in traditional Ingres due to a different hash computation algorithm.
• Using the RANDOM function after issuing SET RANDOM_SEED will not return the same results for Analytics Engine and Ingres tables. Furthermore, it may not return the same results for every Analytics Engine query.
Last modified date: 09/11/2026