4. Vector and Ingres : Incompatibilities with Ingres Database : SQL Function Incompatibilities
Share this page                  
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.