Skip to content
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.

Sign up for GitHub

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

Jump to bottom

[tracking] failed sqlness cases #2367

Closed
55 of 57 tasks
waynexia opened this issue Sep 12, 2023 · 4 comments
Closed
55 of 57 tasks

[tracking] failed sqlness cases #2367

waynexia opened this issue Sep 12, 2023 · 4 comments
Labels
C-enhancement Category Enhancements tracking-issue A tracking issue for a feature.

Comments

@waynexia
Copy link
Member

waynexia commented Sep 12, 2023 •
edited by WenyXu
Loading

What type of enhancement is this?

Tech debt reduction

What does the enhancement do?

  • tests/cases/distributed/explain/join_10_tables.sql @waynexia
  • tests/cases/distributed/explain/multi_partitions.sql @waynexia
  • tests/cases/distributed/explain/order_by.sql @waynexia
  • tests/cases/distributed/explain/single_partition.sql @waynexia
  • tests/cases/distributed/explain/subqueries.sql @waynexia
  • tests/cases/distributed/optimizer/filter_push_down.sql @waynexia
  • tests/cases/distributed/optimizer/order_by.sql @waynexia
  • tests/cases/distributed/tql-explain-analyze/analyze.sql @waynexia
  • tests/cases/distributed/tql-explain-analyze/explain.sql @waynexia
  • tests/cases/standalone/common/system/information_schema.sql @waynexia
  • tests/cases/standalone/common/aggregate/distinct.sql
  • tests/cases/standalone/common/aggregate/distinct_order_by.sql
  • tests/cases/standalone/common/aggregate/sum.sql
  • tests/cases/standalone/common/alter/add_col.sql @evenyag
  • tests/cases/standalone/common/alter/add_col_chain.sql @evenyag
  • tests/cases/standalone/common/alter/add_col_default.sql @evenyag
  • tests/cases/standalone/common/alter/alter_table.sql @evenyag
  • tests/cases/standalone/common/alter/alter_table_first_after.sql @evenyag
  • tests/cases/standalone/common/alter/drop_col.sql @evenyag
  • tests/cases/standalone/common/alter/drop_col_not_null.sql @evenyag
  • tests/cases/standalone/common/alter/drop_col_not_null_next.sql @evenyag
  • tests/cases/standalone/common/alter/rename_table.sql @evenyag
  • tests/cases/standalone/common/basic.sql @zhongzc
  • tests/cases/standalone/common/catalog/schema.sql
  • tests/cases/standalone/common/copy/copy_from_fs_csv.sql
  • tests/cases/standalone/common/copy/copy_from_fs_json.sql
  • tests/cases/standalone/common/copy/copy_from_fs_parquet.sql
  • tests/cases/standalone/common/copy/copy_to_fs.sql
  • tests/cases/standalone/common/create/upper_case_table_name.sql
  • tests/cases/standalone/common/cte/cte.sql
  • tests/cases/standalone/common/cte/cte_in_cte.sql
  • tests/cases/standalone/common/delete/delete.sql
  • tests/cases/standalone/common/insert/big_insert.sql @killme2008
  • tests/cases/standalone/common/insert/insert.sql @killme2008
  • tests/cases/standalone/common/insert/insert_default.sql @killme2008
  • tests/cases/standalone/common/insert/insert_invalid.sql @killme2008
  • tests/cases/standalone/common/insert/insert_select.sql @killme2008
  • tests/cases/standalone/common/order/limit.sql @killme2008
  • tests/cases/standalone/common/order/limit_union.sql @killme2008
  • tests/cases/standalone/common/order/nulls_first.sql @killme2008
  • tests/cases/standalone/common/order/order_by.sql @waynexia
  • tests/cases/standalone/common/order/order_by_exceptions.sql @killme2008
  • tests/cases/standalone/common/order/order_variable_size_payload.sql
  • tests/cases/standalone/common/types/float/nan_aggregate.sql @killme2008
  • tests/cases/standalone/common/types/interval/interval.sql @killme2008
  • tests/cases/standalone/common/types/string/bigstring.sql @killme2008
  • tests/cases/standalone/common/types/string/scan_big_varchar.sql @killme2008
  • tests/cases/standalone/common/types/string/unicode.sql @killme2008
  • tests/cases/standalone/common/types/timestamp/timestamp.sql @killme2008

@MichaelScofield :

  • tests/cases/standalone/common/select/dummy.sql
  • tests/cases/standalone/common/select/like.sql
  • tests/cases/standalone/common/select/range_select.sql
  • tests/cases/standalone/common/tql/aggr_over_time.sql
  • tests/cases/standalone/common/tql/basic.sql
  • tests/cases/standalone/common/tql/binary_operator.sql
  • tests/cases/standalone/common/tql/join.sql
  • tests/cases/standalone/common/tql/operator.sql

Implementation challenges

No response
@waynexia waynexia added C-enhancement Category Enhancements tracking-issue A tracking issue for a feature. labels Sep 12, 2023
This was referenced Sep 13, 2023
Merged
Merged
@waynexia waynexia mentioned this issue Sep 13, 2023
Merged
2 tasks
@evenyag evenyag mentioned this issue Sep 13, 2023
Merged
2 tasks
@waynexia waynexia mentioned this issue Sep 13, 2023
Merged
2 tasks
@evenyag evenyag mentioned this issue Sep 14, 2023
Merged
2 tasks
@waynexia waynexia mentioned this issue Sep 14, 2023
Merged
2 tasks
@WenyXu
Copy link
Member

WenyXu commented Sep 17, 2023 •
edited
Loading

Updates

Remain

  • common/select/range_select
  • common/types/interval/interval

Broken

  • common/alter/rename_table
  • optimizer/filter_push_down
  • show/show_create

@waynexia
Copy link
Member Author

This is what I get from 542e863:

  • distributed/optimizer/filter_push_down.sql
  • distributed/optimizer/order_by.sql
  • distributed/show/show_create.sql
  • standalone/common/alter/alter_table_first_after.sql
  • standalone/common/alter/rename_table.sql
  • standalone/common/cte/cte_in_cte.sql
  • standalone/common/select/range_select.sql
  • standalone/common/tql/aggr_over_time.sql
  • standalone/common/types/interval/interval.sql
  • standalone/common/types/timestamp/timestamp.sql
  • standalone/optimizer/filter_push_down.sql
  • standalone/show/show_create.sql

@killme2008
Copy link
Contributor

The latest result in develop branch:

    "standalone/common/alter/rename_table",
    "standalone/common/select/range_select",
    "standalone/common/types/interval/interval",
    "standalone/optimizer/filter_push_down",
    "standalone/show/show_create",

    "distributed/common/select/range_select",
    "distributed/common/types/interval/interval",
    "distributed/optimizer/order_by",
    "distributed/show/show_create",

@waynexia waynexia mentioned this issue Sep 17, 2023
Merged
2 tasks
@waynexia
Copy link
Member Author

I'm looking at show/show_create

This was referenced Sep 18, 2023
Merged
Merged
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
C-enhancement Category Enhancements tracking-issue A tracking issue for a feature.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@killme2008 @waynexia @WenyXu