hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.62k stars 553 forks source link

bit类型不支持 #560

Open liujiashun0520 opened 1 year ago

liujiashun0520 commented 1 year ago

描述 审核时,能通过,但是有warning:Not supported data type on field: 'pid'(bit). CREATE TABLE sys_dept2 ( id bigint(20) primary key NOT NULL AUTO_INCREMENT COMMENT 'ID', enabled bit(1) NOT NULL COMMENT '状态'

) ;创建表能通过并执行,虽然有warning:Not supported data type on field: 'pid'(bit). 但是执行insert,检测会报错: insert into sys_dept2 values(1,b'1'); Incorrect integer value: '0x01' for column 'enabled' at row 1.

环境

hanchuanchuan commented 1 year ago

已修复. 请升级到版本 v1.3.0-68

czxin788 commented 1 year ago

./goInception -V Release Version: v1.3.0-68-g2f47aef-dirty Git Commit Hash: 2f47aef6f7ab0428f413e4064148b94cee50a775 Git Branch: master UTC Build Time: 2023-03-20 15:04:09 GoVersion: go version go1.14.15 linux/amd64

还是存在这个错误:

(2, 'CHECKED', 2, 'Audit Completed', "Incorrect integer value: '0x00' for column 'IsUse' at row 1.\nIncorrect integer value: '0x00' for column 'IsCurLast' at row 1.", "INSERT INTO test1.test ... IsUse, ...`) VALUES (... b'0', ...)", 1, '0_0_00000001', None, '0', None, '0')

CREATE TABLE test ( IsUse bit(1) NOT NULL COMMENT '使用/最新(1:最新,0:历史)', ) ENGINE=InnoDB AUTO_INCREMENT=286115 DEFAULT CHARSET=utf8 COMMENT='任职信息'

liujiashun0520 commented 1 year ago

更新1.3.0-68版本,依然无法解决。 Incorrect integer value: '0x01' for column 'enabled' at row 1.

czxin788 commented 1 year ago

原来你也遇到了,我以为是我使用方法的问题

jakehu commented 1 year ago

原来你也遇到了,我以为是我使用方法的问题

+1