User Guide > User Guide > Vector and Ingres > Incompatibilities with Ingres Database > SQL Function Incompatibilities
Was this helpful?
SQL Function Incompatibilities
The following restrictions or incompatibilities between Vector and traditional Ingres are known:
• Vector 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 Vector 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 Vector and Ingres tables. Furthermore, it may not return the same results for every Vector query.
Last modified date: 11/09/2022