[ASTERIXDB-3499] Missing updation of filters for Boolean columns while merging

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.9
• Fix Version/s: 0.9.10
• Component/s: STO - Storage
• Labels: triaged
• Epic Link: Columnar Format
• Assignee: Unassigned
• Reporter: Ritik Raj
• Created: 05/Sep/24 14:35
• Updated: 22/Sep/24 16:53
• Resolved: 22/Sep/24 16:53

Description

While merging/compaction the filters of the boolean columns were not getting updated causing the rangeFilter to skip whole mega page, hence giving empty results.

Sample case:

 

CREATE collection sample_collection PRIMARY KEY (primary_key_id: string) 
WITH { 
    "storage-format": {
        "format": "column"
     }
};

insert into sample_collection ([{'primary_key_id': '1', 'int_field1': 69114320, 'decimal_field1': 9610, 'datetime_field1': '2005-11-08 00:00:00', 'bool_field1': False, 'varchar_field1': 'BPBlasoTZq', 'char_field1': 'C'}]);

insert into sample_collection ([{'primary_key_id': '189', 'int_field1': 89463144, 'decimal_field1': 3490, 'datetime_field1': '2012-12-19 00:00:00', 'bool_field1': False, 'varchar_field1': 'nfQdaGVYjH', 'char_field1': 'C'}]);

compact collection sample_collection;

select int_field1 from sample_collection where bool_field1 = false;