Previous Topic

Next Topic

Corrected TOP ... ORDER BY ... c-treeSQL Query Results

A query of the form TOP .... ORDER BY ... produced an incorrect result set.

An optimization to the TOP N clause introduced this faulty logic. Improved maintenance of the cached blocks and storing direct references (as opposed to indirect pointers) to the target tuples resolves this error.