graph-node icon indicating copy to clipboard operation
graph-node copied to clipboard

[Bug] Ordering by child attribute is not always deterministic

Open lutter opened this issue 1 year ago • 1 comments

Bug report

In a query for parents that orders by child__id, if many parents belong to the same child, the ordering is not deterministic because the SQL query only orders by child.id. To make it deterministic, we need to order by child.id, parent.id

lutter avatar Mar 29 '24 01:03 lutter