You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
is nondeterministic if multiple parents point to the same child. To make this entirely clear, assume there is only one instance of Child. The SQL query that gets generated is roughly
select*from parent p
left join child c on (c.id=p.child)
where ...
order byc.id
But when multiple rows in p have the same p.child, that ordering is ill-defined. We'd need to change that to order by c.id, p.id to make that deterministic.
The text was updated successfully, but these errors were encountered:
Bug report
With a schema like
the result for a query like
is nondeterministic if multiple parents point to the same child. To make this entirely clear, assume there is only one instance of
Child
. The SQL query that gets generated is roughlyBut when multiple rows in
p
have the samep.child
, that ordering is ill-defined. We'd need to change that toorder by c.id, p.id
to make that deterministic.The text was updated successfully, but these errors were encountered: