Fixing Database tests and Snowflake Dialect - part 2 out of ... - Githubissues

enso-org / enso

Hybrid visual and textual functional programming.

https://enso.org

Apache License 2.0

7.31k stars 317 forks source link

Fixing Database tests and Snowflake Dialect - part 2 out of ... #10319

Closed radeusgd closed 3 days ago

radeusgd commented 1 week ago

Pull Request Description

Part of #9486
Fixing our tests to not rely on deterministic ordering of created Tables in Database backends
- Before, SQLite and Postgres used to mostly return rows in the order they were inserted in, but Snowflake does not.
Fixing various parts of Snowflake dialect.

Important Notes

Checklist

Please ensure that the following checklist has been satisfied before submitting the PR:

[x] The documentation has been updated, if necessary.
[ ] Screenshots/screencasts have been attached, if there are any visual changes. For interactive or animated visual changes, a screencast is preferred.
[x] All code follows the Scala, Java, TypeScript, and Rust style guides. In case you are using a language not listed above, follow the Rust style guide.
[x] Unit tests have been written where possible.