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 2022/12/03 03:37:33 UTC
[GitHub] [shardingsphere] wj-li opened a new issue, #22614: Can not get index from column label
wj-li opened a new issue, #22614:
URL: https://github.com/apache/shardingsphere/issues/22614
I'm also having the same issue.
When SQL incoming parameters use aliases.
_Originally posted by @wj-li in https://github.com/apache/shardingsphere/issues/21823#issuecomment-1336027808_
--
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] wj-li commented on issue #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
wj-li commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1345711907
> @wj-li , I had a look at the code of `ShardingSphereResultSet`. exception is from:
>
> ```
> private Integer getIndexFromColumnLabelAndIndexMap(final String columnLabel) throws SQLException {
> Integer result = columnLabelAndIndexMap.get(columnLabel);
> ShardingSpherePreconditions.checkState(null != result, () -> new SQLFeatureNotSupportedException(String.format("Can not get index from column label `%s`.", columnLabel)));
> return result;
> }
> ```
>
> `columnLabelAndIndexMap.get(columnLabel)` return `null`. I don't have Oracle 11g environment. Could you debug to check the values of `columnLabelAndIndexMap` and `columnLabel`?
>
> It might be column label case-sensitive related.
![微信截图_20221212082302](https://user-images.githubusercontent.com/20807065/206938562-ef6bada2-9f93-43a1-8a59-dab122b9cc07.png)
--
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] fang1025 commented on issue #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
fang1025 commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1384784602
version 5.3.0 has solved this problem.
--
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 #22614: Can not get index from column label
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1407267200
@fang1025
Thanks for the info, I will close this issue.
@wj-li
If you still have similar problems, please submit a new issue, or reopen this one.
--
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 closed issue #22614: Can not get index from column label
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang closed issue #22614: Can not get index from column label
URL: https://github.com/apache/shardingsphere/issues/22614
--
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] wj-li commented on issue #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
wj-li commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1343812835
>
Use ShardingSphere-JDBC 5.2.1 release version
Here's the information.
```
2022-12-09 11:36:16,289 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Logic SQL: SELECT COUNT(*) FROM (SELECT TO_CHAR(STATIS_TIME, 'yyyy-mm-dd') AS statisTimeStr, BANK_ID AS bankId, sum(TOTAL_AMOUNT) AS totalAmount, sum(TOTAL_COUNT) AS totalCount FROM T_FSN_DATA_STATIS WHERE BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ? GROUP BY TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), BANK_ID ORDER BY BANK_ID) TOTAL
2022-12-09 11:36:16,289 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- SQLStatement: OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=3, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=207, stopIndex=207, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=229, stopIndex=229, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=250, stopIndex=250, parameterMarkerIndex=2, 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=SubqueryTableSegment(subquery=SubquerySegment(startIndex=22, stopIndex=3
20, select=OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=29, stopIndex=164, projections=[ExpressionProjectionSegment(startIndex=29, stopIndex=79, text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=29, stopIndex=62, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=37, stopIndex=47, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=50, stopIndex=61, literals=yyyy-mm-dd)], text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), owner=null), alias=Optional[statisTimeStr]), ColumnProjectionSegment(column=ColumnSegment(startIndex=82, stopIndex=88, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[bankId]), AggregationProjectionSegment(startIndex=101, stopIndex=117, type=SUM, innerExpression=(TOTAL_AMOUNT), paramet
ers=[ColumnSegment(startIndex=105, stopIndex=116, identifier=IdentifierValue(value=TOTAL_AMOUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalAmount]), AggregationProjectionSegment(startIndex=135, stopIndex=150, type=SUM, innerExpression=(TOTAL_COUNT), parameters=[ColumnSegment(startIndex=139, stopIndex=149, identifier=IdentifierValue(value=TOTAL_COUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalCount])], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=171, stopIndex=187, identifier=IdentifierValue(value=T_FSN_DATA_STATIS, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), where=Optional[WhereSegment(startIndex=189, stopIndex=250, expr=BinaryOperationExpression(startIndex=195, stopIndex=250, left=BinaryOperationExpression(startIndex=195, stopIndex=229, left=InExpression(startIndex=195, stopIndex=208, left=ColumnSegment(startIndex=195, stopIndex=201, identifier=IdentifierValue(value=BANK_ID
, quoteCharacter=NONE), owner=Optional.empty), right=ListExpression(startIndex=206, stopIndex=208, items=[ParameterMarkerExpressionSegment(startIndex=207, stopIndex=207, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty)]), not=false), right=BinaryOperationExpression(startIndex=214, stopIndex=229, left=ColumnSegment(startIndex=214, stopIndex=224, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=229, stopIndex=229, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>=, text=STATIS_TIME >= ?), operator=AND, text=BANK_ID IN (?) AND STATIS_TIME >= ?), right=BinaryOperationExpression(startIndex=235, stopIndex=250, left=ColumnSegment(startIndex=235, stopIndex=245, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=250, stopIndex=250, parameterMarkerIn
dex=2, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=STATIS_TIME <= ?), operator=AND, text=BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ?))], groupBy=Optional[GroupBySegment(startIndex=252, stopIndex=303, groupByItems=[ExpressionOrderByItemSegment(super=TextOrderByItemSegment(), expression=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=261, stopIndex=294, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=269, stopIndex=279, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=282, stopIndex=293, literals=yyyy-mm-dd)], text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), owner=null)), ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=297, stopIndex=303, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], having=Optional.empty, orderBy=Optional[OrderBySegment(startIndex=305, stopInde
x=320, orderByItems=[ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=314, stopIndex=320, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional[TOTAL]), where=Optional.empty, groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty)
2022-12-09 11:36:16,289 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds_0 ::: SELECT COUNT(*) FROM (SELECT TO_CHAR(STATIS_TIME, 'yyyy-mm-dd') AS statisTimeStr, BANK_ID AS bankId, sum(TOTAL_AMOUNT) AS totalAmount, sum(TOTAL_COUNT) AS totalCount FROM T_FSN_DATA_STATIS_202208 WHERE BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ? GROUP BY TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), BANK_ID ORDER BY BANK_ID) TOTAL ::: [1584841557205467137, 2022-08-01 00:00:00.0, 2022-08-01 23:59:59.999]
2022-12-09 11:36:16,343 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Logic SQL: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd') as statisTimeStr,
BANK_ID as bankId,
sum(TOTAL_AMOUNT) as totalAmount,
sum(TOTAL_COUNT) as totalCount
FROM T_FSN_DATA_STATIS
WHERE BANK_ID in
(
?
)
and STATIS_TIME >= ?
and STATIS_TIME <= ?
GROUP BY
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'),
BANK_ID ORDER BY BANK_ID ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ?
2022-12-09 11:36:16,343 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- SQLStatement: OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=5, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=565, stopIndex=565, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=695, stopIndex=695, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=729, stopIndex=729, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=1077, stopIndex=1077, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=1095, stopIndex=1095, parameterMarkerIndex=4, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), projections=
ProjectionsSegment(startIndex=7, stopIndex=7, projections=[ShorthandProjectionSegment(startIndex=7, stopIndex=7, owner=Optional.empty, alias=Optional.empty)], distinctRow=false), from=SubqueryTableSegment(subquery=SubquerySegment(startIndex=16, stopIndex=1077, select=OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=23, stopIndex=42, projections=[ShorthandProjectionSegment(startIndex=23, stopIndex=27, owner=Optional[OwnerSegment(startIndex=23, stopIndex=25, identifier=IdentifierValue(value=TMP, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional.empty), ColumnProjectionSegment(column=ColumnSegment(startIndex=30, stopIndex=35, identifier=IdentifierValue(value=ROWNUM, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[ROW_ID])], distinctRow=false), from=SubqueryTableSegment(subquery=SubquerySegment(startIndex=51, stopIndex=1054, select=Ora
cleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=182, stopIndex=463, projections=[ExpressionProjectionSegment(startIndex=182, stopIndex=233, text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=182, stopIndex=216, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=191, stopIndex=201, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=204, stopIndex=215, literals=yyyy-mm-dd)], text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), owner=null), alias=Optional[statisTimeStr]), ColumnProjectionSegment(column=ColumnSegment(startIndex=357, stopIndex=363, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[bankId]), AggregationProjectionSegment(startIndex=388, stopIndex=404, type=SUM, innerExpression=(TOTAL_AMOUNT), paramete
rs=[ColumnSegment(startIndex=392, stopIndex=403, identifier=IdentifierValue(value=TOTAL_AMOUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalAmount]), AggregationProjectionSegment(startIndex=434, stopIndex=449, type=SUM, innerExpression=(TOTAL_COUNT), parameters=[ColumnSegment(startIndex=438, stopIndex=448, identifier=IdentifierValue(value=TOTAL_COUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalCount])], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=482, stopIndex=498, identifier=IdentifierValue(value=T_FSN_DATA_STATIS, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), where=Optional[WhereSegment(startIndex=509, stopIndex=729, expr=BinaryOperationExpression(startIndex=516, stopIndex=729, left=BinaryOperationExpression(startIndex=516, stopIndex=695, left=InExpression(startIndex=516, stopIndex=583, left=ColumnSegment(startIndex=516, stopIndex=522, identifier=IdentifierValue(value=BANK_ID,
quoteCharacter=NONE), owner=Optional.empty), right=ListExpression(startIndex=543, stopIndex=583, items=[ParameterMarkerExpressionSegment(startIndex=565, stopIndex=565, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty)]), not=false), right=BinaryOperationExpression(startIndex=680, stopIndex=695, left=ColumnSegment(startIndex=680, stopIndex=690, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=695, stopIndex=695, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>=, text=STATIS_TIME >= ?), operator=and, text=BANK_ID in
(
?
)
and STATIS_TIME >= ?), right=BinaryOperationExpression(startIndex=714, stopIndex=729, left=ColumnSegment(startIndex=714, stopIndex=724, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=729, stopIndex=729, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=STATIS_TIME <= ?), operator=and, text=BANK_ID in
(
?
)
and STATIS_TIME >= ?
and STATIS_TIME <= ?))], groupBy=Optional[GroupBySegment(startIndex=740, stopIndex=1037, groupByItems=[ExpressionOrderByItemSegment(super=TextOrderByItemSegment(), expression=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=873, stopIndex=907, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=882, stopIndex=892, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=895, stopIndex=906, literals=yyyy-mm-dd)], text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), owner=null)), ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=1031, stopIndex=1037, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], having=Optional.empty, orderBy=Optional[OrderBySegment(startIndex=1039, stopIndex=1054, orderByItems=[ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=1048, stopIndex=1054,
identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional[TMP]), where=Optional[WhereSegment(startIndex=1062, stopIndex=1077, expr=BinaryOperationExpression(startIndex=1068, stopIndex=1077, left=ColumnSegment(startIndex=1068, stopIndex=1073, identifier=IdentifierValue(value=ROWNUM, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=1077, stopIndex=1077, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=ROWNUM <=?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional.empty), where=Optional[WhereSegment(startIndex=1080, stopIndex=1095, expr=BinaryOper
ationExpression(startIndex=1086, stopIndex=1095, left=ColumnSegment(startIndex=1086, stopIndex=1091, identifier=IdentifierValue(value=ROW_ID, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=1095, stopIndex=1095, parameterMarkerIndex=4, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>, text=ROW_ID > ?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty)
2022-12-09 11:36:16,344 INFO DubboServerHandler-172.21.101.1:20880-thread-5 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds_0 ::: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd') as statisTimeStr,
BANK_ID as bankId,
sum(TOTAL_AMOUNT) as totalAmount,
sum(TOTAL_COUNT) as totalCount
FROM T_FSN_DATA_STATIS_202208
WHERE BANK_ID in
(
?
)
and STATIS_TIME >= ?
and STATIS_TIME <= ?
GROUP BY
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'),
BANK_ID ORDER BY BANK_ID ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ? ::: [1584841557205467137, 2022-08-01 00:00:00.0, 2022-08-01 23:59:59.999, 10, 0]
2022-12-09 11:45:36,544 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Logic SQL: SELECT COUNT(*) FROM (SELECT TO_CHAR(STATIS_TIME, 'yyyy-mm-dd') AS statisTimeStr, BANK_ID AS bankId, sum(TOTAL_AMOUNT) AS totalAmount, sum(TOTAL_COUNT) AS totalCount FROM T_FSN_DATA_STATIS WHERE BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ? GROUP BY TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), BANK_ID ORDER BY BANK_ID) TOTAL
2022-12-09 11:45:36,544 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- SQLStatement: OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=3, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=207, stopIndex=207, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=229, stopIndex=229, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=250, stopIndex=250, parameterMarkerIndex=2, 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=SubqueryTableSegment(subquery=SubquerySegment(startIndex=22, stopIndex=3
20, select=OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=29, stopIndex=164, projections=[ExpressionProjectionSegment(startIndex=29, stopIndex=79, text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=29, stopIndex=62, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=37, stopIndex=47, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=50, stopIndex=61, literals=yyyy-mm-dd)], text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), owner=null), alias=Optional[statisTimeStr]), ColumnProjectionSegment(column=ColumnSegment(startIndex=82, stopIndex=88, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[bankId]), AggregationProjectionSegment(startIndex=101, stopIndex=117, type=SUM, innerExpression=(TOTAL_AMOUNT), paramet
ers=[ColumnSegment(startIndex=105, stopIndex=116, identifier=IdentifierValue(value=TOTAL_AMOUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalAmount]), AggregationProjectionSegment(startIndex=135, stopIndex=150, type=SUM, innerExpression=(TOTAL_COUNT), parameters=[ColumnSegment(startIndex=139, stopIndex=149, identifier=IdentifierValue(value=TOTAL_COUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalCount])], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=171, stopIndex=187, identifier=IdentifierValue(value=T_FSN_DATA_STATIS, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), where=Optional[WhereSegment(startIndex=189, stopIndex=250, expr=BinaryOperationExpression(startIndex=195, stopIndex=250, left=BinaryOperationExpression(startIndex=195, stopIndex=229, left=InExpression(startIndex=195, stopIndex=208, left=ColumnSegment(startIndex=195, stopIndex=201, identifier=IdentifierValue(value=BANK_ID
, quoteCharacter=NONE), owner=Optional.empty), right=ListExpression(startIndex=206, stopIndex=208, items=[ParameterMarkerExpressionSegment(startIndex=207, stopIndex=207, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty)]), not=false), right=BinaryOperationExpression(startIndex=214, stopIndex=229, left=ColumnSegment(startIndex=214, stopIndex=224, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=229, stopIndex=229, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>=, text=STATIS_TIME >= ?), operator=AND, text=BANK_ID IN (?) AND STATIS_TIME >= ?), right=BinaryOperationExpression(startIndex=235, stopIndex=250, left=ColumnSegment(startIndex=235, stopIndex=245, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=250, stopIndex=250, parameterMarkerIn
dex=2, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=STATIS_TIME <= ?), operator=AND, text=BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ?))], groupBy=Optional[GroupBySegment(startIndex=252, stopIndex=303, groupByItems=[ExpressionOrderByItemSegment(super=TextOrderByItemSegment(), expression=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=261, stopIndex=294, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=269, stopIndex=279, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=282, stopIndex=293, literals=yyyy-mm-dd)], text=TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), owner=null)), ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=297, stopIndex=303, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], having=Optional.empty, orderBy=Optional[OrderBySegment(startIndex=305, stopInde
x=320, orderByItems=[ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=314, stopIndex=320, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional[TOTAL]), where=Optional.empty, groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty)
2022-12-09 11:45:36,544 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds_0 ::: SELECT COUNT(*) FROM (SELECT TO_CHAR(STATIS_TIME, 'yyyy-mm-dd') AS statisTimeStr, BANK_ID AS bankId, sum(TOTAL_AMOUNT) AS totalAmount, sum(TOTAL_COUNT) AS totalCount FROM T_FSN_DATA_STATIS_202208 WHERE BANK_ID IN (?) AND STATIS_TIME >= ? AND STATIS_TIME <= ? GROUP BY TO_CHAR(STATIS_TIME, 'yyyy-mm-dd'), BANK_ID ORDER BY BANK_ID) TOTAL ::: [1584841557205467137, 2022-08-01 00:00:00.0, 2022-08-01 23:59:59.999]
2022-12-09 11:45:36,598 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Logic SQL: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd') as statisTimeStr,
BANK_ID as bankId,
sum(TOTAL_AMOUNT) as totalAmount,
sum(TOTAL_COUNT) as totalCount
FROM T_FSN_DATA_STATIS
WHERE BANK_ID in
(
?
)
and STATIS_TIME >= ?
and STATIS_TIME <= ?
GROUP BY TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), BANK_ID ORDER BY BANK_ID ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ?
2022-12-09 11:45:36,598 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- SQLStatement: OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=5, parameterMarkerSegments=[ParameterMarkerExpressionSegment(startIndex=565, stopIndex=565, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=695, stopIndex=695, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=729, stopIndex=729, parameterMarkerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=1077, stopIndex=1077, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty), ParameterMarkerExpressionSegment(startIndex=1095, stopIndex=1095, parameterMarkerIndex=4, parameterMarkerType=QUESTION, alias=Optional.empty)], commentSegments=[]), projections=
ProjectionsSegment(startIndex=7, stopIndex=7, projections=[ShorthandProjectionSegment(startIndex=7, stopIndex=7, owner=Optional.empty, alias=Optional.empty)], distinctRow=false), from=SubqueryTableSegment(subquery=SubquerySegment(startIndex=16, stopIndex=1077, select=OracleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=23, stopIndex=42, projections=[ShorthandProjectionSegment(startIndex=23, stopIndex=27, owner=Optional[OwnerSegment(startIndex=23, stopIndex=25, identifier=IdentifierValue(value=TMP, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional.empty), ColumnProjectionSegment(column=ColumnSegment(startIndex=30, stopIndex=35, identifier=IdentifierValue(value=ROWNUM, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[ROW_ID])], distinctRow=false), from=SubqueryTableSegment(subquery=SubquerySegment(startIndex=51, stopIndex=1054, select=Ora
cleSelectStatement(super=SelectStatement(super=AbstractSQLStatement(parameterCount=0, parameterMarkerSegments=[], commentSegments=[]), projections=ProjectionsSegment(startIndex=182, stopIndex=463, projections=[ExpressionProjectionSegment(startIndex=182, stopIndex=233, text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=182, stopIndex=216, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=191, stopIndex=201, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=204, stopIndex=215, literals=yyyy-mm-dd)], text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), owner=null), alias=Optional[statisTimeStr]), ColumnProjectionSegment(column=ColumnSegment(startIndex=357, stopIndex=363, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty), alias=Optional[bankId]), AggregationProjectionSegment(startIndex=388, stopIndex=404, type=SUM, innerExpression=(TOTAL_AMOUNT), paramete
rs=[ColumnSegment(startIndex=392, stopIndex=403, identifier=IdentifierValue(value=TOTAL_AMOUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalAmount]), AggregationProjectionSegment(startIndex=434, stopIndex=449, type=SUM, innerExpression=(TOTAL_COUNT), parameters=[ColumnSegment(startIndex=438, stopIndex=448, identifier=IdentifierValue(value=TOTAL_COUNT, quoteCharacter=NONE), owner=Optional.empty)], alias=Optional[totalCount])], distinctRow=false), from=SimpleTableSegment(tableName=TableNameSegment(startIndex=482, stopIndex=498, identifier=IdentifierValue(value=T_FSN_DATA_STATIS, quoteCharacter=NONE)), owner=Optional.empty, alias=Optional.empty), where=Optional[WhereSegment(startIndex=509, stopIndex=729, expr=BinaryOperationExpression(startIndex=516, stopIndex=729, left=BinaryOperationExpression(startIndex=516, stopIndex=695, left=InExpression(startIndex=516, stopIndex=583, left=ColumnSegment(startIndex=516, stopIndex=522, identifier=IdentifierValue(value=BANK_ID,
quoteCharacter=NONE), owner=Optional.empty), right=ListExpression(startIndex=543, stopIndex=583, items=[ParameterMarkerExpressionSegment(startIndex=565, stopIndex=565, parameterMarkerIndex=0, parameterMarkerType=QUESTION, alias=Optional.empty)]), not=false), right=BinaryOperationExpression(startIndex=680, stopIndex=695, left=ColumnSegment(startIndex=680, stopIndex=690, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=695, stopIndex=695, parameterMarkerIndex=1, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>=, text=STATIS_TIME >= ?), operator=and, text=BANK_ID in ( ? ) and STATIS_TIME >= ?), right=BinaryOperationExpression(startIndex=714, stopIndex=729, left=ColumnSegment(startIndex=714, stopIndex=724, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=729, stopIndex=729, parameterMar
kerIndex=2, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=STATIS_TIME <= ?), operator=and, text=BANK_ID in ( ? ) and STATIS_TIME >= ? and STATIS_TIME <= ?))], groupBy=Optional[GroupBySegment(startIndex=740, stopIndex=1037, groupByItems=[ExpressionOrderByItemSegment(super=TextOrderByItemSegment(), expression=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), expr=FunctionSegment(startIndex=873, stopIndex=907, functionName=TO_CHAR, parameters=[ColumnSegment(startIndex=882, stopIndex=892, identifier=IdentifierValue(value=STATIS_TIME, quoteCharacter=NONE), owner=Optional.empty), LiteralExpressionSegment(startIndex=895, stopIndex=906, literals=yyyy-mm-dd)], text=TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'), owner=null)), ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=1031, stopIndex=1037, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], having=Optional.empty, orderBy=Optional[OrderBySegment(startI
ndex=1039, stopIndex=1054, orderByItems=[ColumnOrderByItemSegment(super=TextOrderByItemSegment(), column=ColumnSegment(startIndex=1048, stopIndex=1054, identifier=IdentifierValue(value=BANK_ID, quoteCharacter=NONE), owner=Optional.empty))])], combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional[TMP]), where=Optional[WhereSegment(startIndex=1062, stopIndex=1077, expr=BinaryOperationExpression(startIndex=1068, stopIndex=1077, left=ColumnSegment(startIndex=1068, stopIndex=1073, identifier=IdentifierValue(value=ROWNUM, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=1077, stopIndex=1077, parameterMarkerIndex=3, parameterMarkerType=QUESTION, alias=Optional.empty), operator=<=, text=ROWNUM <=?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSeg
ment=Optional.empty), subqueryType=TABLE_SUBQUERY), alias=Optional.empty), where=Optional[WhereSegment(startIndex=1080, stopIndex=1095, expr=BinaryOperationExpression(startIndex=1086, stopIndex=1095, left=ColumnSegment(startIndex=1086, stopIndex=1091, identifier=IdentifierValue(value=ROW_ID, quoteCharacter=NONE), owner=Optional.empty), right=ParameterMarkerExpressionSegment(startIndex=1095, stopIndex=1095, parameterMarkerIndex=4, parameterMarkerType=QUESTION, alias=Optional.empty), operator=>, text=ROW_ID > ?))], groupBy=Optional.empty, having=Optional.empty, orderBy=Optional.empty, combine=Optional.empty), lock=Optional.empty, modelSegment=Optional.empty, withSegment=Optional.empty)
2022-12-09 11:45:36,599 INFO DubboServerHandler-172.21.101.1:20880-thread-6 o.a.s.i.executor.sql.log.SQLLogger 74 log ---- Actual SQL: ds_0 ::: SELECT * FROM ( SELECT TMP.*, ROWNUM ROW_ID FROM ( SELECT
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd') as statisTimeStr,
BANK_ID as bankId,
sum(TOTAL_AMOUNT) as totalAmount,
sum(TOTAL_COUNT) as totalCount
FROM T_FSN_DATA_STATIS_202208
WHERE BANK_ID in
(
?
)
and STATIS_TIME >= ?
and STATIS_TIME <= ?
GROUP BY
TO_CHAR (STATIS_TIME, 'yyyy-mm-dd'),
BANK_ID ORDER BY BANK_ID ) TMP WHERE ROWNUM <=?) WHERE ROW_ID > ? ::: [1584841557205467137, 2022-08-01 00:00:00.0, 2022-08-01 23:59:59.999, 10, 0]
java.lang.RuntimeException: org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'STATISTIMESTR' from result set. Cause: java.sql.SQLFeatureNotSupportedException: Can not get index from column label `STATISTIMESTR`.
; Can not get index from column label `STATISTIMESTR`.; nested exception is java.sql.SQLFeatureNotSupportedException: Can not get index from column label `STATISTIMESTR`.
org.springframework.dao.InvalidDataAccessApiUsageException: Error attempting to get column 'STATISTIMESTR' from result set. Cause: java.sql.SQLFeatureNotSupportedException: Can not get index from column label `STATISTIMESTR`.
; Can not get index from column label `STATISTIMESTR`.; nested exception is java.sql.SQLFeatureNotSupportedException: Can not get index from column label `STATISTIMESTR`.
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.doTranslate(SQLExceptionSubclassTranslator.java:96)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:79)
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:91)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
at com.sun.proxy.$Proxy100.selectList(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:224)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:121)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:85)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
at com.sun.proxy.$Proxy111.selectByPage(Unknown Source)
at com.dp.xxx.provider.service.impl.FsnDataStatisServiceImpl.selectByPage(FsnDataStatisServiceImpl.java:48)
at com.dp.xxx.provider.service.impl.FsnDataStatisServiceImpl$$FastClassBySpringCGLIB$$aab0172.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy.invokeMethod(CglibAopProxy.java:386)
at org.springframework.aop.framework.CglibAopProxy.access$000(CglibAopProxy.java:85)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:704)
at com.dp.xxx.provider.service.impl.FsnDataStatisServiceImpl$$EnhancerBySpringCGLIB$$6d244510.selectByPage(<generated>)
at com.dp.xxx.provider.remote.FsnDataStatisServiceRemoteImpl.selectByPage(FsnDataStatisServiceRemoteImpl.java:75)
at com.dp.xxx.provider.remote.FsnDataStatisServiceRemoteImplDubboWrap0.invokeMethod(FsnDataStatisServiceRemoteImplDubboWrap0.java)
at org.apache.dubbo.rpc.proxy.javassist.JavassistProxyFactory$1.doInvoke(JavassistProxyFactory.java:71)
at org.apache.dubbo.rpc.proxy.AbstractProxyInvoker.invoke(AbstractProxyInvoker.java:99)
at org.apache.dubbo.config.invoker.DelegateProviderMetaDataInvoker.invoke(DelegateProviderMetaDataInvoker.java:55)
at org.apache.dubbo.rpc.protocol.InvokerWrapper.invoke(InvokerWrapper.java:56)
at org.apache.dubbo.rpc.filter.ClassLoaderCallbackFilter.invoke(ClassLoaderCallbackFilter.java:38)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.protocol.dubbo.filter.TraceFilter.invoke(TraceFilter.java:77)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.TimeoutFilter.invoke(TimeoutFilter.java:46)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at com.alibaba.csp.sentinel.adapter.dubbo3.SentinelDubboProviderFilter.invoke(SentinelDubboProviderFilter.java:81)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.monitor.support.MonitorFilter.invoke(MonitorFilter.java:99)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.ExceptionFilter.invoke(ExceptionFilter.java:52)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.auth.filter.ProviderAuthFilter.invoke(ProviderAuthFilter.java:53)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.GenericFilter.invoke(GenericFilter.java:191)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.ClassLoaderFilter.invoke(ClassLoaderFilter.java:54)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.EchoFilter.invoke(EchoFilter.java:41)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.ProfilerServerFilter.invoke(ProfilerServerFilter.java:56)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.filter.ContextFilter.invoke(ContextFilter.java:131)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CopyOfFilterChainNode.invoke(FilterChainBuilder.java:326)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CallbackRegistrationInvoker.invoke(FilterChainBuilder.java:193)
at org.apache.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:151)
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:100)
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:175)
at org.apache.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:51)
at org.apache.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:57)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.dubbo.common.threadlocal.InternalRunnable.run(InternalRunnable.java:41)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLFeatureNotSupportedException: Can not get index from column label `STATISTIMESTR`.
at org.apache.shardingsphere.driver.jdbc.core.resultset.ShardingSphereResultSet.lambda$getIndexFromColumnLabelAndIndexMap$0(ShardingSphereResultSet.java:393)
at org.apache.shardingsphere.infra.util.exception.ShardingSpherePreconditions.checkState(ShardingSpherePreconditions.java:41)
at org.apache.shardingsphere.driver.jdbc.core.resultset.ShardingSphereResultSet.getIndexFromColumnLabelAndIndexMap(ShardingSphereResultSet.java:393)
at org.apache.shardingsphere.driver.jdbc.core.resultset.ShardingSphereResultSet.getString(ShardingSphereResultSet.java:165)
at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:37)
at org.apache.ibatis.type.StringTypeHandler.getNullableResult(StringTypeHandler.java:26)
at org.apache.ibatis.type.BaseTypeHandler.getResult(BaseTypeHandler.java:85)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.applyAutomaticMappings(DefaultResultSetHandler.java:572)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.getRowValue(DefaultResultSetHandler.java:409)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValuesForSimpleResultMap(DefaultResultSetHandler.java:361)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleRowValues(DefaultResultSetHandler.java:335)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSet(DefaultResultSetHandler.java:308)
at org.apache.ibatis.executor.resultset.DefaultResultSetHandler.handleResultSets(DefaultResultSetHandler.java:201)
at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:65)
at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:64)
at com.sun.proxy.$Proxy121.query(Unknown Source)
at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63)
at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325)
at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109)
at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:81)
at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:62)
at com.sun.proxy.$Proxy120.query(Unknown Source)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
... 54 more
at org.apache.dubbo.rpc.filter.ExceptionFilter.onResponse(ExceptionFilter.java:98)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CallbackRegistrationInvoker.lambda$invoke$1(FilterChainBuilder.java:217)
at org.apache.dubbo.rpc.AsyncRpcResult.lambda$whenCompleteWithContext$0(AsyncRpcResult.java:215)
at java.util.concurrent.CompletableFuture.uniWhenComplete(CompletableFuture.java:760)
at java.util.concurrent.CompletableFuture.uniWhenCompleteStage(CompletableFuture.java:778)
at java.util.concurrent.CompletableFuture.whenComplete(CompletableFuture.java:2140)
at org.apache.dubbo.rpc.AsyncRpcResult.whenCompleteWithContext(AsyncRpcResult.java:211)
at org.apache.dubbo.rpc.cluster.filter.FilterChainBuilder$CallbackRegistrationInvoker.invoke(FilterChainBuilder.java:194)
at org.apache.dubbo.rpc.protocol.dubbo.DubboProtocol$1.reply(DubboProtocol.java:151)
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.handleRequest(HeaderExchangeHandler.java:100)
at org.apache.dubbo.remoting.exchange.support.header.HeaderExchangeHandler.received(HeaderExchangeHandler.java:175)
at org.apache.dubbo.remoting.transport.DecodeHandler.received(DecodeHandler.java:51)
at org.apache.dubbo.remoting.transport.dispatcher.ChannelEventRunnable.run(ChannelEventRunnable.java:57)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.dubbo.common.threadlocal.InternalRunnable.run(InternalRunnable.java:41)
at java.lang.Thread.run(Thread.java:748)
```
--
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] sandynz commented on issue #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1345236075
@wj-li , I had a look at the code of `ShardingSphereResultSet`.
exception is from:
```
private Integer getIndexFromColumnLabelAndIndexMap(final String columnLabel) throws SQLException {
Integer result = columnLabelAndIndexMap.get(columnLabel);
ShardingSpherePreconditions.checkState(null != result, () -> new SQLFeatureNotSupportedException(String.format("Can not get index from column label `%s`.", columnLabel)));
return result;
}
```
`columnLabelAndIndexMap.get(columnLabel)` return `null`.
I don't have Oracle 11g environment.
Could you debug to check the values of `columnLabelAndIndexMap` and `columnLabel`?
It might be column label case-sensitive related.
--
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] sandynz commented on issue #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
sandynz commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1345774579
@wj-li , nice.
From the sql, `TO_CHAR (STATIS_TIME, 'yyyy-mm-dd') as statisTimeStr`, it's not real column.
@strongduanmu , could you help to verify whether it's supported for version 5.2.1?
--
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 #22614: Can not get index from column label
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #22614:
URL: https://github.com/apache/shardingsphere/issues/22614#issuecomment-1336279669
Hi @wj-li, can you try the latest version?
--
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