You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/03/03 10:30:56 UTC
[GitHub] [incubator-shardingsphere] tristaZero opened a new issue #4582:
Parsing SubQuery
tristaZero opened a new issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582
We plan to support sub query SQL in the future, as the first step of which, parsing sub query is viewed as our current task.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-595279097
Try hard!!!
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu closed issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero commented on issue #4582:
Parsing SubQuery
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-595650292
@phoema Hi
Subquery SQL is not working well currently, and you can see we are working on it. Please wait for our good news.
Thx
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-595326137
Version lastest
5.0.0-RC1-SNAPSHOT
DB:MySql
org.apache.shardingsphere.sql.parser.SQLParserEngine
public SQLStatement parse(final String sql, final boolean useCache)
tables.size==0
what with wrong this sql?
SQL One:
SELECT COUNT(1) FROM ( SELECT * FROM ( SELECT tbl_biz.id AS id, tbl_biz.payer_type AS payer_type, tbl_biz.payer AS payer, tbl_biz.sign AS sign, tbl_biz.code AS code, tbl_biz.type AS type, tbl_biz.case_id AS case_id, tbl_biz.policy AS policy, tbl_biz.amount AS amount, tbl_biz.currency AS currency, tbl_biz.rate AS rate, tbl_biz.in_deadline AS in_deadline, tbl_biz.official_deadline AS official_deadline, tbl_biz.pay_time AS pay_time, tbl_biz.fee_user AS fee_user, tbl_biz.order_id AS order_id, tbl_biz.remark AS remark, tbl_biz.amount_rmb AS amount_rmb, tbl_biz.create_time AS create_time, tbl_biz.create_by AS create_by, tbl_biz.update_time AS update_time, tbl_biz.update_by AS update_by, tbl_biz.receive_status AS receive_status, tbl_biz.pay_status AS pay_status, tbl_biz.pay_union_id AS pay_union_id, tbl_biz.receive_union_id AS receive_union_id, tmp.payer_name AS payer_name, tbl_fee.official_code AS official_code, tbl_fee.name AS fee_code_name, tbl_fee.sub_type AS sub_type, IFNULL(tbl_biz.fee_step,tbl_fee.fee_step) AS fee_step, tbl_fee.type AS fee_type, tbl_user.user_name AS fee_user_name, tbl_info.case_type AS case_type, tbl_info.case_sub_type AS case_sub_type, tbl_info.apn AS apn, tbl_info.scnfnd AS scnfnd, tbl_info.fee_discount AS fee_discount, tbl_info.application_date AS application_date, tbl_info.case_status AS case_status, tbl_info.serial AS serial, tbl_info.name AS name, tbl_info.contract_number AS contract_number, tbl_info.customerid AS customer_id, tbl_info.customer_serial AS customer_serial, tbl_info.customer_name AS customer_name, tbl_info.customer_linker_name AS customer_linker_name, tbl_info.salesuser_name AS salesuser_name, tbl_info.serviceuser_name AS serviceuser_name, tbl_info.agent_name AS agent_name, tbl_info.commit_agency AS commit_agency, tbl_info.commit_agency_name AS commit_agency_name, tbl_info.branch_anency_name AS branch_anency_name, tbl_info.case_type_name AS case_type_name, tbl_info.case_label AS case_label, tbl_info.status_name AS status_name, pay_status_dict.name AS pay_status_name, receive_status_dict.name AS receive_status_name, fee_monitor_dict.name AS policy_name, fee_sign_dict.name AS sign_name, tbl_biz.notice_id AS notice_id, tbl_notice.title as notice_title, tbl_notice.dispatch_date as notice_dispatch_date, tbl_notice.dispatch_number as notice_dispatch_number FROM biz_fee tbl_biz LEFT JOIN v_multi_users tmp ON ( ( ( tbl_biz.payer_type = CONVERT ( tmp.payer_type USING utf8 ) ) AND ( tbl_biz.payer = tmp.payer_id ) ) ) LEFT JOIN sys_fee tbl_fee ON ( ( tbl_biz.code = tbl_fee.id ) ) LEFT JOIN sys_user tbl_user ON ( ( tbl_biz.fee_user = tbl_user.id ) ) LEFT JOIN sys_dict_data pay_status_dict ON ( tbl_biz.pay_status = pay_status_dict.value and pay_status_dict.dict_type = 'fee_status_type') LEFT JOIN sys_dict_data receive_status_dict ON ( tbl_biz.receive_status = receive_status_dict.value and receive_status_dict.dict_type = 'fee_status_type') LEFT JOIN sys_dict_data fee_monitor_dict ON ( tbl_biz.policy = fee_monitor_dict.value and fee_monitor_dict.dict_type = 'fee_monitor_type') LEFT JOIN sys_dict_data fee_sign_dict ON ( tbl_biz.sign = fee_sign_dict.value and fee_sign_dict.dict_type = 'fee_sign') JOIN v_info_case tbl_info ON ( ( tbl_biz.case_id = tbl_info.id ) ) LEFT JOIN biz_official_notice tbl_notice ON ( ( tbl_biz.notice_id = tbl_notice.id ) ) ) tbl WHERE (fee_user = ?) ORDER BY id DESC ) TOTAL
all my tables is HintManager
so,it may be special DB like testdb1.
but SQLParserEngine Parser tables.size ==0 and
why Actual SQL: master ?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu closed issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
terrymanu closed issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero commented on issue #4582:
Parsing SubQuery
Posted by GitBox <gi...@apache.org>.
tristaZero commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-596077174
@phoema
This issue is just part of subquery task which will take more time to do. :)
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-596375465
excuse me,
when will subquery work well？
have a plan?
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] phoema commented on issue #4582: Parsing
SubQuery
Posted by GitBox <gi...@apache.org>.
phoema commented on issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582#issuecomment-596061473
sorry,
I saw issue 4582 is closed ,
I thought it would be work well.
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tristaZero opened a new issue #4582:
Parsing SubQuery
Posted by GitBox <gi...@apache.org>.
tristaZero opened a new issue #4582: Parsing SubQuery
URL: https://github.com/apache/incubator-shardingsphere/issues/4582
We plan to support sub query SQL in the future, as the first step of which, parsing sub query is viewed as our current task.
- [x] Correct definition for sub query.
- [x] Create SubqueryProjectionSegment
- [x] Create SubqueryExpressionSegment
----------------------------------------------------------------
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.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services