EVOLUTION-MANAGER

Edit File: column_unsigned_int_with_index.result

DROP TABLE IF EXISTS items; CREATE TABLE items ( name VARCHAR(255), price INT UNSIGNED KEY ) DEFAULT CHARSET=utf8; INSERT INTO items VALUES ("car", 4294967295); INSERT INTO items VALUES ("note PC", 32767); INSERT INTO items VALUES ("discount", 0); INSERT INTO items VALUES ("coke", 100); INSERT INTO items VALUES ("bike", 2147483648); SELECT * FROM items; name price discount 0 coke 100 note PC 32767 bike 2147483648 car 4294967295 SELECT * FROM items WHERE price <= 2147483648; name price discount 0 coke 100 note PC 32767 bike 2147483648 SELECT * FROM items WHERE price > 2147483647; name price bike 2147483648 car 4294967295 DROP TABLE items;