We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
测试的表:
CREATE TABLE `test_bit_all` ( id int(10) unsigned NOT NULL AUTO_INCREMENT, bit1 bit(1), bit2 bit(9), bit3 bit(17), bit4 bit(25), bit5 bit(33), bit6 bit(41), bit7 bit(49), bit8 bit(57), bit9 bit(64), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=gbk;
构造数据: insert into test_bit_all(id,bit1,bit2,bit3,bit4,bit5,bit6,bit7,bit8,bit9) values(null,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615) ;
输出结果: EventColumn[index=1,columnType=-7,columnName=bit1,columnValue=1,isNull=false,isKey=false,isUpdate=true] EventColumn[index=2,columnType=-7,columnName=bit2,columnValue=511,isNull=false,isKey=false,isUpdate=true] EventColumn[index=3,columnType=-7,columnName=bit3,columnValue=131071,isNull=false,isKey=false,isUpdate=true] EventColumn[index=4,columnType=-7,columnName=bit4,columnValue=33554431,isNull=false,isKey=false,isUpdate=true] EventColumn[index=5,columnType=-7,columnName=bit5,columnValue=8589934591,isNull=false,isKey=false,isUpdate=true] EventColumn[index=6,columnType=-7,columnName=bit6,columnValue=2199023255551,isNull=false,isKey=false,isUpdate=true] EventColumn[index=7,columnType=-7,columnName=bit7,columnValue=562949953421311,isNull=false,isKey=false,isUpdate=true] EventColumn[index=8,columnType=-7,columnName=bit8,columnValue=144115188075855871,isNull=false,isKey=false,isUpdate=true] EventColumn[index=9,columnType=-7,columnName=bit9,columnValue=18446744073709551615,isNull=false,isKey=false,isUpdate=true]
The text was updated successfully, but these errors were encountered:
fixed issue #70,支持下bit类型的测试
fad2187
agapple
No branches or pull requests
测试的表:
构造数据:
insert into test_bit_all(id,bit1,bit2,bit3,bit4,bit5,bit6,bit7,bit8,bit9) values(null,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615,18446744073709551615) ;
输出结果:
EventColumn[index=1,columnType=-7,columnName=bit1,columnValue=1,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=2,columnType=-7,columnName=bit2,columnValue=511,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=3,columnType=-7,columnName=bit3,columnValue=131071,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=4,columnType=-7,columnName=bit4,columnValue=33554431,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=5,columnType=-7,columnName=bit5,columnValue=8589934591,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=6,columnType=-7,columnName=bit6,columnValue=2199023255551,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=7,columnType=-7,columnName=bit7,columnValue=562949953421311,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=8,columnType=-7,columnName=bit8,columnValue=144115188075855871,isNull=false,isKey=false,isUpdate=true]
EventColumn[index=9,columnType=-7,columnName=bit9,columnValue=18446744073709551615,isNull=false,isKey=false,isUpdate=true]
The text was updated successfully, but these errors were encountered: