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

mysql5.7或者mariadb创建索引指定VISIBLE审核通过,执行报错 #247

Closed
xinxinfly opened this issue Jul 22, 2020 · 0 comments
Closed

Comments

@xinxinfly
Copy link

xinxinfly commented Jul 22, 2020

数据库版本mysql5.7,mariadb sqL:
ALTER TABLE xx.xx
ADD UNIQUE INDEX xx (xx ASC) VISIBLE;
上述sql是开发从第三方工具生成,指定了visible,goinception审核通过
但是最后执行阶段报错:
Execute: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2.
索引 VISIBLE 与 INVISIBLE 在 MySQL 8 之后才支持,
建议8之前的mysql在审核的时候可以直接显示语法错误,而不是最后执行报错,谢谢

hanchuanchuan added a commit that referenced this issue Jul 23, 2020
update: 优化索引可见性审核逻辑,以免后端数据库不支持(fix #247)
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

1 participant