Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
6.3.1, 6.4.2
-
None
Description
To reproduce:
create table t1 (c1 varchar(200)) engine = columnstore; |
create table t2 (c2 char(20)) engine = columnstore; |
create view v1 as select distinct `t1`.`c1` AS `c1` from `t1` where !(`t1`.`c1` in (select `t2`.`c2` from `t2`));
|
SELECT * from t1 a LEFT JOIN v1 n ON LOWER(n.c1) = LOWER(a.c1);
|
Sep 19 09:31:37 1e3afaf1eaef Calpont[135]: 37.906020 |0|0|0| E 00 CAL0000: /home/buildbot/buildbot/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX/mariadb-10.6.8/storage/columnstore/columnstore/dbcon/joblist/tuplehashjoin.cpp@1095: assertion 'idlsz > 1' failed |
Error occured only if this all 3 conditions is given.
- Querystats enabled
- LEFT JOIN instead INNER JOIN
- LOWER() function in the ON Condition.
So if only querystats is disabled, it works.
If only LEFT JOIN is replaced with INNER JOIN, it works.
If only LOWER() funcions in the ON Condition will be removed, it works.