|
The null safe operator was added in MCOL-657 but unfortunately we only added support for WHERE filters, not joins.
Test:
CREATE TABLE dim_names_cs (
|
dim_name_id INT NOT NULL,
|
first_name VARCHAR(100) NOT NULL,
|
last_name VARCHAR(100) NOT NULL,
|
attr VARCHAR(100)
|
) ENGINE=ColumnStore;
|
|
CREATE TABLE dim_names_myisam (
|
dim_name_id INT NOT NULL,
|
first_name VARCHAR(100) NOT NULL,
|
last_name VARCHAR(100) NOT NULL,
|
attr VARCHAR(100)
|
) ENGINE=MyISAM;
|
|
INSERT INTO dim_names_cs (dim_name_id, first_name, last_name, attr) VALUES
|
(1, 'Dipti', 'Joshi', ''),
|
(1, 'DIPTI', 'JOSHI', 'Y'),
|
(2, 'Alexander', 'Aldev', NULL);
|
|
INSERT INTO dim_names_myisam (dim_name_id, first_name, last_name, attr) VALUES
|
(1, 'Dipti', 'Joshi', ''),
|
(1, 'DIPTI', 'JOSHI', 'Y'),
|
(2, 'Alexander', 'Aldev',NULL);
|
|
SELECT *
|
FROM dim_names_cs t1
|
JOIN dim_names_cs t2
|
ON t1.attr <=> t2.attr;
|
This produces the error:
ERROR 1815 (HY000): Internal error: IDB-1000: 't1' and 't2' are not joined.
|
|