Optimized hybrid hash join is broken (TPC-H q2 and q17)

[GoogleCodeExporter]

Running the attached query (a fixed version of TPC-H Q2) on a TPC-H SF1 
database fails with a ArrayIndexOutOfBoundsException or gives wrong results.
If we change the join implementation to the old hybrid hash join, we get the 
correct result.

Original issue reported on code.google.com by westm...@gmail.com on 6 Jul 2013 at 1:24

Attachments:

• q2_minimum_cost_supplier.3.query.aql

[GoogleCodeExporter]

This partial query produced ArrayIndexOutOfBoundsException when running with a 
single NC against the SF1 database.

Original comment by westm...@gmail.com on 6 Jul 2013 at 5:45

Attachments:

• q2-part.aql

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

[deleted comment]

[GoogleCodeExporter]

q17,  which was having issues before, now appear to work after turning off 
optimized hash join.

Original comment by cmcintyr...@gmail.com on 8 Jul 2013 at 8:58

Attachments:

• q17.aql.txt

[GoogleCodeExporter]

Original comment by westm...@gmail.com on 27 Jul 2013 at 12:05

• Changed title: Optimized hybrid hash join is broken (TPC-H q2 and q17)

[GoogleCodeExporter]

Should be fixed - needs validation.

Original comment by westm...@gmail.com on 5 Aug 2013 at 5:07

[GoogleCodeExporter]

Original comment by westm...@gmail.com on 9 Aug 2013 at 6:04

• Changed state: Verified