undefined | Better HN

0 pointsmycall6y ago0 comments

The problem with SQL windowing functions (OVER ORDER BY, LAG/LEAD, RANK, etc) is that they are nondeterministic.

0 comments

1 comments · 1 top-level

They are only indeterminate when the SQL engine is given an ambiguous ordering. If you specify the ordering without ambiguity, it's entirely deterministic.

Eg: indeterminate in -> indeterminate out

but determinate in -> determinate out.

j / k navigate · click thread line to collapse