Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Do
-
1.1.0
-
None
-
2018-10, 2018-11, 2018-12, 2018-13, 2018-14, 2018-15, 2018-16, 2018-17, 2018-18, 2018-19, 2018-20, 2018-21
Description
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.
|
Attachments
Issue Links
- relates to
-
MCOL-657 Support NULL safe equals (<=>)
-
- Closed
-