[ASTERIXDB-3276] Columnar filter can stuck in infinite loop when accessing non-existing columns

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.9
• Fix Version/s: 0.9.9
• Component/s: RT - Runtime
• Labels: triaged
• Epic Link: Columnar Format
• Assignee: Wail Y. Alkowaileet
• Reporter: Wail Y. Alkowaileet
• Created: 06/Oct/23 21:26
• Updated: 13/Oct/23 21:30
• Resolved: 13/Oct/23 21:30

Description

USE CopyToDataverse;

SELECT VALUE cd.sensor_info
FROM ColumnDataset cd
WHERE cd.noSuchValue LIKE "%someText"

This query get stuck in infinite loop as the MISSING value reader never advances to the next value – making the number of tuple = infinity.