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 2021/03/30 02:19:19 UTC

[GitHub] [shardingsphere] xhkyyy opened a new issue #9871: shardingsphere 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

xhkyyy opened a new issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871


   ## Bug Report
   
   ### Which version of ShardingSphere did you use?
   
   4.x
   
   ### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
   
   ShardingSphere-Proxy
   
   ### Expected behavior
   
   support SQL syntax: `SELECT * FROM table WHERE expr IN (VALUE, ...)`
   
   ### Actual behavior
   
   ```java
   java.sql.SQLException: 2Unknown exception: [org.apache.shardingsphere.sql.parser.sql.segment.dml.item.ExpressionProjectionSegment cannot be cast to org.apache.shardingsphere.sql.parser.sql.segment.dml.column.ColumnSegment]
   	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4074)
   	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4006)
   	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2468)
   	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2629)
   	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2713)
   	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2663)
   	at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1599)
   ```
   
   
   


-- 
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



[GitHub] [shardingsphere] xhkyyy closed issue #9871: shardingsphere-proxy 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

Posted by GitBox <gi...@apache.org>.
xhkyyy closed issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871


   


-- 
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



[GitHub] [shardingsphere] dongzl commented on issue #9871: shardingsphere-proxy 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871#issuecomment-810215878


   > > Hi @xhkyyy , can you test the newest version, or test it with the `master` code? Thanks.
   > 
   > Ok, I'll test the master branch later.
   > However, I'm using the latest version of 4.x, and still hoping you'll fix this on the 4.x branch.
   
   Hi @xhkyyy , the `4.x` version is out of services, we will no plan to upgrade the `4.x` version again.


-- 
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



[GitHub] [shardingsphere] dongzl commented on issue #9871: shardingsphere-proxy 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

Posted by GitBox <gi...@apache.org>.
dongzl commented on issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871#issuecomment-809879915


   Hi @xhkyyy , can you test the newest version, or test it with the `master` code, Thanks.


-- 
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



[GitHub] [shardingsphere] dongzl edited a comment on issue #9871: shardingsphere-proxy 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

Posted by GitBox <gi...@apache.org>.
dongzl edited a comment on issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871#issuecomment-809879915


   Hi @xhkyyy , can you test the newest version, or test it with the `master` code? Thanks.


-- 
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



[GitHub] [shardingsphere] xhkyyy commented on issue #9871: shardingsphere-proxy 4.x doesn't support sql: SELECT * FROM table WHERE expr IN (VALUE, ...)

Posted by GitBox <gi...@apache.org>.
xhkyyy commented on issue #9871:
URL: https://github.com/apache/shardingsphere/issues/9871#issuecomment-809898497


   > Hi @xhkyyy , can you test the newest version, or test it with the `master` code? Thanks.
   
   Ok, I'll test the master branch later. 
   However, I'm using the latest version of 4.x, and still hoping you'll fix this on the 4.x branch.


-- 
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