Description
When ORDER BY references a column not present in the projected output, cross-shard ordering can be incorrect.
Example
SELECT id FROM users ORDER BY name;
In this case, PgDog resolves sort columns from RowDescription; if name is not present, the key may be skipped, causing incorrect global ordering.
Description
When
ORDER BYreferences a column not present in the projected output, cross-shard ordering can be incorrect.Example
SELECT id FROM users ORDER BY name;In this case, PgDog resolves sort columns from
RowDescription; ifnameis not present, the key may be skipped, causing incorrect global ordering.