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

sql 检查字段与实际不符合也可以通过 #646

Open
G-Akiraka opened this issue May 11, 2024 · 3 comments
Open

sql 检查字段与实际不符合也可以通过 #646

G-Akiraka opened this issue May 11, 2024 · 3 comments

Comments

@G-Akiraka
Copy link

描述
目前发现表字段是 bit、bigint等 类型时候,语句写的是 '1' 正确应该去掉单引号或双引号,但是在sql 检查时候不会发现问题,但执行时候会提示 Data too long for column 'is _used' at row 1

重现
模拟重现的步骤

环境

  • 数据库: mysql
  • 版本: 5.7.32
@zmix999
Copy link

zmix999 commented May 21, 2024

这是主分支bit类型值检查不完全,可以看下我fork的分支https://gitee.com/zhoujin826/goInception

@G-Akiraka
Copy link
Author

这是主分支bit类型值检查不完全,可以看下我fork的分支https://gitee.com/zhoujin826/goInception

可以加个好友私下交流吗?gitee 有发站内信

@zmix999
Copy link

zmix999 commented May 23, 2024

客气,一起学习

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