Window function ORDER BY should be optional when frame specification doesn't require it

[knutwannheden]

According to the documentation:

RANGE on a numeric or temporal expr requires ORDER BY on a numeric or temporal expression, respectively.

Thus it should be allowed to write a window function like:

sum(b) over (partition by a range between unbounded preceding and unbounded following)

MySQL also accepts this, but Dolt raises an error: [HY000][1105] a range's order by must be one expression; found: 0.

[fulghum]

Thanks for reporting this one Knut. You're right that Dolt isn't matching MySQL's behavior here. We'll dig in.

[fulghum]

Hey @knutwannheden, I got the fix for this one merged into go-mysql-server and I'll get Dolt updated with this latest version this afternoon. I'll ping again when this goes out in a Dolt release, likely early next week.

[fulghum]

Just closing the loop here... Dolt 0.40.28 was just released, and contains this fix.

Thanks for reporting this one so we could get it fixed! 🙏