DROP DATABASE IF EXISTS MCOL4942; CREATE DATABASE MCOL4942; USE MCOL4942; CREATE TABLE t1col (id INT) ENGINE=Columnstore; SELECT * FROM ( SELECT ID FROM ( SELECT 1 ID FROM t1col ) V UNION ALL SELECT ID FROM ( SELECT NULL ID WHERE 1111=2222 ) V ) U; ID DROP DATABASE MCOL4942;