1--disable_warnings 2DROP TABLE IF EXISTS t1; 3--enable_warnings 4 5CREATE TABLE t1 (sint8 tinyint not null); 6INSERT INTO t1 VALUES ('0.1'); 7INSERT INTO t1 VALUES ('0.5'); 8INSERT INTO t1 VALUES ('127.4'); 9INSERT IGNORE INTO t1 VALUES ('127.5'); 10INSERT INTO t1 VALUES ('-0.1'); 11INSERT INTO t1 VALUES ('-0.5'); 12INSERT INTO t1 VALUES ('-127.4'); 13INSERT INTO t1 VALUES ('-127.5'); 14INSERT INTO t1 VALUES ('-128.4'); 15INSERT IGNORE INTO t1 VALUES ('-128.5'); 16SELECT * FROM t1; 17DROP TABLE t1; 18 19CREATE TABLE t1 (uint8 tinyint unsigned not null); 20INSERT INTO t1 VALUES ('0.1'); 21INSERT INTO t1 VALUES ('0.5'); 22INSERT INTO t1 VALUES ('127.4'); 23INSERT INTO t1 VALUES ('127.5'); 24INSERT INTO t1 VALUES ('-0.1'); 25INSERT IGNORE INTO t1 VALUES ('-0.5'); 26INSERT INTO t1 VALUES ('255.4'); 27INSERT IGNORE INTO t1 VALUES ('255.5'); 28SELECT * FROM t1; 29DROP TABLE t1; 30 31 32CREATE TABLE t1 (sint16 smallint not null); 33INSERT INTO t1 VALUES ('0.1'); 34INSERT INTO t1 VALUES ('0.5'); 35INSERT INTO t1 VALUES ('32767.4'); 36INSERT IGNORE INTO t1 VALUES ('32767.5'); 37INSERT INTO t1 VALUES ('-0.1'); 38INSERT INTO t1 VALUES ('-0.5'); 39INSERT INTO t1 VALUES ('-32767.4'); 40INSERT INTO t1 VALUES ('-32767.5'); 41INSERT INTO t1 VALUES ('-32768.4'); 42INSERT IGNORE INTO t1 VALUES ('-32768.5'); 43SELECT * FROM t1; 44DROP TABLE t1; 45 46 47CREATE TABLE t1 (uint16 smallint unsigned not null); 48INSERT INTO t1 VALUES ('0.1'); 49INSERT INTO t1 VALUES ('0.5'); 50INSERT INTO t1 VALUES ('32767.4'); 51INSERT INTO t1 VALUES ('32767.5'); 52INSERT INTO t1 VALUES ('-0.1'); 53INSERT IGNORE INTO t1 VALUES ('-0.5'); 54INSERT INTO t1 VALUES ('65535.4'); 55INSERT IGNORE INTO t1 VALUES ('65535.5'); 56SELECT * FROM t1; 57DROP TABLE t1; 58 59CREATE TABLE t1 (sint24 mediumint not null); 60INSERT INTO t1 VALUES ('0.1'); 61INSERT INTO t1 VALUES ('0.5'); 62INSERT INTO t1 VALUES ('8388607.4'); 63INSERT IGNORE INTO t1 VALUES ('8388607.5'); 64INSERT INTO t1 VALUES ('-0.1'); 65INSERT INTO t1 VALUES ('-0.5'); 66INSERT INTO t1 VALUES ('-8388607.4'); 67INSERT INTO t1 VALUES ('-8388607.5'); 68INSERT INTO t1 VALUES ('-8388608.4'); 69INSERT IGNORE INTO t1 VALUES ('-8388608.5'); 70SELECT * FROM t1; 71DROP TABLE t1; 72 73CREATE TABLE t1 (uint24 mediumint unsigned not null); 74INSERT INTO t1 VALUES ('0.1'); 75INSERT INTO t1 VALUES ('0.5'); 76INSERT INTO t1 VALUES ('8388607.4'); 77INSERT INTO t1 VALUES ('8388607.5'); 78INSERT INTO t1 VALUES ('-0.1'); 79INSERT IGNORE INTO t1 VALUES ('-0.5'); 80INSERT INTO t1 VALUES ('16777215.4'); 81INSERT IGNORE INTO t1 VALUES ('16777215.5'); 82SELECT * FROM t1; 83DROP TABLE t1; 84 85CREATE TABLE t1 (sint64 bigint not null); 86INSERT INTO t1 VALUES ('0.1'); 87INSERT INTO t1 VALUES ('0.5'); 88INSERT INTO t1 VALUES ('9223372036854775807.4'); 89INSERT IGNORE INTO t1 VALUES ('9223372036854775807.5'); 90INSERT INTO t1 VALUES ('-0.1'); 91INSERT INTO t1 VALUES ('-0.5'); 92INSERT INTO t1 VALUES ('-9223372036854775807.4'); 93INSERT INTO t1 VALUES ('-9223372036854775807.5'); 94INSERT INTO t1 VALUES ('-9223372036854775808.4'); 95INSERT IGNORE INTO t1 VALUES ('-9223372036854775808.5'); 96SELECT * FROM t1; 97DROP TABLE t1; 98 99CREATE TABLE t1 (uint64 bigint unsigned not null); 100INSERT INTO t1 VALUES ('0.1'); 101INSERT INTO t1 VALUES ('0.5'); 102INSERT INTO t1 VALUES ('9223372036854775807.4'); 103INSERT INTO t1 VALUES ('9223372036854775807.5'); 104INSERT INTO t1 VALUES ('-0.1'); 105INSERT IGNORE INTO t1 VALUES ('-0.5'); 106INSERT INTO t1 VALUES ('18446744073709551615.4'); 107INSERT IGNORE INTO t1 VALUES ('18446744073709551615.5'); 108INSERT INTO t1 VALUES ('1844674407370955161.0'); 109INSERT INTO t1 VALUES ('1844674407370955161.1'); 110INSERT INTO t1 VALUES ('1844674407370955161.2'); 111INSERT INTO t1 VALUES ('1844674407370955161.3'); 112INSERT INTO t1 VALUES ('1844674407370955161.4'); 113INSERT INTO t1 VALUES ('1844674407370955161.5'); 114INSERT INTO t1 VALUES ('1844674407370955161.0e1'); 115INSERT INTO t1 VALUES ('1844674407370955161.1e1'); 116INSERT INTO t1 VALUES ('1844674407370955161.2e1'); 117INSERT INTO t1 VALUES ('1844674407370955161.3e1'); 118INSERT INTO t1 VALUES ('1844674407370955161.4e1'); 119INSERT INTO t1 VALUES ('1844674407370955161.5e1'); 120INSERT INTO t1 VALUES ('18446744073709551610e-1'); 121INSERT INTO t1 VALUES ('18446744073709551611e-1'); 122INSERT INTO t1 VALUES ('18446744073709551612e-1'); 123INSERT INTO t1 VALUES ('18446744073709551613e-1'); 124INSERT INTO t1 VALUES ('18446744073709551614e-1'); 125INSERT INTO t1 VALUES ('18446744073709551615e-1'); 126SELECT * FROM t1; 127DROP TABLE t1; 128 129CREATE TABLE t1 (str varchar(128), sint64 bigint not null default 0); 130INSERT INTO t1 (str) VALUES ('1.5'); 131INSERT INTO t1 (str) VALUES ('1.00005e4'); 132INSERT INTO t1 (str) VALUES ('1.0005e3'); 133INSERT INTO t1 (str) VALUES ('1.005e2'); 134INSERT INTO t1 (str) VALUES ('1.05e1'); 135INSERT INTO t1 (str) VALUES ('1.5e0'); 136INSERT INTO t1 (str) VALUES ('100005e-1'); 137INSERT INTO t1 (str) VALUES ('100050e-2'); 138INSERT INTO t1 (str) VALUES ('100500e-3'); 139INSERT INTO t1 (str) VALUES ('105000e-4'); 140INSERT INTO t1 (str) VALUES ('150000e-5'); 141UPDATE t1 SET sint64=str; 142SELECT * FROM t1; 143DROP TABLE t1; 144 145 146