dynamobi/dynamobi — Issue #271: [LDB-50] Tests with some select statements fail running with optimized build
Author: dynamobi-build
Created: 2011-12-30 02:25:58+00:00
State: open
Labels: LDB

[reporter="elin", created="Fri, 24 Mar 2006 12:42:24 -0500 (GMT-05:00)"]
Certain select statements incorrectly return 0 rows when run with an optimized build.

To reproduce:

Run initBuild.sh --with-fennel --with-optimization under open/luciddb to build.

Under open/luciddb/test/sql/sqbm do ant test. Tests which fail will have log files under open/luciddb/test/sql/sqbm/gen. Or you can run the tests under open/luciddb/test/sql/company in the same way.

To reproduce just one of the failing select statement, load the bench1m data into a table and

execute the following statement:

select COUNT(*) from BENCH1M

where

(Kseq between 40000 and 41000

OR Kseq between 42000 and 43000

OR Kseq between 44000 and 45000

OR Kseq between 46000 and 47000

OR Kseq between 48000 and 50000)

AND K10K = 3;

More details to come