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
ORDER BY with nested list type gives wrong result.
To Reproduce
CREATETABLEtest(col1 INT, col2 INT2[][][][][][]);
INSERT INTO test VALUES(1000000000, null), (1000000001, [[[[[[]]]]]]), (null, [[[[[[]]]]]]), (null, [[[[[[]]]]]]), (1, [[[[[[]]]]]]);
SELECT col1, col2 FROM test ORDER BY col1 NULLS LAST, col2;
What happens?
ORDER BY with nested list type gives wrong result.
To Reproduce
OS:
x64
DuckDB Version:
main
DuckDB Client:
cmd
Full Name:
gitccl
Affiliation:
Zhejiang University
What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.
I have tested with a source build
Did you include all relevant data sets for reproducing the issue?
Yes
Did you include all code required to reproduce the issue?
Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
The text was updated successfully, but these errors were encountered: