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 b.* 报语法错误 #585

Closed
czxin788 opened this issue Jun 28, 2023 · 1 comment
Closed

delete b.* 报语法错误 #585

czxin788 opened this issue Jun 28, 2023 · 1 comment

Comments

@czxin788
Copy link

描述
mysql可以正常执行:delete b.* from aaa a left join bbb b on a.numericalorder = b.numericalorder where enterpriseid in (116765594498537) and a.datadate between '2023-01-01' and '2023-05-31' and b.accochecktype in (201708010104402109, 201708010104402114)

但是goinception审核报错:
line 1 column 18 near "* from aaa a left join bbb b on a.numericalorder = b.numericalorder where enterpriseid in (116765594498537) and a.datadate between '2023-01-01' and '2023-05-31' and b.accochecktype in (201708010104402109, 201708010104402114)"

重现
模拟重现的步骤

环境

  • 数据库: mysql 5.7.34
  • goinception版本:
    /goInception -V
    Release Version: v1.3.0-68-g2f47aef-dirty
    Git Commit Hash: 2f47aef
    Git Branch: master
    UTC Build Time: 2023-03-20 15:04:09
    GoVersion: go version go1.14.15 linux/amd64

参数
可能与问题相关的设置参数

@hanchuanchuan
Copy link
Owner

请改为 delete b from aaa a left join bbb b ...
属于TiDB语法兼容性问题, 有些特殊写法不支持.
参考 #505

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