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

ddl parse error: dup col #3830

Closed
vagetablechicken opened this issue Mar 25, 2024 · 2 comments · Fixed by #3873
Closed

ddl parse error: dup col #3830

vagetablechicken opened this issue Mar 25, 2024 · 2 comments · Fixed by #3873
Assignees

Comments

@vagetablechicken
Copy link
Collaborator

create database db;
use db;
create table t1(c1 int);
create table t2(c1 int);
create table t3(c1 int);
deploy d2 select * from t1 last join t2 on t1.c1=t2.c1 and t1.c1=t2.c1;
-- error: Error: [2000] table [db.t2] add index failed. duplicated col c1
deploy d2 select * from t1 last join t2 on t1.c1=t2.c1 last join t3 on t1.c1=t3.c1 and t2.c1=t3.c1;
-- error too
@vagetablechicken vagetablechicken self-assigned this Mar 25, 2024
@vagetablechicken
Copy link
Collaborator Author

plan_ctx_->index_hints()->Report(scan_op->GetDb(), scan_op->GetName(), keys,
hints will report keys [c1,c1], so we will try to create index key=(c1,c1), error.

@vagetablechicken
Copy link
Collaborator Author

dedup in ddl parser

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant