Radosław Waśko
Radosław Waśko
The following code ``` type A B c = 42+2 main = A.B 2 ``` yields: ``` (B 2) ``` I'm not quite sure this is right - it looks...
See example: ``` > t.order_by "A" text_ordering=..Case_Sensitive . print (Error: There was an SQL error: SQL compilation error: syntax error line 1 at position 78 unexpected 'COLLATE'.. [Query was: SELECT...
Like in the title - for 'Standard' tables, Snowflake does not enforce uniqueness of the primary key. One can make it enforce it by creating a `HYBRID` table. Some of...
I've just been trying to do some unrelated performance measurements and I've lost ~15 minutes investigating a weird and unexpected message: ``` There was an SQL error: NULL result in...
### Pull Request Description ### Important Notes ### Checklist Please ensure that the following checklist has been satisfied before submitting the PR: - [ ] The documentation has been updated,...
Consider the following program: ``` from Standard.Base import all main = d_enso = Date.new 2011 12 13 d_java = Date.parse "2014-12-15" IO.println d_enso IO.println d_java ``` run it with `--inspect`...
I've tried using `select_into_database_table` on a single-column, 50k row table. In Postgres this takes roughly 0.7-2.2s, in SQLite also about 0.8s, but in Snowflake it took more than **5 minutes**!...
Similarly to #11294, we want to be able to save a specific `DB_Table` as a data link. This should create a data link that will connect to the same database...
Currently `cross_tab` is only implemented in-memory. We want to implement it for the Snowflake backend using https://docs.snowflake.com/en/sql-reference/constructs/pivot The biggest challenge is that the set of output columns is 'dynamic' -...
Currently `transpose` is only implemented in-memory. We want to have a similar implementation for the Snowflake backend using https://docs.snowflake.com/en/sql-reference/constructs/unpivot If easy, we could enable it in SQL Server too if...