You've already forked mariadb-columnstore-engine
mirror of
https://github.com/mariadb-corporation/mariadb-columnstore-engine.git
synced 2025-08-07 03:22:57 +03:00
47 lines
1.5 KiB
Plaintext
47 lines
1.5 KiB
Plaintext
# MCOL-5992: NULLIF() returns NULL when NULL is the first argument
|
|
--source ../include/have_columnstore.inc
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mcol5992;
|
|
--enable_warnings
|
|
|
|
CREATE DATABASE mcol5992;
|
|
USE mcol5992;
|
|
|
|
CREATE TABLE `CS_LEG` (
|
|
ID BIGINT(20) DEFAULT NULL,
|
|
bigint_col BIGINT(20) DEFAULT NULL,
|
|
tinyint_col TINYINT DEFAULT NULL,
|
|
smallint_col SMALLINT DEFAULT NULL,
|
|
mediumint_col MEDIUMINT DEFAULT NULL,
|
|
int_col INT DEFAULT NULL,
|
|
float_col FLOAT DEFAULT NULL,
|
|
double_col DOUBLE DEFAULT NULL,
|
|
decimal_col DECIMAL(10,2) DEFAULT NULL,
|
|
date_col DATE DEFAULT NULL,
|
|
datetime_col DATETIME DEFAULT NULL,
|
|
time_col TIME DEFAULT NULL,
|
|
varchar_col VARCHAR(255) DEFAULT NULL,
|
|
char_col CHAR(10) DEFAULT NULL,
|
|
text_col TEXT DEFAULT NULL
|
|
) ENGINE=Columnstore;
|
|
|
|
INSERT INTO CS_LEG(ID) VALUES(1);
|
|
|
|
SELECT NULLIF(bigint_col, 9999999999) FROM CS_LEG;
|
|
SELECT NULLIF(tinyint_col, 1) FROM CS_LEG;
|
|
SELECT NULLIF(smallint_col, 100) FROM CS_LEG;
|
|
SELECT NULLIF(mediumint_col, 1000) FROM CS_LEG;
|
|
SELECT NULLIF(int_col, 99999) FROM CS_LEG;
|
|
SELECT NULLIF(float_col, 1.1) FROM CS_LEG;
|
|
SELECT NULLIF(double_col, 2.2) FROM CS_LEG;
|
|
SELECT NULLIF(decimal_col, 123.45) FROM CS_LEG;
|
|
SELECT NULLIF(date_col, '2025-01-01') FROM CS_LEG;
|
|
SELECT NULLIF(datetime_col, '2025-01-01 12:00:00') FROM CS_LEG;
|
|
SELECT NULLIF(time_col, '12:00:00') FROM CS_LEG;
|
|
SELECT NULLIF(varchar_col, 'Test') FROM CS_LEG;
|
|
SELECT NULLIF(char_col, 'Test') FROM CS_LEG;
|
|
SELECT NULLIF(text_col, 'Test') FROM CS_LEG;
|
|
|
|
DROP DATABASE mcol5992;
|