You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-07-30 19:23:07 +03:00
44 lines
1.6 KiB
Plaintext
44 lines
1.6 KiB
Plaintext
DROP DATABASE IF EXISTS mcol_5699 ;
|
|
CREATE DATABASE mcol_5699 ;
|
|
USE mcol_5699 ;
|
|
CREATE TABLE cs1(a text) ENGINE=columnstore;
|
|
INSERT INTO cs1 VALUES('a'),('b'),('c'),('x');
|
|
CREATE TABLE cs2(a text) ENGINE=columnstore;
|
|
INSERT INTO cs2 VALUES('y'),('z'),('x');
|
|
CREATE TABLE cs3(a text) ENGINE=columnstore;
|
|
INSERT INTO cs3 VALUES('r'),('t'),('z');
|
|
SELECT a from cs1 UNION ALL select a from cs2;
|
|
a
|
|
a
|
|
b
|
|
c
|
|
x
|
|
x
|
|
y
|
|
z
|
|
SELECT a from cs1 UNION DISTINCT select a from cs2;
|
|
a
|
|
a
|
|
b
|
|
c
|
|
x
|
|
y
|
|
z
|
|
SELECT a from cs1 INTERSECT ALL select a from cs2;
|
|
ERROR HY000: Internal error: INTERSECT is not supported by Columnstore engine
|
|
SELECT a from cs1 INTERSECT DISTINCT select a from cs2;
|
|
ERROR HY000: Internal error: INTERSECT is not supported by Columnstore engine
|
|
SELECT a from cs1 EXCEPT ALL select a from cs2;
|
|
ERROR HY000: Internal error: EXCEPT is not supported by Columnstore engine
|
|
SELECT a from cs1 EXCEPT DISTINCT select a from cs2;
|
|
ERROR HY000: Internal error: EXCEPT is not supported by Columnstore engine
|
|
SELECT a from cs1 UNION select a from cs2 INTERSECT ALL select a from cs3;
|
|
ERROR HY000: Internal error: INTERSECT is not supported by Columnstore engine
|
|
SELECT a from cs1 UNION select a from cs2 INTERSECT DISTINCT select a from cs3;
|
|
ERROR HY000: Internal error: INTERSECT is not supported by Columnstore engine
|
|
SELECT a from cs1 UNION select a from cs2 EXCEPT ALL select a from cs3;
|
|
ERROR HY000: Internal error: EXCEPT is not supported by Columnstore engine
|
|
SELECT a from cs1 UNION select a from cs2 EXCEPT DISTINCT select a from cs3;
|
|
ERROR HY000: Internal error: EXCEPT is not supported by Columnstore engine
|
|
DROP DATABASE mcol_5699 ;
|