phoema opened a new issue, #27298:
URL: https://github.com/apache/shardingsphere/issues/27298
when I set hintValue = saas-test
select sql can doSharding
but explain select not doSharding
next is log.txt
2023-07-19 17:34:56,065 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- ==> Preparing: Explain SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case WHERE (case_type = ?) ORDER BY id DESC
2023-07-19 17:34:56,075 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- ==> Parameters: 1(String)
2023-07-19 17:34:56,080 [http-nio-8084-exec-2] INFO (SQLLogger.java:73)-
Logic SQL: Explain SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case
WHERE (case_type = ?) ORDER BY id DESC
2023-07-19 17:34:56,081 [http-nio-8084-exec-2] INFO (SQLLogger.java:73)-
Actual SQL: master ::: Explain SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case
WHERE (case_type = ?) ORDER BY id DESC ::: [1]
2023-07-19 17:34:56,099 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- <== Total: 45
2023-07-19 17:34:56,100 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- ==> Preparing: SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case WHERE (case_type = ?) ORDER BY id DESC LIMIT ?
2023-07-19 17:34:56,100 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- ==> Parameters: 1(String), 10(Long)
2023-07-19 17:34:56,100 [http-nio-8084-exec-2] DEBUG
(HintShardingStrategy.java:30)-
doSharding=[saas-test]|系统运维|shardingValue=HintShardingValue(logicTableName=v_info_case,
columnName=, values=[saas-test])|availableTargetNames=[master, saas-test,
saas-trial]
2023-07-19 17:34:56,101 [http-nio-8084-exec-2] INFO (SQLLogger.java:73)-
Logic SQL: SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case
WHERE (case_type = ?) ORDER BY id DESC LIMIT ?
2023-07-19 17:34:56,101 [http-nio-8084-exec-2] INFO (SQLLogger.java:73)-
Actual SQL: saas-test ::: SELECT
id,serial,name,case_type,case_sub_type,case_status,status_category,area_code,create_time,foreign_agent,customer_name,application_date,apn,dept_id,assignee,agent,case_type_name,status_name,status_category_name,area_name,dept_name,assignee_name,agent_name
FROM v_info_case
WHERE (case_type = ?) ORDER BY id DESC LIMIT ? ::: [1, 10]
2023-07-19 17:34:56,107 [http-nio-8084-exec-2] DEBUG
(BaseJdbcLogger.java:137)- <== Total: 10
--
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]
