EVOLUTION-MANAGER

Edit File: column_signed_bigint_with_index.result

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