test: enable `join` duckdb test cases - Githubissues

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.

https://go.risingwave.com/slack

Apache License 2.0

7.06k stars 581 forks source link

test: enable `join` duckdb test cases #5983

Open lmatz opened 2 years ago

lmatz commented 2 years ago

Source: https://github.com/duckdb/duckdb/tree/master/test/sql/join

[x] empty_joins.test
[x] test_complex_join_expr.test
[ ] test_complex_join_structs.test
[x] test_complex_range_join.test
[x] test_join_on_aggregates.test
[x] test_nested_inequality.test
[ ] test_nested_keys.test
[ ] test_nested_payloads.test
[ ] test_not_distinct_from.test_coverage
[x] test_string_payload.test

join/cross_product:

[x] test_cross_product.test
[x] test_cross_product_parallelism.test_slow

join/external:

[ ] external_join_many_duplicates.test_slow
[ ] simple_external_join.test

join/full_outer:

[x] full_outer_join_cache.test
[x] full_outer_join_union.test
[x] test_full_outer_join.test
[x] test_full_outer_join_complex.test
[x] test_full_outer_join_inequality.test
[ ] test_full_outer_join_issue_4252.test
[x] test_full_outer_join_many_matches.test_coverage
[x] test_full_outer_join_parallel.test_slow
[x] test_full_outer_join_range.test

join/iejoin:

[x] test_iejoin.test: Blocked by #6760
[x] test_iejoin_east_west.test
[ ] test_iejoin_events.test: Blocked by setseed support.
[ ] test_iejoin_overlaps.test: Blocked by csv support.
[x] test_iejoin_sort_tasks.test_slow

join/inner:

[x] equality_join_limits.test
[ ] join_cache.test
[ ] join_cross_product.test
[ ] list_join.test
[x] test_eq_ineq_join.test
[x] test_join.test
[ ] test_join_duplicates.test
[ ] test_join_invisible_probe.test_coverage
[ ] test_join_invisible_probe.test_slow
[ ] test_join_perfect_hash.test
[ ] test_join_types.test_coverage
[x] test_lt_join.test
[x] test_range_join.test
[x] test_unequal_join.test
[x] test_unequal_join_duplicates.test
[x] test_using_chain.test
[x] test_using_join.test
[x] test_varchar_join.test

join/left_outer:

[ ] left_join_issue_1172.test
[ ] non_foldable_left_join.test
[x] test_left_outer.test

~join/mark:~ ~- [ ] test_mark_join_types.test_coverage~

join/natural:

[ ] natural_join.test

join/right_outer:

[ ] right_join_complex_null.test
[x] test_right_outer.test

liurenjie1024 commented 1 year ago

Blocked by #6570 #6569