Open FlyingZC opened 1 year ago
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
Hi, is there anyone in the community currently working on this issue?
Hi, is there anyone in the community currently working on this issue?
No, do you want to finish this task?
Hi, is there anyone in the community currently working on this issue?
No, do you want to finish this task?
I think this pr: https://github.com/apache/shardingsphere/pull/28432 has finished the task.
Hi, is there anyone in the community currently working on this issue?
No, do you want to finish this task?
I think this pr: #28432 has finished the task.
Can you test these sqls? If all sqls have been supported, I will close this issue.
Hi, is there anyone in the community currently working on this issue?
No, do you want to finish this task?
I think this pr: #28432 has finished the task.
Can you test these sqls? If all sqls have been supported, I will close this issue.
Not all SQLs are supported, I only tested the sql of create view as I need it.
If you are interested, you can try to finish this issue. @lancelly
There hasn't been any activity on this issue recently, and in order to prioritize active issues, it will be marked as stale.
Hello @strongduanmu these oracle queries are being parsed correctly
Example : CREATE PROFILE app_user2 LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 60 PASSWORD_REUSE_TIME 60 PASSWORD_REUSE_MAX 5 PASSWORD_VERIFY_FUNCTION verify_function PASSWORD_LOCK_TIME 1/24 PASSWORD_GRACE_TIME 10;
Also I will add these test cases to tests -> it -> parsers -> resources -> sql. for Oracle SQL
Could you please assign me with this issue.
Hello @strongduanmu these oracle queries are being parsed correctly
Example : CREATE PROFILE app_user2 LIMIT FAILED_LOGIN_ATTEMPTS 5 PASSWORD_LIFE_TIME 60 PASSWORD_REUSE_TIME 60 PASSWORD_REUSE_MAX 5 PASSWORD_VERIFY_FUNCTION verify_function PASSWORD_LOCK_TIME 1/24 PASSWORD_GRACE_TIME 10;
Also I will add these test cases to tests -> it -> parsers -> resources -> sql. for Oracle SQL
Could you please assign me with this issue
Background
Hi community, This issue is for #26878.
ShardingSphere parser engine helps users parse a SQL to get the AST (Abstract Syntax Tree) and visit this tree to get SQLStatement (Java Object). Currently, we are planning to enhance the support for Oracle SQL parsing in ShardingSphere.
More details: https://shardingsphere.apache.org/document/current/en/reference/sharding/parse/
Task
This issue is to support more oracle sql parse, as follows:
Process
Relevant Skills
g4
file