[
https://issues.apache.org/jira/browse/ASTERIXDB-3499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ian Maxon updated ASTERIXDB-3499:
---------------------------------
Labels: triaged (was: )
> Missing updation of filters for Boolean columns while merging
> -------------------------------------------------------------
>
> Key: ASTERIXDB-3499
> URL: https://issues.apache.org/jira/browse/ASTERIXDB-3499
> Project: Apache AsterixDB
> Issue Type: Bug
> Components: STO - Storage
> Affects Versions: 0.9.9
> Reporter: Ritik Raj
> Priority: Major
> Labels: triaged
> Fix For: 0.9.10
>
>
> 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:
>
> {code:java}
> CREATE collection sample_collection PRIMARY KEY (primary_key_id: string)
> WITH {
> "storage-format": {
> "format": "column"
> }
> };{code}
> {code:java}
> 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'}]);
> {code}
> {code:java}
> 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'}]);{code}
> {code:java}
> compact collection sample_collection;
> {code}
> {code:java}
> select int_field1 from sample_collection where bool_field1 = false;
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
