DROP DATABASE IF EXISTS mcol_4728;
CREATE DATABASE mcol_4728;
USE mcol_4728;
SET columnstore_select_handler=ON;
CREATE TABLE t1 (a INT) ENGINE=ColumnStore;
SELECT SUM(0+0)-SUM(0+0) FROM t1;
SUM(0+0)-SUM(0+0)
NULL
SELECT SUM(0) FROM t1;
SUM(0)
NULL
SELECT COUNT(0) FROM t1;
COUNT(0)
0
SELECT COUNT(NULL) FROM t1;
COUNT(NULL)
0
SELECT COUNT(COALESCE(NULL)) FROM t1;
COUNT(COALESCE(NULL))
0
SELECT MAX(0) FROM t1;
MAX(0)
NULL
SELECT SUM(1)+1 FROM t1;
SUM(1)+1
NULL
SELECT SUM(COALESCE(1))+1 FROM t1;
SUM(COALESCE(1))+1
NULL
SELECT sum(rand(0))+1 FROM t1;
sum(rand(0))+1
NULL
INSERT INTO t1 VALUES (100);
SELECT SUM(0+0)-SUM(0+0) FROM t1;
SUM(0+0)-SUM(0+0)
0
SELECT SUM(0) FROM t1;
SUM(0)
0
SELECT COUNT(0) FROM t1;
COUNT(0)
1
SELECT COUNT(NULL) FROM t1;
COUNT(NULL)
0
SELECT COUNT(COALESCE(NULL)) FROM t1;
COUNT(COALESCE(NULL))
0
SELECT MAX(0) FROM t1;
MAX(0)
0
SELECT SUM(1)+1 FROM t1;
SUM(1)+1
2
SELECT SUM(COALESCE(1))+1 FROM t1;
SUM(COALESCE(1))+1
2
SELECT sum(rand(0))+1 FROM t1;
sum(rand(0))+1
1.1552204276949358
DROP TABLE t1;
DROP DATABASE mcol_4728;
USE test;