c-treeACE V11.0 Release Notes

MAX Scalar Function on Field With Descending Index No Longer Returns MIN Value

In certain situations, a query using max() would return the wrong result when an index existed on (f2,f1) and f1 had the opposite ordering (ASC/DESC) of f2. A query similar to the example below would return the wrong result:

SELECT max(f1) from si142076 where f2 = ' 3'

The logic has been corrected to fix this problem.