DROP DATABASE IF EXISTS mcs42_db;
CREATE DATABASE mcs42_db;
USE mcs42_db;
SELECT @@sql_mode;
@@sql_mode
STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
CREATE TABLE t (col TINYINT)ENGINE=Columnstore;
INSERT INTO t SET col = 128;
ERROR 22003: Out of range value for column 'col' at row 1
SELECT col FROM t;
col
INSERT INTO t SET col = 1 / 0;
ERROR 22012: Division by 0
SELECT col FROM t;
col
SET sql_mode='';
INSERT INTO t SET col = 128;
Warnings:
Warning	1264	Out of range value for column 'col' at row 1
SELECT col FROM t;
col
127
INSERT INTO t SET col = 1 / 0;
SELECT col FROM t;
col
127
NULL
CREATE TABLE t1 (col FLOAT)ENGINE=Columnstore;
INSERT INTO t1 VALUES (NULL),(2.13),(-2.13),(21.5e0),(-21.5e0),(35.498),(986.512),(-376012.9751);
SELECT col, ROUND(col), ROUND(col,1), ROUND(col,-1), ROUND(col,-2), ROUND(col,3) FROM t1;
col	ROUND(col)	ROUND(col,1)	ROUND(col,-1)	ROUND(col,-2)	ROUND(col,3)
NULL	NULL	NULL	NULL	NULL	NULL
2.13	2	2.1	0	0	2.130
-2.13	-2	-2.1	-0	-0	-2.130
21.5	22	21.5	20	0	21.500
-21.5	-22	-21.5	-20	-0	-21.500
35.498	35	35.5	40	0	35.498
986.512	987	986.5	990	1000	986.512
-376013	-376013	-376013.0	-376010	-376000	-376012.969
SELECT (.1 + .2) = .3;
(.1 + .2) = .3
1
SELECT (.1e0 + .2e0) = .3e0;
(.1e0 + .2e0) = .3e0
0
SELECT .01 * .01;
.01 * .01
0.0001
SELECT .1 / .1;
.1 / .1
1.00000
SET sql_mode=default;
DROP DATABASE mcs42_db;