DROP DATABASE IF EXISTS mcs227_db;
CREATE DATABASE mcs227_db;
USE mcs227_db;
CREATE TABLE t1
(
t1_INT INT,
t1_DECIMAL DECIMAL(12,5)
)ENGINE=Columnstore;
INSERT INTO t1 VALUES(1, 1234.567),(20, 111.2345),(24, 98765.4321);
SELECT t1_INT, t1_INT DIV 2 FROM t1 ORDER BY 1;
t1_INT	t1_INT DIV 2
1	0
20	10
24	12
SELECT t1_INT, t1_INT DIV 2.4 FROM t1 ORDER BY 1;
t1_INT	t1_INT DIV 2.4
1	0
20	8
24	10
SELECT t1_INT, t1_INT DIV 4.7 FROM t1 ORDER BY 1;
t1_INT	t1_INT DIV 4.7
1	0
20	4
24	5
SELECT t1_DECIMAL, t1_DECIMAL DIV 2 FROM t1 ORDER BY 1;
t1_DECIMAL	t1_DECIMAL DIV 2
111.23450	55
1234.56700	617
98765.43210	49382
SELECT t1_DECIMAL, t1_DECIMAL DIV 2.4 FROM t1 ORDER BY 1;
t1_DECIMAL	t1_DECIMAL DIV 2.4
111.23450	46
1234.56700	514
98765.43210	41152
SELECT t1_DECIMAL, t1_DECIMAL DIV 4.7 FROM t1 ORDER BY 1;
t1_DECIMAL	t1_DECIMAL DIV 4.7
111.23450	23
1234.56700	262
98765.43210	21013
SELECT t1_INT DIV 0 FROM t1 LIMIT 1;
t1_INT DIV 0
NULL
SELECT t1_DECIMAL DIV 0 FROM t1 LIMIT 1;
t1_DECIMAL DIV 0
NULL
SELECT 0 DIV t1_INT FROM t1 LIMIT 1;
0 DIV t1_INT
0
SELECT 0 DIV t1_DECIMAL FROM t1 LIMIT 1;
0 DIV t1_DECIMAL
0
DROP DATABASE mcs227_db;