terrymanu opened a new issue #4453: Completion SET statement URL: https://github.com/apache/incubator-shardingsphere/issues/4453 We just parse SET statement simplify, it is not enough. The SET statement is different with different dialect. Syntax of MySQL: ``` SET variable = expr [, variable = expr] ... variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | {PERSIST | @@PERSIST.} system_var_name | {PERSIST_ONLY | @@PERSIST_ONLY.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } ``` Syntax of PostgreSQL: ``` SET [ SESSION | LOCAL ] configuration_parameter { TO | = } { value | 'value' | DEFAULT } SET [ SESSION | LOCAL ] TIME ZONE { timezone | LOCAL | DEFAULT } ``` Even they are different totally, but we still can find the same abstraction of them. The tasks of SET statement: - [ ] Parse variable name - [ ] Parse variable value - [ ] Parse scope - [ ] Can support set multiple variables - [ ] Consider about Oracle and SQLServer - [ ] Consider about use sub-class to split different of SET dialect
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
