Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve integrate SQL parser test engine #3947

Closed
54 tasks done
terrymanu opened this issue Jan 13, 2020 · 0 comments · Fixed by #4158
Closed
54 tasks done

Improve integrate SQL parser test engine #3947

terrymanu opened this issue Jan 13, 2020 · 0 comments · Fixed by #4158
Assignees
Milestone

Comments

@terrymanu
Copy link
Member

terrymanu commented Jan 13, 2020

The current integrate SQL parser test engine is created by old SQL parser engine which parsed from sharding rule and encrypt rule.
The new SQL parser engine is decoupled with rule which only focus SQL itself, so we need to improve the test engine.
The tasks are:

  • Redesign SQL parser test engine.
    • Redesign jaxb domain.
    • Redesign assert engine.
  • Remove useless remain assertions.
    • Remove SQL cases for sharding, encrypt and shadow, just need a unify SQL cases.
    • Remove assertions for sharding condition which has already move to route module.
    • Remove assertions for token which has already move to rewrite module.
  • Finish accurate assert for all test cases.
    • Finish accurate assert for DML.
      • Finish accurate assert for select.
      • Finish accurate assert for insert.
      • Finish accurate assert for update.
      • Finish accurate assert for delete.
    • Finish accurate assert for DDL.
      • Finish accurate assert for create table.
      • Finish accurate assert for alter table.
      • Finish accurate assert for drop table.
      • Finish accurate assert for truncate table.
      • Finish accurate assert for create index.
      • Finish accurate assert for alter index.
      • Finish accurate assert for drop index.
    • Finish accurate assert for DCL.
      • Finish accurate assert for grant.
      • Finish accurate assert for revoke.
      • Finish accurate assert for create-user.
      • Finish accurate assert for create-role.
      • Finish accurate assert for create-login.
      • Finish accurate assert for alter-user.
      • Finish accurate assert for alter-role.
      • Finish accurate assert for alter-login.
      • Finish accurate assert for drop-user.
      • Finish accurate assert for drop-role.
      • Finish accurate assert for drop-login.
      • Finish accurate assert for deny-user.
      • Finish accurate assert for rename-user.
      • Finish accurate assert for set-role.
      • Finish accurate assert for set-password.
    • Finish accurate assert for TCL.
      • Finish accurate assert for set transaction.
      • Finish accurate assert for set auto commit.
      • Finish accurate assert for begin transaction.
      • Finish accurate assert for commit.
      • Finish accurate assert for rollback.
      • Finish accurate assert for savepoint.
    • Finish accurate assert for DAL.
      • Finish accurate assert for use.
      • Finish accurate assert for desc.
      • Finish accurate assert for show databases.
      • Finish accurate assert for show tables.
      • Finish accurate assert for show create table.
      • Finish accurate assert for show columns.
      • Finish accurate assert for show index.
      • Finish accurate assert for show table status.
      • Finish accurate assert for show others.
@terrymanu terrymanu self-assigned this Jan 13, 2020
@terrymanu terrymanu added this to the 5.0.0 milestone Jan 13, 2020
@terrymanu terrymanu modified the milestones: 5.0.0, 4.1.0 Mar 18, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant