You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "cardigan1008 (via GitHub)" <gi...@apache.org> on 2023/07/10 04:53:14 UTC
[GitHub] [shardingsphere] cardigan1008 opened a new issue, #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
cardigan1008 opened a new issue, #26871:
URL: https://github.com/apache/shardingsphere/issues/26871
This issue is created to track my PRs for OSPP 2023.
### Background
ShardingSphere SQL federation engine provides support for complex SQL statements, which can well support cross-database connection queries, subqueries, aggregate queries, and other statements. An important part of the SQL federation engine is to convert the SQL statements parsed by ShardingSphere into SqlNode and use Calcite to implement SQL optimization and federated queries.
### Task
Resolve issues that occur during the conversion process of SQLNodeConverterEngine for MySQL/PostgreSQL/opengauss. The specific exception case list is as follows.
- [ ] select_extract_function
- [ ] select_group_by_with_having_and_window
- [ ] select_not_between_with_single_table
- [ ] select_not_in_with_single_table
- [ ] select_string_constant_type_cast
- [ ] select_where_with_predicate_with_in_subquery
- [ ] select_with_case_when_then_in_group_by_item_and_order_by_item
- [ ] select_with_database_name_and_schema_name_in_table
- [ ] select_with_dollar_parameter_for_postgresql
- [ ] select_with_exists_sub_query_with_project
- [ ] select_where_with_simple_expr_with_not
- [ ] select_where_with_simple_expr_with_odbc_escape_syntax
- [ ] select_where_with_simple_expr_with_row
- [ ] select_where_with_simple_expr_with_tilde
- [ ] select_where_with_simple_expr_with_variable
- [ ] select_window_function
- [ ] select_with_assignment_operator
- [ ] select_with_assignment_operator_and_keyword
- [ ] select_with_case_expression
- [ ] select_with_collate_with_marker
- [ ] select_with_date_format_function
- [ ] select_with_exists_sub_query_with_project
- [ ] select_with_function_name
- [ ] select_with_json_value_return_type
- [ ] select_with_match_against
- [ ] select_with_regexp
- [ ] select_with_schema_name_in_column_projection
- [ ] select_with_schema_name_in_shorthand_projection
- [ ] select_with_spatial_function
- [ ] select_with_trim_expr
- [ ] select_with_trim_expr_from_expr
####
--
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: notifications-unsubscribe@shardingsphere.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #26871:
URL: https://github.com/apache/shardingsphere/issues/26871#issuecomment-1630487627
> Hi @strongduanmu , could you please assign this issue to me? Thank you.
@cardigan1008 Assigned, welcome to ospp 2023.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] github-actions[bot] commented on issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26871:
URL: https://github.com/apache/shardingsphere/issues/26871#issuecomment-1693873882
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] cardigan1008 commented on issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "cardigan1008 (via GitHub)" <gi...@apache.org>.
cardigan1008 commented on issue #26871:
URL: https://github.com/apache/shardingsphere/issues/26871#issuecomment-1628583442
Hi @strongduanmu , could you please assign this issue to me? Thank you.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] zhaojinchao95 closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "zhaojinchao95 (via GitHub)" <gi...@apache.org>.
zhaojinchao95 closed issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
URL: https://github.com/apache/shardingsphere/issues/26871
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [shardingsphere] strongduanmu commented on issue #26871: [OSPP 2023 ]Enhance SQLNodeConverterEngine to support more MySQL/PostgreSQL/opengauss SQL statements.
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #26871:
URL: https://github.com/apache/shardingsphere/issues/26871#issuecomment-1704975467
Since all task has been finished, I will close this issue.
--
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: notifications-unsubscribe@shardingsphere.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org