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.

Sign up for GitHub

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

Jump to bottom

ALTER TABLE ... DROP FOREIGN KEY IF EXISTS ... shouldn't be supported in parser #56701

Closed
Tracked by #55861
YangKeao opened this issue Oct 17, 2024 · 0 comments · Fixed by #56703
Closed
Tracked by #55861

ALTER TABLE ... DROP FOREIGN KEY IF EXISTS ... shouldn't be supported in parser #56701

YangKeao opened this issue Oct 17, 2024 · 0 comments · Fixed by #56703
Assignees
@YangKeao
Labels
component/parser good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.

Comments

@YangKeao
Copy link
Member

See https://bugs.mysql.com/bug.php?id=5746. MySQL doesn't have this syntax. TiDB also didn't support this operation, but the parser actually can parse it.
@YangKeao YangKeao added type/bug The issue is confirmed as a bug. component/parser sig/sql-infra SIG: SQL Infra severity/minor labels Oct 17, 2024
@YangKeao YangKeao self-assigned this Oct 17, 2024
@YangKeao YangKeao mentioned this issue Oct 17, 2024
Open
17 tasks
@lance6716 lance6716 added the good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. label Oct 17, 2024
@YangKeao YangKeao mentioned this issue Oct 17, 2024
Merged
13 tasks
@ti-chi-bot ti-chi-bot bot closed this as completed in 2f8b11a Oct 31, 2024
@D3Hunter D3Hunter mentioned this issue Nov 20, 2024
Merged
1 task
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@YangKeao YangKeao

Labels
component/parser good first issue Denotes an issue ready for a new contributor, according to the "help wanted" guidelines. severity/minor sig/sql-infra SIG: SQL Infra type/bug The issue is confirmed as a bug.
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

parser: don't support ALTER TABLE ... DROP FOREIGN KEY if exists YangKeao/tidb
2 participants
@lance6716 @YangKeao