3 ms·
I'm not sure I even understand the sample SQL, given: > Each snapshot can have one or two parents. When merging branches, we perform a breadth-first search on
by e12e 3y ago
I'm not sure I even understand the sample SQL, given:
> Each snapshot can have one or two parents. When merging branches, we perform a breadth-first search on the history of each change until we find the common ancestor between both branches. This is the merge base.
And the SQL:
select * from schema_snapshots where id = 20
(...)
schema_snapshots where id = 24
// *thousands more queries*
Why select star here? Surely they mean:
SELECT left_parent_id as parent_id FROM schema_snapshots )
UNION
(SELECT right_parent_id as parent_id FROM schema_snapshots)
WHERE id in (1,2,3...)
or something?