[MCOL-4682] Filter predicate parsing error: BETWEEN (CASE) causes assertion Created: 2021-04-17  Updated: 2022-01-01

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.4.3
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Juan Assignee: Unassigned
Resolution: Unresolved Votes: 2
Labels: None
Environment:

RHEL



 Description   

Query runs for a few seconds & then crashes:

SELECT A.AN_ID
   FROM DB.TABLE_A A
  WHERE A.ATTR_1 = '01'
    AND A.ATTR_DT BETWEEN (CASE WHEN 1 = 1 THEN STR_TO_DATE('1/1/2000', '%m/%d/%Y') ELSE STR_TO_DATE('1/1/2000', '%m/%d/%Y') END)
        AND STR_TO_DATE('12/31/2000', '%m/%d/%Y')

 Apr  5 13:14:54 repc01dbq Calpont[8760]: 54.372740 |0|0|0| E 00 CAL0000: /home/jenkins/workspace/10.5e-RPM-DEV/label/rhel-7/padding_for_CPACK_RPM_BUILD_SOURCE_DIRS_PREFIX_ON_ES_BACKUP_DEBUGSOURCE/storage/columnstore/columnstore/dbcon/mysql/ha_mcs_execplan.cpp@1687: assertion 'gwip->rcWorkStack.size() >= 3' failed
Apr  5 13:14:54 repc01dbq abrt-hook-ccpp: Process 8760 (mariadbd) of user 498 killed by SIGABRT - dumping core
Apr  5 13:14:55 repc01dbq abrt-hook-ccpp: Failed to create core_backtrace: waitpid failed: No child processes


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