[MCOL-5412] Scalar vectoring code does not always work (certain where clause values combo) Created: 2023-02-02  Updated: 2023-12-15

Status: Stalled
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: None
Fix Version/s: 23.10

Type: Bug Priority: Critical
Reporter: Sergey Zefirov Assignee: Sergey Zefirov
Resolution: Unresolved Votes: 0
Labels: None


 Description   

use test;
drop table if exists t;
create table t(c6 CHAR(6)) engine=columnstore;
insert into t(c6) values ('a'), ('b'), ('c');
select count(*) from t where (c6 <= 'b' or c6 is null);

The query returns 3 instead of 2.

internal note
We have two code paths for filtering: scalar and vectorized. Vectorized one is preferred and scalar one is used as fallback.

The following little snippet works differently when executed with vectorized code enabled and disabled:



 Comments   
Comment by JiraAutomate [ 2023-12-15 ]

Automated message:
----------------------------
Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

Generated at Thu Feb 08 02:57:41 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.