mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-04-20 09:07:44 +03:00
30 lines
744 B
Plaintext
30 lines
744 B
Plaintext
#
|
|
# SPACE() function
|
|
# Author: Bharath, bharath.bokka@mariadb.com
|
|
#
|
|
-- source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcs260_db;
|
|
--enable_warnings
|
|
|
|
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;
|
|
SELECT SPACE(0) FROM t1 LIMIT 1;
|
|
SELECT SPACE(0.49) FROM t1 LIMIT 1;
|
|
SELECT SPACE(0.5) FROM t1 LIMIT 1;
|
|
SELECT SPACE(1) FROM t1 LIMIT 1;
|
|
SELECT SPACE('@') FROM t1 LIMIT 1;
|
|
|
|
SELECT a, SPACE(a) FROM t1 ORDER BY 1;
|
|
SELECT b, SPACE(b) FROM t1 ORDER BY 1;
|
|
SELECT c, SPACE(c) FROM t1 ORDER BY 1;
|
|
|
|
# Clean UP
|
|
DROP DATABASE mcs260_db;
|