-
Notifications
You must be signed in to change notification settings - Fork 205
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Unexpected result with s-string including UNNEST #4385
Labels
web
related to the website or the playground
Comments
Looks like something in the web/js bindings because even the following produces the same results: PRQL from [{a=0.1}, {a=1}] SQL WITH table_0 AS (
SELECT
0.1 AS a
UNION
ALL
SELECT
1 AS a
)
SELECT
a
FROM
table_0
-- Generated by PRQL compiler version:0.11.3 (https://prql-lang.org) Query Results
|
max-sixty
added
web
related to the website or the playground
and removed
bug
Invalid compiler output or panic
labels
May 30, 2024
Yes, agree this seems like a JS bindings issue... |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
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: