Support parsing for attribute and tuple level constraint

[yliuuuu]

Relevant Issues

• [Closes/Related To] Issue #XXX

Description

• Supports parsing of Attribute-Level Constraint (CHECK, NULL, NOT NULL, UNIQUE, PRIMARY KEY)
• Supports parsing of Table-Level Constraints (CHECK, UNIQUE, PRIMARY KEY)
• It contains breaking changes on the AST modeling. in particular remodeling of constraints to be unnested from table definition.
• This is because the constraint can be reused in multiple parts of the DDL operation, (in this PR, attribute level constraint and table level constraints; in the future, we might needs to use constraint in ALTER Statement).

Change log for future reference:

Added

• Supports parsing of Attribute-Level Constraint (CHECK, NULL, NOT NULL, UNIQUE, PRIMARY KEY)
• Supports parsing of Table-Level Constraints (CHECK, UNIQUE, PRIMARY KEY)

  Changed

• Modeling of DDL node.
  • DDL node is modeled as a wrapper around DDLOp. For example: replace statementDDLCreateTable(...) to statementDDL(ddlOpCreateTable(....))

Other Information

• Updated Unreleased Section in CHANGELOG: [YES/NO] -No. Targeting V1 branch.

• Any backward-incompatible changes? [YES/NO]

  • Yes. AST modeling.

• Any new external dependencies? [YES/NO]

  • No.

• Do your changes comply with the Contributing Guidelines and Code Style Guidelines? [YES/NO]

• Yes.

License Information

By submitting this pull request, I confirm that my contribution is made under the terms of the Apache 2.0 license.

[github-actions[bot]]

Conformance comparison report-Cross Engine

	Base (legacy)	eval	+/-
% Passing	92.52%	89.91%	-2.61%
:white_check_mark: Passing	5383	5231	-152
:x: Failing	435	587	152
:large_orange_diamond: Ignored	0	0	0
Total Tests	5818	5818	0

Number passing in both: 5034

Number failing in both: 238

Number passing in legacy engine but fail in eval engine: 349

Number failing in legacy engine but pass in eval engine: 197 :interrobang: CONFORMANCE REPORT REGRESSION DETECTED :interrobang: The complete list can be found in GitHub CI summary, either from Step Summary or in the Artifact. 197 test(s) were failing in legacy but now pass in eval. Before merging, confirm they are intended to pass. The complete list can be found in GitHub CI summary, either from Step Summary or in the Artifact.

Conformance comparison report-Cross Commit-LEGACY

	Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13)	330560b5adf282105296b05b35870f62c16a04d8	+/-
% Passing	92.51%	92.52%	0.02%
:white_check_mark: Passing	5382	5383	1
:x: Failing	436	435	-1
:large_orange_diamond: Ignored	0	0	0
Total Tests	5818	5818	0

Number passing in both: 5382

Number failing in both: 435

Number passing in Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13) but now fail: 0

Number failing in Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13) but now pass: 1 The following test(s) were previously failing but now pass. Before merging, confirm they are intended to pass:

Click here to see

- MYSQL_SELECT_29, compileOption: LEGACY

Conformance comparison report-Cross Commit-EVAL

	Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13)	330560b5adf282105296b05b35870f62c16a04d8	+/-
% Passing	89.91%	89.91%	0.00%
:white_check_mark: Passing	5231	5231	0
:x: Failing	587	587	0
:large_orange_diamond: Ignored	0	0	0
Total Tests	5818	5818	0

Number passing in both: 5231

Number failing in both: 587

Number passing in Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13) but now fail: 0

Number failing in Base (cc05d7ffbd8b9d55b819a458f4e9c820ceabaf13) but now pass: 0