# strange number of warnings --disable_abort_on_error set sql_mode='traditional'; --disable_warnings DROP TABLE IF EXISTS t1; --enable_warnings CREATE TABLE t1 (f1 DECIMAL(4)); INSERT INTO t1 values(12),(0); SELECT f1/0 FROM t1; DROP TABLE t1; CREATE TABLE t1 (f1 NUMERIC(4)); INSERT INTO t1 values(12),(0); SELECT f1/0 FROM t1; # Statements for comparison DROP TABLE t1; CREATE TABLE t1 (f1 BIGINT); INSERT INTO t1 values(12),(0); SELECT f1/0 FROM t1; DROP TABLE t1; CREATE TABLE t1 (f1 float); INSERT INTO t1 values(12),(0); SELECT f1/0 FROM t1; DROP TABLE t1; CREATE TABLE t1 (f1 double); INSERT INTO t1 values(12),(0); SELECT f1/0 FROM t1;