terrymanu commented on issue #22344:
URL:
https://github.com/apache/shardingsphere/issues/22344#issuecomment-3635705631
## Understanding
- Feedback: MySQL SQL parsing castType used to miss UNSIGNED INTEGER /
SIGNED INTEGER, causing CAST(expr AS UNSIGNED/SIGNED …) parse failures.
- Scope: SQL parsing layer (MySQL dialect), not execution.
## Root Cause
- Grammar omission: BaseRule.g4 castType lacked the UNSIGNED INTEGER /
SIGNED INTEGER variants, so CAST parsing errored.
## Analysis
- Current mainline
parser/sql/engine/dialect/mysql/src/main/antlr4/imports/mysql/BaseRule.g4
already includes SIGNED | SIGNED_INT | SIGNED_INTEGER and UNSIGNED |
UNSIGNED_INT | UNSIGNED_INTEGER, so those CAST forms parse.
- Older versions (e.g., early 5.2.x snapshots) will reproduce the gap;
upgrading to the latest release or mainline build avoids it.
## Conclusion
- This was a parsing rule gap that has been fixed; upgrading to the
current version is recommended
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
