You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-08-07 03:22:57 +03:00
34 lines
1.3 KiB
Plaintext
34 lines
1.3 KiB
Plaintext
-- source ../include/have_columnstore.inc
|
|
--source include/have_innodb.inc
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol_4622;
|
|
--enable_warnings
|
|
CREATE DATABASE mcol_4622;
|
|
USE mcol_4622;
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
|
|
CREATE TABLE t1 (a VARCHAR(32), b FLOAT, c DOUBLE) ENGINE=ColumnStore;
|
|
INSERT INTO t1 VALUES ('aaaa', 1.5, 1.5);
|
|
INSERT INTO t1 VALUES ('abcdefgh', 1.2, 1.2);
|
|
INSERT INTO t1 VALUES ('abcdefgh', 1.5, 1.5);
|
|
INSERT INTO t1 VALUES ('abcdefgh', 1.7, 1.7);
|
|
INSERT INTO t1 VALUES ('abcdefgh', 12, 12);
|
|
INSERT INTO t1 VALUES ('abcdefgh', -0, 0);
|
|
INSERT INTO t1 VALUES ('abcdefgh', -2, -2);
|
|
INSERT INTO t1 VALUES ('abcdefgh', -12, -12);
|
|
|
|
SELECT LEFT(a, b), LEFT(a, c), RIGHT(a, b), RIGHT(a, c) FROM t1;
|
|
|
|
create table TFloatsInnoDB(a float, b double) engine innodb;
|
|
insert into TFloatsInnoDB values (-3.5,-3.5),(-3.1, -3.1),(-3.0, -3.0),(-2.9,-2.9),(0,0),(2.9, 2.9),(3.1,3.1),(3.5,3.5);
|
|
select a, cast(a as signed), cast(a as unsigned), b, cast(b as signed), cast(b as unsigned) from TFloatsInnoDB;
|
|
|
|
create table TFloatsCS(a float, b double) engine columnstore;
|
|
insert into TFloatsCS values (-3.5,-3.5),(-3.1, -3.1),(-3.0, -3.0),(-2.9,-2.9),(0,0),(2.9, 2.9),(3.1,3.1),(3.5,3.5);
|
|
select a, cast(a as signed), cast(a as unsigned), b, cast(b as signed), cast(b as unsigned) from TFloatsCS;
|
|
|
|
DROP DATABASE mcol_4622;
|
|
--enable_warnings
|