[GitHub] [shardingsphere] RaigorJiang commented on issue #24398: Support parsing more functions SQL

[via GitHub]

RaigorJiang commented on issue #24398:
URL: 
https://github.com/apache/shardingsphere/issues/24398#issuecomment-1465214280

   Hi @kanha-gupta , thanks for your investigation, for your reference:
   
   - MySQLKeyword.g4
   <img width="933" alt="image" 
src="https://user-images.githubusercontent.com/5668787/224551080-afa85cc9-0b0e-45fa-9e5c-198d4712c450.png";>
   
   - BaseRule.g4
   <img width="1484" alt="image" 
src="https://user-images.githubusercontent.com/5668787/224551177-aea512c6-3c97-4d2b-8514-fa56526ea241.png";>
   
   ```
   castFunction
       : CAST LP_ expr AS dataType RP_
       | CAST LP_ expr AT TIME ZONE expr AS DATETIME typeDatetimePrecision? RP_
       ;
   ```
   
   
   - Result
   <img width="1262" alt="image" 
src="https://user-images.githubusercontent.com/5668787/224551215-147502bb-3125-4e2b-ab5d-11d12d2125e6.png";>
   


-- 
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-unsubscr...@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org