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;