In the alter table regression test, alter_table.sql, it says:
-- 20 values, sorted
SELECT unique1 FROM ten_k WHERE unique1 < 20;
-- 20 values, sorted
SELECT unique2 FROM ten_k WHERE unique2 < 20;
Why sorted? Shouldn't it be
SELECT unique1 FROM ten_k WHERE unique1 < 20 ORDER BY unique1;
if we really expect the output to be sorted?
Cheers,
Patrick