Support VALUES and TABLE statements syntax

[tangenta]

Description

Related parser issue: pingcap/parser#869

Example

The TABLE and VALUES statements are two query specification statements introduced in MySQL 8.0.19.

TABLE tbl_name [ORDER BY col_name] [LIMIT limit [OFFSET offset]];

VALUES ROW(val1, val2, …), … [ORDER BY column_N [LIMIT limit [OFFSET offset]]];

Explaination

These can be used in place everywhere a SELECT statement was expected, including:

• UNION
• JOIN
• subqueries
• SELECT INTO OUTFILE
• INSERT INTO SELECT
• CREATE TABLE SELECT

Solution

For a reference, please see pingcap/parser#680 and learn how to support a new syntax in the parser.

Score

• 300

SIG Slack Channel

You can join #sig-ddl on slack in your spare time to discuss and get help with mentors or others.

Mentor(s)

• @tangenta

Contact the mentors: #tidb-challenge-program channel in TiDB Community Slack Workspace

Recommended Skills

• Parser
• Golang

Learning Materials

• Parser Quickstart
• Parser implementation(CN)

[YangKian]

/pick-up

[ti-challenge-bot]

Pick up success.

[ti-challenge-bot]

@YangKian You did not submit PR within 7 days, so give up automatically.

[YangKian]

/pick-up

[ti-challenge-bot]

Pick up success.

[ti-challenge-bot]

@YangKian You did not submit PR within 7 days, so give up automatically.

[YangKian]

/pick-up

[ti-challenge-bot]

Pick up success.

[ti-challenge-bot]

@YangKian You did not submit PR within 7 days, so give up automatically.

[kennytm]

We should reopen this. #20314 only updated the parser deps, but did not actually implement the feature. Currently using TABLE and VALUES statement just crashes (#21486). At least it should throw a friendly "not yet implemented" error message.