You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "weikangqq (via GitHub)" <gi...@apache.org> on 2023/06/16 09:15:04 UTC
[GitHub] [shardingsphere] weikangqq opened a new issue, #26387: tableName is right when id select count from target table,but not right in GroupByMemoryMergedResult
weikangqq opened a new issue, #26387:
URL: https://github.com/apache/shardingsphere/issues/26387
![20230616-171045](https://github.com/apache/shardingsphere/assets/20835251/b3335b59-8d6f-4d4d-bdd7-6adb0a88026e)
yml:
sharding-algorithms:
date-strategy-inline:
type: class_based
props:
strategy: standard
algorithmClassName: com.xxx.cloud.sharding.config.algorithm.DateShardingAlgorithm
order_complex:
type: CLASS_BASED
props:
strategy: COMPLEX
algorithm-expression: {create_at}
algorithmClassName: com.xxx.cloud.sharding.config.algorithm.OrderNoComplexShardingAlgorithm
allow-range-query-with-inline-sharding: true
ft_order_base_202305 ft_order_base_202306 has been find;
log undergroud:
2023-06-16 17:04:42.278 INFO 1328 --- [io-20880-exec-4] ShardingSphere-SQL : Logic SQL: SELECT COUNT(*) FROM ft_order_base WHERE (create_at >= ? AND create_at <= ?)
2023-06-16 17:04:42.278 INFO 1328 --- [io-20880-exec-4] ShardingSphere-SQL : SQLStatement: MySQLSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=2, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=55, stopIndex=55, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=74, stopIndex=74, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), projections=ProjectionsSegment(startIndex=7, stopIndex=14, projections=[AggregationProjectionSegment(startIndex=7, stopIndex=14, type=COUNT, innerExpression=(*), parameters=[], alias=Optional.empty)], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=21, stopIndex=33, identifier=IdentifierValue(value=ft_order_base, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), where=Optional[WhereSegment(startIndex=35, stopInde
x=75, expr=BinaryOperationExpression(startIndex=42, stopIndex=74, left=BinaryOperationExpression(startIndex=42, stopIndex=55, left=ColumnSegment(startIndex=42, stopIndex=50, identifier=IdentifierValue(value=create_at, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=55, stopIndex=55, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>=, text=create_at >= ?), right=BinaryOperationExpression(startIndex=61, stopIndex=74, left=ColumnSegment(startIndex=61, stopIndex=69, identifier=IdentifierValue(value=create_at, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=74, stopIndex=74, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=create_at <= ?), operator=AND, text=create_at >= ? AND create_at <= ?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combines=[]), table=Optional.empty, limit=Option
al.empty, lock=Optional.empty, window=Optional.empty)
2023-06-16 17:04:42.278 INFO 1328 --- [io-20880-exec-4] ShardingSphere-SQL : Actual SQL: ds0 ::: SELECT COUNT(*) FROM ft_order_base_202305 WHERE (create_at >= ? AND create_at <= ?) UNION ALL SELECT COUNT(*) FROM ft_order_base_202306 WHERE (create_at >= ? AND create_at <= ?) ::: [2023-05-16 17:04:42.273, 2023-06-16 17:04:42.273, 2023-05-16 17:04:42.273, 2023-06-16 17:04:42.273]
--
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] github-actions[bot] commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1644528215
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] weikangqq commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "weikangqq (via GitHub)" <gi...@apache.org>.
weikangqq commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1598115610
5.2.0
--
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] weikangqq commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "weikangqq (via GitHub)" <gi...@apache.org>.
weikangqq commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1598116199
> Hi @weikangqq Which version are you using?
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.2.0</version>
</dependency>
--
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] weikangqq commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "weikangqq (via GitHub)" <gi...@apache.org>.
weikangqq commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1598115746
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>shardingsphere-jdbc-core-spring-boot-starter</artifactId>
<version>5.2.0</version>
</dependency>
--
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] weikangqq commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "weikangqq (via GitHub)" <gi...@apache.org>.
weikangqq commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1594389614
function:
org.apache.shardingsphere.sharding.merge.dql.groupby.getValueCaseSensitiveFromTables
--
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] RaigorJiang commented on issue #26387: tableName is right when i select count from target table,but not right in GroupByMemoryMergedResult
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #26387:
URL: https://github.com/apache/shardingsphere/issues/26387#issuecomment-1594882013
Hi @weikangqq
Which version are you using?
--
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