mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-20 09:07:44 +03:00
46 lines
903 B
Plaintext
46 lines
903 B
Plaintext
DROP DATABASE IF EXISTS mcs260_db;
|
|
CREATE DATABASE mcs260_db;
|
|
USE mcs260_db;
|
|
CREATE TABLE t1 (a INT, b DECIMAL(3,2), c CHAR(5))ENGINE=Columnstore;
|
|
INSERT INTO t1 VALUES (NULL, NULL, ''),(1, 1.11, 'a'),(2, 2.22, 'b'),(3, 3.33, 'c');
|
|
SELECT SPACE(-1) FROM t1 LIMIT 1;
|
|
SPACE(-1)
|
|
NULL
|
|
SELECT SPACE(0) FROM t1 LIMIT 1;
|
|
SPACE(0)
|
|
NULL
|
|
SELECT SPACE(0.49) FROM t1 LIMIT 1;
|
|
SPACE(0.49)
|
|
NULL
|
|
SELECT SPACE(0.5) FROM t1 LIMIT 1;
|
|
SPACE(0.5)
|
|
|
|
SELECT SPACE(1) FROM t1 LIMIT 1;
|
|
SPACE(1)
|
|
|
|
SELECT SPACE('@') FROM t1 LIMIT 1;
|
|
SPACE('@')
|
|
NULL
|
|
Warnings:
|
|
Warning 1292 Truncated incorrect INTEGER value: '@'
|
|
Warning 1292 Truncated incorrect INTEGER value: '@'
|
|
SELECT a, SPACE(a) FROM t1 ORDER BY 1;
|
|
a SPACE(a)
|
|
NULL NULL
|
|
1
|
|
2
|
|
3
|
|
SELECT b, SPACE(b) FROM t1 ORDER BY 1;
|
|
b SPACE(b)
|
|
NULL NULL
|
|
1.11
|
|
2.22
|
|
3.33
|
|
SELECT c, SPACE(c) FROM t1 ORDER BY 1;
|
|
c SPACE(c)
|
|
NULL NULL
|
|
a NULL
|
|
b NULL
|
|
c NULL
|
|
DROP DATABASE mcs260_db;
|