adriangb commented on PR #20329:
URL: https://github.com/apache/datafusion/pull/20329#issuecomment-3893693940
On main:
```
cargo test --test sqllogictests -- sort_pushdown
Finished `test` profile [unoptimized + debuginfo] target(s) in 0.18s
Running bin/sqllogictests.rs
(target/debug/deps/sqllogictests-cd2788d771c0e63f)
Completed 1 test files in 0 seconds
External error: 9 errors
in file
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt
1. query result mismatch:
[SQL] EXPLAIN SELECT * FROM reversed_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
logical_plan
01)Sort: reversed_parquet.id ASC NULLS LAST
02)--TableScan: reversed_parquet projection=[id, value]
- physical_plan
- 01)SortExec: expr=[id@0 ASC NULLS LAST], preserve_partitioning=[false]
- 02)--DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/a_high.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/b_mid.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/c_low.parquet]]},
projection=[id, value], file_type=parquet
+ physical_plan DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/a_high.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/b_mid.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/c_low.parquet]]},
projection=[id, value], file_type=parquet
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:900
2. query result mismatch:
[SQL] SELECT * FROM reversed_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
- 1 100
- 2 200
- 3 300
+ 7 700
+ 8 800
+ 9 900
4 400
5 500
6 600
- 7 700
- 8 800
- 9 900
+ 1 100
+ 2 200
+ 3 300
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:911
3. query result mismatch:
[SQL] EXPLAIN SELECT * FROM overlap_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
logical_plan
01)Sort: overlap_parquet.id ASC NULLS LAST
02)--TableScan: overlap_parquet projection=[id, value]
- physical_plan
- 01)SortExec: expr=[id@0 ASC NULLS LAST], preserve_partitioning=[false]
- 02)--DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/overlap/file_x.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/overlap/file_y.parquet]]},
projection=[id, value], file_type=parquet
+ physical_plan DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/overlap/file_x.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/overlap/file_y.parquet]]},
projection=[id, value], file_type=parquet
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:951
4. query result mismatch:
[SQL] SELECT * FROM overlap_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
1 100
+ 3 300
+ 5 500
2 200
- 3 300
4 400
- 5 500
6 600
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:962
5. query result mismatch:
[SQL] EXPLAIN SELECT * FROM reversed_with_order_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
logical_plan
01)Sort: reversed_with_order_parquet.id ASC NULLS LAST
02)--TableScan: reversed_with_order_parquet projection=[id, value]
- physical_plan
- 01)SortExec: expr=[id@0 ASC NULLS LAST], preserve_partitioning=[false]
- 02)--DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/a_high.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/b_mid.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/c_low.parquet]]},
projection=[id, value], file_type=parquet
+ physical_plan DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/a_high.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/b_mid.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/reversed/c_low.parquet]]},
projection=[id, value], file_type=parquet
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:984
6. query result mismatch:
[SQL] SELECT * FROM reversed_with_order_parquet ORDER BY id ASC;
[Diff] (-expected|+actual)
- 1 100
- 2 200
- 3 300
+ 7 700
+ 8 800
+ 9 900
4 400
5 500
6 600
- 7 700
- 8 800
- 9 900
+ 1 100
+ 2 200
+ 3 300
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:995
7. query result mismatch:
[SQL] EXPLAIN SELECT * FROM desc_reversed_parquet ORDER BY id DESC;
[Diff] (-expected|+actual)
logical_plan
01)Sort: desc_reversed_parquet.id DESC NULLS FIRST
02)--TableScan: desc_reversed_parquet projection=[id, value]
- physical_plan
- 01)SortExec: expr=[id@0 DESC], preserve_partitioning=[false]
- 02)--DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/desc_reversed/a_low.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/desc_reversed/b_high.parquet]]},
projection=[id, value], file_type=parquet
+ physical_plan DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/desc_reversed/a_low.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/desc_reversed/b_high.parquet]]},
projection=[id, value], file_type=parquet
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:1123
8. query result mismatch:
[SQL] SELECT * FROM desc_reversed_parquet ORDER BY id DESC;
[Diff] (-expected|+actual)
+ 3 300
+ 2 200
+ 1 100
9 900
8 800
- 7 700
- 3 300
- 2 200
- 1 100
+ 7 700
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:1134
9. query result mismatch:
[SQL] EXPLAIN SELECT * FROM multi_col_parquet ORDER BY category ASC, id ASC;
[Diff] (-expected|+actual)
logical_plan
01)Sort: multi_col_parquet.category ASC NULLS LAST, multi_col_parquet.id
ASC NULLS LAST
02)--TableScan: multi_col_parquet projection=[category, id, value]
- physical_plan
- 01)SortExec: expr=[category@0 ASC NULLS LAST, id@1 ASC NULLS LAST],
preserve_partitioning=[false]
- 02)--DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/multi_col/a_first.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/multi_col/b_second.parquet]]},
projection=[category, id, value], file_type=parquet
+ physical_plan DataSourceExec: file_groups={1 group:
[[WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/multi_col/a_first.parquet,
WORKSPACE_ROOT/datafusion/sqllogictest/test_files/scratch/sort_pushdown/multi_col/b_second.parquet]]},
projection=[category, id, value], file_type=parquet
at
/Users/adrian/GitHub/datafusion-clone/datafusion/sqllogictest/test_files/sort_pushdown.slt:1178
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
