mariadb-columnstore-engine/mysql-test/columnstore/bugfixes/mcol-5703.test

--source ../include/have_columnstore.inc

--disable_warnings
DROP DATABASE IF EXISTS mcol5703;
--enable_warnings

CREATE DATABASE mcol5703;
USE mcol5703;


CREATE TABLE `doubles` (
  `a` int(11),
  `b` int(11)
) ENGINE=Columnstore DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
INSERT INTO doubles VALUES (1, 2), (2, 4);

--ERROR 1178
SELECT a, b FROM doubles UNION VALUES (3, 6);
--ERROR 1178
SELECT a, b FROM doubles UNION ALL VALUES (3, 6);
--ERROR 1178
SELECT a, b FROM doubles UNION DISTINCT VALUES (3, 6);

DROP TABLE doubles;
DROP DATABASE mcol5703;