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/07/22 12:34:20 UTC
[GitHub] [shardingsphere] ruanyg opened a new issue, #19478: keywords in proxy which can't be used as column name within a mysql select sql
ruanyg opened a new issue, #19478:
URL: https://github.com/apache/shardingsphere/issues/19478
### Which version of ShardingSphere did you use?
5.0.0
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-Proxy
### Behavior
these keywords shown below can't be used as column name within a mysql select sql
```
GROUPS
RANK
CUBE
NTH_VALUE
SYSTEM
MYSQL_MAIN
ROW_NUMBER
OVER
PERCENT_RANK
BIT_XOR
LAG
UTC_DATE
UTC_TIME
ROW
GROUPING
OF
ROWS
EMPTY
FIRST_VALUE
FUNCTION
DENSE_RANK
CUME_DIST
WINDOW
JSON_TABLE
LEAD
RECURSIVE
NTILE
LATERAL
EXCEPT
UTC_TIMESTAMP
```
### Reason analyze (If you can)
in grammatical level they aren't regarded as _identifier_
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
Just execute a select sql having one or more keywords described before as column name, for example
`select rank from student;`
--
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] tuichenchuxin commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1205992464
I tried mysql 8 and this keyword can be supported with mysql but not supported by shardingsphere.
`MYSQL_MAIN` `UTC_DATE` `UTC_TIME` `UTC_TIMESTAMP`.
Others can't be supported for mysql 8.
--
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] mingyifei commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
mingyifei commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1205026392
Let me add: ORDER
--
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 #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
strongduanmu commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1193545595
@tuichenchuxin Can you help check this issue?
--
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] liujia13142324 commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
liujia13142324 commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1197618635
I also meed the same problem in ShardingSphere-JDBC, because the column name such as rank is defined in the table. If I remove the rank column from the query, ShardingSphere-JDBC can work normally.
(在ShardingSphere-JDBC中我也碰到了同样的问题，因为表中定义了rank这样的列名。如果我在查询中去掉rank列，ShardingSphere-JDBC能正常查询)
@csonezp
--
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] tuichenchuxin commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
tuichenchuxin commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1205953188
I'll check this. 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.
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 closed issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
strongduanmu closed issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
URL: https://github.com/apache/shardingsphere/issues/19478
--
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] csonezp commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
csonezp commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1194967540
These sql contain reserved words, and return error is expected.
Do you mean the error information is wrong?
@ruanyg
--
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] liujia13142324 commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
liujia13142324 commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1197619362
ShardingSphere-JDBC version: 5.1.2
--
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] mingyifei commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
mingyifei commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1194968997
>
If the MySQL client can query, it should be consistent with it.
--
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] ruanyg commented on issue #19478: keywords in proxy which can't be used as column name within a mysql select sql
Posted by GitBox <gi...@apache.org>.
ruanyg commented on issue #19478:
URL: https://github.com/apache/shardingsphere/issues/19478#issuecomment-1195133312
> These sql contain reserved words, and return error is expected. Do you mean the error information is wrong? @ruanyg
They can execute correctly when connect to mysql directly without proxy, the behaviors between mysql and proxy are inconsistent.
--
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