struct subfield and list element type

[yliuuuu]

Relevant Issues

• [Closes/Related To] Issue #XXX

Description

• Adding support for parsing Struct type with field declaration and List with Element type in DDL.
  • Note that for operator that takes in type as parameter: IS, CAST, etc, we do not allow struct type with field declaration or list type with element type declaration at the moment.
• Removing support for using NULL and MISSING as data type in DDL.

Other Information

• Updated Unreleased Section in CHANGELOG: [YES/NO]

  • < If NO, why? >

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

  • < If YES, why? >
  • < For this purpose, we define backward-incompatible changes as changes that—when consumed—can potentially result in errors for users that are using our public APIs or the entities that have public visibility in our code-base. >

• Any new external dependencies? [YES/NO]

  • < If YES, which ones and why? >
  • < In addition, please also mention any other alternatives you've considered and the reason they've been discarded >

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

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%	90.70%	-1.82%
:white_check_mark: Passing	5383	5278	-105
:x: Failing	435	541	106
:large_orange_diamond: Ignored	0	0	0
Total Tests	5818	5819	1

Number passing in both: 5071

Number failing in both: 228

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

Number failing in legacy engine but pass in eval engine: 207 :interrobang: CONFORMANCE REPORT REGRESSION DETECTED :interrobang: The complete list can be found in GitHub CI summary, either from Step Summary or in the Artifact. 207 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 (607c4c01169ea9fd80f25463120e01996d0f8064)	b7609c2e965574bcadd8e6cd247222abc8470afb	+/-
% 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 (607c4c01169ea9fd80f25463120e01996d0f8064) but now fail: 0

Number failing in Base (607c4c01169ea9fd80f25463120e01996d0f8064) 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 (607c4c01169ea9fd80f25463120e01996d0f8064)	b7609c2e965574bcadd8e6cd247222abc8470afb	+/-
% Passing	90.67%	90.70%	0.03%
:white_check_mark: Passing	5276	5278	2
:x: Failing	543	541	-2
:large_orange_diamond: Ignored	0	0	0
Total Tests	5819	5819	0

Number passing in both: 5276

Number failing in both: 541

Number passing in Base (607c4c01169ea9fd80f25463120e01996d0f8064) but now fail: 1

Number failing in Base (607c4c01169ea9fd80f25463120e01996d0f8064) but now pass: 3 :interrobang: CONFORMANCE REPORT REGRESSION DETECTED :interrobang:. The following test(s) were previously passing but now fail:

Click here to see

- Example 6 — Value Coercion, compileOption: LEGACY

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

Click here to see

- equiv tupleunion with select list, compileOption: PERMISSIVE - equiv tupleunion with select list, compileOption: LEGACY - Example 6 — Value Coercion, compileOption: LEGACY