mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-05-13 01:01:28 +03:00
54 lines
1.4 KiB
Plaintext
54 lines
1.4 KiB
Plaintext
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;
|