Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
-
None
-
2025-10
Description
appears that MCOL 5675 might not have been the root cause .
Speak to roman
Need to rollback changes done in https://jira.mariadb.org/browse/MCOL-5675 in columnstore and regression tests repos
To reproduce:
|
|
CREATE TABLE person (
|
name VARCHAR(100) NOT NULL, |
surname VARCHAR(100) DEFAULT NULL |
) ENGINE=Columnstore
|
DEFAULT CHARSET=utf8mb3
|
COLLATE=utf8mb3_general_ci;
|
|
|
INSERT INTO person (name, surname) VALUES
|
('Warren Baby', NULL), |
('Charlie', 'Parker'), |
('Oscar', 'Peterson'); |
|
|
|
|
SELECT * FROM person WHERE surname <=> 1; |
some logs after this error:
sudo tail -f /var/log/mariadb/columnstore/err.log
|
2025-10-22T13:13:10.963816+00:00 ip-172-31-13-58 Calpont[1860393]: 10.963684 |0|0|0| E 00 CAL0000: /home/ubuntu/MariaDBEnterprise/storage/columnstore/columnstore/dbcon/execplan/./treenode.h@880: assertion 'fResult.strVal.str()' failed %%10%% |
It is only known that null-safe equals operator doesn't work in columnstore with joins: https://jira.mariadb.org/browse/MCOL-1216, in other cases it is expected to work
Reproduced on maridb server 10.6, columnstore commit 111d169e4
There is already some implementation ready(don't use commit about joins) see: https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/3760
Attachments
Issue Links
- relates to
-
MCOL-5675 <=> operator raises an unclear error
-
- Closed
-