-- MCOL-1155
-- I can work around with colum1 is not null and column2 is null... 
-- but should it work with NOT (column1 <=> column2)? Here's an example.

DROP TABLE if exists CS1;
DROP TABLE if exists CS2;
DROP TABLE if exists CS3;

CREATE TABLE cs1 (
    id              INT(10) UNSIGNED NOT NULL, 
    `timestamp_`    DATETIME,
    numeric_val     DOUBLE DEFAULT NULL) ENGINE=columnstore;
 
CREATE TABLE cs2 (
    id              INT(10) UNSIGNED NOT NULL,
    `timestamp_`    DATETIME,
    numeric_val     DOUBLE DEFAULT NULL) ENGINE=columnstore;
 
CREATE TABLE cs3 (
    id              INT(10) UNSIGNED,
    `timestamp_`    DATETIME,
    numeric_val     DOUBLE DEFAULT NULL) ENGINE=columnstore;
 
SELECT @@version,@@version_comment;
 
INSERT INTO cs1 VALUES (1, '2018-01-09 21:59:02', 11.11);
 
INSERT INTO cs2 VALUES (1, '2018-01-09 21:59:02', 22.22);
INSERT INTO cs3 VALUES (1, '2018-01-09 21:59:02', 33.33);
INSERT INTO cs3 VALUES (null, '2018-02-09 21:59:02', 44.44);
select * from cs1; 
select * from cs2; 
select * from cs3; 
