reverseUnorderedSelects

Queries or sets the reverse_unordered_selects flag.

This pragma is primarily used for testing. When enabled (true), SELECT statements that do not have an ORDER BY clause will return their results in the reverse of the normal order.

For a normal table scan, this means rows are returned from last to first. For an index scan, rows are returned in descending order of the indexed columns.

This feature is intended to help find application code that relies on the unspecified and non-guaranteed ordering of SELECT statements without an ORDER BY clause. The default is false.

See also