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/10/10 06:32:42 UTC
[GitHub] [shardingsphere] xiaoxu9401 opened a new issue, #20464: subquery error,when result contains *
xiaoxu9401 opened a new issue, #20464:
URL: https://github.com/apache/shardingsphere/issues/20464
when the query result set contains a.*, and contains join sub query , the resultset is wrong。 final result fields has sub selected field。
such as
select
a.*
from litigation_lawyer a inner join (
select lawyer_id, max(version) as version from litigation_lawyer_blacklist group by lawyer_id
) b on a.lawyer_id = b.lawyer_id and a.version = b.version
result: a.* , lawyer_id
--
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] xiaoxu9401 commented on issue #20464: subquery error,when result contains *
Posted by GitBox <gi...@apache.org>.
xiaoxu9401 commented on issue #20464:
URL: https://github.com/apache/shardingsphere/issues/20464#issuecomment-1225080052
error msg :
### Cause: java.sql.SQLException: Column index out of range.
; Column index out of range.; nested exception is java.sql.SQLException: Column index out of range.
protected Field **getField**(int columnIndex) throws SQLException {
if ((columnIndex < 1) || (columnIndex > this.fields.length)) {
throw SQLError.createSQLException(Messages.getString("ResultSetMetaData.46"), SQLError.SQL_STATE_INVALID_COLUMN_NUMBER, this.exceptionInterceptor);
}
return this.fields[columnIndex - 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] RaigorJiang commented on issue #20464: subquery error,when result contains *
Posted by "RaigorJiang (via GitHub)" <gi...@apache.org>.
RaigorJiang commented on issue #20464:
URL: https://github.com/apache/shardingsphere/issues/20464#issuecomment-1407625766
This issue has been inactive for a long time, and ShardingSphere has released several new versions, can you try the latest version 5.3.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] fourierxue commented on issue #20464: subquery error,when result contains *
Posted by GitBox <gi...@apache.org>.
fourierxue commented on issue #20464:
URL: https://github.com/apache/shardingsphere/issues/20464#issuecomment-1235009618
I had the same 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] github-actions[bot] closed issue #20464: subquery error,when result contains *
Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #20464: subquery error,when result contains *
URL: https://github.com/apache/shardingsphere/issues/20464
--
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 #20464: subquery error,when result contains *
Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #20464:
URL: https://github.com/apache/shardingsphere/issues/20464#issuecomment-1272348729
Hello , this issue has not received a reply for several days.
This issue is supposed to be closed.
--
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