# 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;