[DRILL-7010] Wrong result is returned if filtering by a decimal column using old parquet data with old metadata file.

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 1.15.0
• Assignee: Unassigned
• Reporter: Anton Gozhiy
• Created: 28/Jan/19 13:45
• Updated: 28/Jan/19 14:19
• Resolved: 28/Jan/19 14:19

Description

Prerequisites:

• The data was generated by Drill 1.14.0-SNAPSHOT (commit 4c4953bcab4886be14fc9b7f95a77caa86a7629f). See attachment.
• set store.parquet.reader.strings_signed_min_max = "true"

Query #1:

select *
from dfs.tmp.`supplier_old`
where not s_acctbal > -900

Expected result:

65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea
22	Supplier#000000022	okiiQFk 8lm6EVX6Q0,bEcO	4	14-144-830-2814	-966.20	 ironically among the deposits. closely expre
22	Supplier#000000022	okiiQFk 8lm6EVX6Q0,bEcO	4	14-144-830-2814	-966.20	 ironically among the deposits. closely expre
22	Supplier#000000022	okiiQFk 8lm6EVX6Q0,bEcO	4	14-144-830-2814	-966.20	 ironically among the deposits. closely expre

Actual result:

65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea
65	Supplier#000000065	BsAnHUmSFArppKrM	22	32-444-835-2434	-963.79	l ideas wake carefully around the regular packages. furiously ruthless pinto bea

Query #2

select ps_availqty, ps_supplycost, ps_comment
from dfs.tmp.`partsupp_old`
where ps_supplycost > 999.9

Expected result:

5136	999.92	lets grow carefully. slyly silent ideas about the foxes nag blithely ironi
8324	999.93	ly final instructions. closely final deposits nag furiously alongside of the furiously dogged theodolites. blithely unusual theodolites are furi
5070	999.99	 ironic, special deposits. carefully final deposits haggle fluffily. furiously final foxes use furiously furiously ironic accounts. package
6915	999.95	fluffily unusual packages doubt even, regular requests. ironic requests detect carefully blithely silen
1761	999.95	lyly about the permanently ironic instructions. carefully ironic pinto beans
2120	999.97	ts haggle blithely about the pending, regular ideas! e
1615	999.92	riously ironic foxes detect fluffily across the regular packages

Actual result:
No data is returned.