You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by "FakeKotaro (via GitHub)" <gi...@apache.org> on 2023/06/29 06:47:50 UTC
[GitHub] [shardingsphere] FakeKotaro opened a new issue, #26687: sql parsing does not support in MySQL
FakeKotaro opened a new issue, #26687:
URL: https://github.com/apache/shardingsphere/issues/26687
### Which version of ShardingSphere did you use?
5.3.2
### Which project did you use? ShardingSphere-JDBC or ShardingSphere-Proxy?
ShardingSphere-JDBC
### Behavior
When I run the following SQL：
```sql
SELECT * FROM user where name RLIKE 'devin'
```
It throws the following exception：
```java
Caused by: org.apache.shardingsphere.sql.parser.exception.SQLParsingException: You have an error in your SQL syntax: SELECT * FROM user where name RLIKE '123', no viable alternative at input 'RLIKE' at line 1, position 30, near [@6,30:34='RLIKE',<593>,1:30]
```
But this SQL is actually executable in MySQL
### Reason analyze (If you can)
The handling of RLIKE is not defined in the antlr4 syntax file
```
predicate
: bitExpr NOT? IN subquery
| bitExpr NOT? IN LP_ expr (COMMA_ expr)* RP_
| bitExpr NOT? BETWEEN bitExpr AND predicate
| bitExpr SOUNDS LIKE bitExpr
| bitExpr NOT? LIKE simpleExpr (ESCAPE simpleExpr)?
| bitExpr NOT? REGEXP bitExpr
| bitExpr
;
```
--
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] FakeKotaro commented on issue #26687: sql parsing does not support in MySQL
Posted by "FakeKotaro (via GitHub)" <gi...@apache.org>.
FakeKotaro commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1614159316
@strongduanmu
--
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] FakeKotaro commented on issue #26687: sql parsing does not support in MySQL
Posted by "FakeKotaro (via GitHub)" <gi...@apache.org>.
FakeKotaro commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1614248367
@zihaoAK47 Sure, I'd like to submit a PR, please assign it to me
--
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 #26687: sql parsing does not support in MySQL
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu closed issue #26687: sql parsing does not support <RLIKE | NOT RLIKE> in MySQL
URL: https://github.com/apache/shardingsphere/issues/26687
--
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 #26687: sql parsing does not support in MySQL
Posted by "strongduanmu (via GitHub)" <gi...@apache.org>.
strongduanmu commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1617225331
Fixed by https://github.com/apache/shardingsphere/pull/26731.
--
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] zihaoAK47 commented on issue #26687: sql parsing does not support in MySQL
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1614245633
@FakeKotaro Hi, the above statement is indeed executable. The issue with RLIKE parsing also appears in this #25535 and is currently being followed up. It would be great if you could submit a PR to fix this issue. Thank you very much
--
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] zihaoAK47 commented on issue #26687: sql parsing does not support in MySQL
Posted by "zihaoAK47 (via GitHub)" <gi...@apache.org>.
zihaoAK47 commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1615269293
> @zihaoAK47 Sure, I'd like to submit a PR, please assign it to me
You can choose a mentor to assign the task to
--
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] FakeKotaro commented on issue #26687: sql parsing does not support in MySQL
Posted by "FakeKotaro (via GitHub)" <gi...@apache.org>.
FakeKotaro commented on issue #26687:
URL: https://github.com/apache/shardingsphere/issues/26687#issuecomment-1612512597
I'd like to know if this defect is already being followed up on, and if not, I would like to make a PR
--
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