Corrected TOP ... ORDER BY ... c-treeSQL Query ResultsA 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. |
|||