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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Assignee | David Hall [ david.hall ] |
| Rank | Ranked higher |
| Rank | Ranked lower |
| Fix Version/s | Icebox [ 22302 ] |
| Rank | Ranked lower |
| Fix Version/s | 23.02 [ 28209 ] | |
| Fix Version/s | Icebox [ 22302 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Status | In Progress [ 3 ] | In Testing [ 10301 ] |
| Fix Version/s | 6.4.6 [ 28452 ] | |
| Fix Version/s | 23.02 [ 28209 ] | |
| Assignee | David Hall [ david.hall ] | Denis Khalikov [ JIRAUSER48434 ] |
| Description |
To reproduce: {code:java} 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); {code} {code:java} 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 {code} 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. |
To reproduce:
{code:java} 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); {code} {code:java} 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 {code} 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. |
| Assigned for Testing | Daniel Lee [ dleeyh ] |
| Fix Version/s | 23.02 [ 28209 ] | |
| Fix Version/s | 6.4.6 [ 28452 ] |
| Rank | Ranked higher |
| Rank | Ranked higher |
| Resolution | Fixed [ 1 ] | |
| Status | In Testing [ 10301 ] | Closed [ 6 ] |
| Fix Version/s | 22.08.8 [ 28550 ] | |
| Fix Version/s | 23.02 [ 28209 ] |
| Zendesk Related Tickets | 134810 |