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

delete语句使用别名导致审核报错 #505

Closed
dbadylan opened this issue Sep 15, 2022 · 3 comments
Closed

delete语句使用别名导致审核报错 #505

dbadylan opened this issue Sep 15, 2022 · 3 comments

Comments

@dbadylan
Copy link

delete语句如果使用了别名,审核会报错:
1

如果去掉别名,则审核正常:
2

goInception版本:
3

@hanchuanchuan
Copy link
Owner

MySQL能执行通过吗?
可以试试

DELETE t FROM t1 as t WHERE t.id=1;

@dbadylan
Copy link
Author

@hanchuanchuan mysql是可以正常执行的:
1

@hanchuanchuan
Copy link
Owner

关键在于DELETE后面是否跟了表别名t. 注意检查语法.

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

No branches or pull requests

2 participants