search

br1ghtyang / asterixdb

Automatically exported from code.google.com/p/asterixdb
0 stars 0 forks source link

TPC-H q14 Incorrect Result #559

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
To reproduce the issue, run the tpch q14 in the web interface on SF=1 with 3 
nodes, the default configuration, and one IO device.

The result returned for q14 is 0.0d, although it is supposed to be 16.38d.  
Thanks in advance for the help.

Original issue reported on code.google.com by cmcintyr...@gmail.com on 9 Jul 2013 at 12:09

GoogleCodeExporter commented 8 years ago

Original comment by westm...@gmail.com on 19 Jul 2013 at 4:36

GoogleCodeExporter commented 8 years ago 
I tried removing the switch statement in this query and it now gets the result 
"2.7619493282270624E11d".  The modified query is attached as q14_mod_1.aql.  
Changing true to false and false to true in the original query still yields the 
result "0.0d".  This modification is attached as q41_mod_2.aql.

Original comment by cmcintyr...@gmail.com on 27 Jul 2013 at 12:41

Attachments:

GoogleCodeExporter commented 8 years ago 
[deleted comment]
GoogleCodeExporter commented 8 years ago 
The modified queries were ran under the same conditions as the original.

Original comment by cmcintyr...@gmail.com on 27 Jul 2013 at 1:01

GoogleCodeExporter commented 8 years ago 
Here are the optimized logical plans for q14, q14_mod_1, and q14_mod_2.

Original comment by cmcintyr...@gmail.com on 29 Jul 2013 at 6:40

Attachments:

GoogleCodeExporter commented 8 years ago 
Here is a working version of q14.

Original comment by cmcintyr...@gmail.com on 31 Jul 2013 at 6:15

Attachments:

GoogleCodeExporter commented 8 years ago 
fixed in rev 834371c29cc8

Original comment by westm...@gmail.com on 31 Jul 2013 at 9:40