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
41 lines
1.2 KiB
Plaintext
41 lines
1.2 KiB
Plaintext
--source ../include/have_columnstore.inc
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol_5699 ;
|
|
--enable_warnings
|
|
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');
|
|
|
|
--sorted_result
|
|
SELECT a from cs1 UNION ALL select a from cs2;
|
|
--sorted_result
|
|
SELECT a from cs1 UNION DISTINCT select a from cs2;
|
|
|
|
--ERROR 1815
|
|
SELECT a from cs1 INTERSECT ALL select a from cs2;
|
|
--ERROR 1815
|
|
SELECT a from cs1 INTERSECT DISTINCT select a from cs2;
|
|
--ERROR 1815
|
|
SELECT a from cs1 EXCEPT ALL select a from cs2;
|
|
--ERROR 1815
|
|
SELECT a from cs1 EXCEPT DISTINCT select a from cs2;
|
|
|
|
--ERROR 1815
|
|
SELECT a from cs1 UNION select a from cs2 INTERSECT ALL select a from cs3;
|
|
--ERROR 1815
|
|
SELECT a from cs1 UNION select a from cs2 INTERSECT DISTINCT select a from cs3;
|
|
--ERROR 1815
|
|
SELECT a from cs1 UNION select a from cs2 EXCEPT ALL select a from cs3;
|
|
--ERROR 1815
|
|
SELECT a from cs1 UNION select a from cs2 EXCEPT DISTINCT select a from cs3;
|
|
|
|
|
|
DROP DATABASE mcol_5699 ;
|