EVOLUTION-MANAGER

Edit File: column_unsigned_bigint_with_index.result

DROP TABLE IF EXISTS items; CREATE TABLE items ( name VARCHAR(255), price BIGINT UNSIGNED KEY ) DEFAULT CHARSET=utf8; INSERT INTO items VALUES ("house", 18446744073709551615); INSERT INTO items VALUES ("note PC", 32767); INSERT INTO items VALUES ("discount", 0); INSERT INTO items VALUES ("coke", 100); INSERT INTO items VALUES ("super car", 9223372036854775808); SELECT * FROM items; name price discount 0 coke 100 note PC 32767 super car 9223372036854775808 house 18446744073709551615 SELECT * FROM items WHERE price <= 9223372036854775808; name price discount 0 coke 100 note PC 32767 super car 9223372036854775808 SELECT * FROM items WHERE price > 9223372036854775807; name price super car 9223372036854775808 house 18446744073709551615 DROP TABLE items;