You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I was just being lazy and thought I'd try out a potentially more ergonomic way of writing some example data when I encountered the following unexpected output.
PRQL input
from s"SELECT UNNEST([0.1, 0.2, 0.3, 1, 2, 4])"
SQL output
WITH table_0 AS (
SELECT
UNNEST([0.1, 0.2, 0.3, 1, 2, 4])
)
SELECT*FROM
table_0
-- Generated by PRQL compiler version:0.11.3 (https://prql-lang.org)
Expected SQL output
WITH table_0 AS (
SELECT
UNNEST([0.1, 0.2, 0.3, 1, 2, 4])
)
SELECT*FROM
table_0
-- Generated by PRQL compiler version:0.11.3 (https://prql-lang.org)
MVCE confirmation
Minimal example
New issue
Anything else?
The SQL looks fine but the Query Results are surprising:
unnest(main.list_value(0.1, 0.2, 0.3, 1, 2, 4))
1
2
3
10
20
40
Compare this with the results from shell.duckdb.org:
What happened?
I was just being lazy and thought I'd try out a potentially more ergonomic way of writing some example data when I encountered the following unexpected output.
PRQL input
SQL output
Expected SQL output
MVCE confirmation
Anything else?
The SQL looks fine but the Query Results are surprising:
unnest(main.list_value(0.1, 0.2, 0.3, 1, 2, 4))
1
2
3
10
20
40
Compare this with the results from shell.duckdb.org:
The text was updated successfully, but these errors were encountered: