1--disable_warnings 2DROP TABLE IF EXISTS t4,t5; 3--enable_warnings 4CREATE TABLE t4(c1 DECIMAL(1,0) NOT NULL); 5INSERT INTO t4 (c1) VALUES(0); 6INSERT INTO t4 (c1) VALUES(1.0); 7INSERT INTO t4 (c1) VALUES(-9.0); 8SELECT * FROM t4; 9SELECT COUNT(c1) AS total_rows FROM t4; 10SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 11SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 12SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 13DROP TABLE t4; 14CREATE TABLE t5(c1 DECIMAL(5,4) NOT NULL); 15INSERT INTO t5 (c1) VALUES(0); 16INSERT INTO t5 (c1) VALUES(1.0); 17INSERT INTO t5 (c1) VALUES(1.2345); 18INSERT INTO t5 (c1) VALUES(-9.0); 19INSERT INTO t5 (c1) VALUES(-9.12345); 20SELECT * FROM t5; 21SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 22SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 23SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 24DROP TABLE t5; 25CREATE TABLE t4(c1 DEC(1,0) NOT NULL); 26INSERT INTO t4 (c1) VALUES(0); 27INSERT INTO t4 (c1) VALUES(1.0); 28INSERT INTO t4 (c1) VALUES(-9.0); 29SELECT * FROM t4; 30SELECT COUNT(c1) AS total_rows FROM t4; 31SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 32SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 33SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 34DROP TABLE t4; 35CREATE TABLE t5(c1 DEC(5,4) NOT NULL); 36INSERT INTO t5 (c1) VALUES(0); 37INSERT INTO t5 (c1) VALUES(1.0); 38INSERT INTO t5 (c1) VALUES(1.2345); 39INSERT INTO t5 (c1) VALUES(-9.0); 40INSERT INTO t5 (c1) VALUES(-9.12345); 41SELECT * FROM t5; 42SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 43SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 44SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 45DROP TABLE t5; 46CREATE TABLE t4(c1 FIXED(1,0) NOT NULL); 47INSERT INTO t4 (c1) VALUES(0); 48INSERT INTO t4 (c1) VALUES(1.0); 49INSERT INTO t4 (c1) VALUES(-9.0); 50SELECT * FROM t4; 51SELECT COUNT(c1) AS total_rows FROM t4; 52SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 53SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 54SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 55DROP TABLE t4; 56CREATE TABLE t5(c1 FIXED(5,4) NOT NULL); 57INSERT INTO t5 (c1) VALUES(0); 58INSERT INTO t5 (c1) VALUES(1.0); 59INSERT INTO t5 (c1) VALUES(1.2345); 60INSERT INTO t5 (c1) VALUES(-9.0); 61INSERT INTO t5 (c1) VALUES(-9.12345); 62SELECT * FROM t5; 63SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 64SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 65SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 66DROP TABLE t5; 67CREATE TABLE t4(c1 NUMERIC(1,0) NOT NULL); 68INSERT INTO t4 (c1) VALUES(0); 69INSERT INTO t4 (c1) VALUES(1.0); 70INSERT INTO t4 (c1) VALUES(-9.0); 71SELECT * FROM t4; 72SELECT COUNT(c1) AS total_rows FROM t4; 73SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 74SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 75SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 76DROP TABLE t4; 77CREATE TABLE t5(c1 NUMERIC(5,4) NOT NULL); 78INSERT INTO t5 (c1) VALUES(0); 79INSERT INTO t5 (c1) VALUES(1.0); 80INSERT INTO t5 (c1) VALUES(1.2345); 81INSERT INTO t5 (c1) VALUES(-9.0); 82INSERT INTO t5 (c1) VALUES(-9.12345); 83SELECT * FROM t5; 84SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 85SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 86SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 87DROP TABLE t5; 88CREATE TABLE t4(c1 DOUBLE(1,0) NOT NULL); 89INSERT INTO t4 (c1) VALUES(0); 90INSERT INTO t4 (c1) VALUES(1.0); 91INSERT INTO t4 (c1) VALUES(-9.0); 92SELECT * FROM t4; 93SELECT COUNT(c1) AS total_rows FROM t4; 94SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 95SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 96SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 97DROP TABLE t4; 98CREATE TABLE t5(c1 DOUBLE(5,4) NOT NULL); 99INSERT INTO t5 (c1) VALUES(0); 100INSERT INTO t5 (c1) VALUES(1.0); 101INSERT INTO t5 (c1) VALUES(1.2345); 102INSERT INTO t5 (c1) VALUES(-9.0); 103INSERT INTO t5 (c1) VALUES(-9.12345); 104SELECT * FROM t5; 105SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 106SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 107SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 108DROP TABLE t5; 109CREATE TABLE t4(c1 REAL(1,0) NOT NULL); 110INSERT INTO t4 (c1) VALUES(0); 111INSERT INTO t4 (c1) VALUES(1.0); 112INSERT INTO t4 (c1) VALUES(-9.0); 113SELECT * FROM t4; 114SELECT COUNT(c1) AS total_rows FROM t4; 115SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 116SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 117SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 118DROP TABLE t4; 119CREATE TABLE t5(c1 REAL(5,4) NOT NULL); 120INSERT INTO t5 (c1) VALUES(0); 121INSERT INTO t5 (c1) VALUES(1.0); 122INSERT INTO t5 (c1) VALUES(1.2345); 123INSERT INTO t5 (c1) VALUES(-9.0); 124INSERT INTO t5 (c1) VALUES(-9.12345); 125SELECT * FROM t5; 126SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 127SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 128SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 129DROP TABLE t5; 130CREATE TABLE t4(c1 DOUBLE PRECISION(1,0) NOT NULL); 131INSERT INTO t4 (c1) VALUES(0); 132INSERT INTO t4 (c1) VALUES(1.0); 133INSERT INTO t4 (c1) VALUES(-9.0); 134SELECT * FROM t4; 135SELECT COUNT(c1) AS total_rows FROM t4; 136SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 137SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 138SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 139DROP TABLE t4; 140CREATE TABLE t5(c1 DOUBLE PRECISION(5,4) NOT NULL); 141INSERT INTO t5 (c1) VALUES(0); 142INSERT INTO t5 (c1) VALUES(1.0); 143INSERT INTO t5 (c1) VALUES(1.2345); 144INSERT INTO t5 (c1) VALUES(-9.0); 145INSERT INTO t5 (c1) VALUES(-9.12345); 146SELECT * FROM t5; 147SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 148SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 149SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 150DROP TABLE t5; 151CREATE TABLE t4(c1 FLOAT(1,0) NOT NULL); 152INSERT INTO t4 (c1) VALUES(0); 153INSERT INTO t4 (c1) VALUES(1.0); 154INSERT INTO t4 (c1) VALUES(-9.0); 155SELECT * FROM t4; 156SELECT COUNT(c1) AS total_rows FROM t4; 157SELECT COUNT(c1) AS positive_rows FROM t4 WHERE c1 > 0.0; 158SELECT COUNT(c1) AS negative_rows FROM t4 WHERE c1 < 0.0; 159SELECT COUNT(c1) AS zero_rows FROM t4 WHERE c1 = 0.0; 160DROP TABLE t4; 161CREATE TABLE t5(c1 FLOAT(5,4) NOT NULL); 162INSERT INTO t5 (c1) VALUES(0); 163INSERT INTO t5 (c1) VALUES(1.0); 164INSERT INTO t5 (c1) VALUES(1.2345); 165INSERT INTO t5 (c1) VALUES(-9.0); 166INSERT INTO t5 (c1) VALUES(-9.12345); 167SELECT * FROM t5; 168SELECT COUNT(c1) AS positive_rows FROM t5 WHERE c1 > 0.0; 169SELECT COUNT(c1) AS negative_rows FROM t5 WHERE c1 < 0.0; 170SELECT COUNT(c1) AS zero_rows FROM t5 WHERE c1 = 0.0; 171DROP TABLE t5; 172 173