dynamobi/dynamobi — Issue #183: [LDB-138] filtering returns incorrect count using 1M row table
Author: dynamobi-build
Created: 2011-12-30 02:19:33+00:00
State: open
Labels: LDB

[reporter="schoi", created="Tue, 12 Sep 2006 12:36:15 -0500 (GMT-05:00)"]
To repro:

--------------

/open/luciddb/test/sql/sqbm$ ant test -Dbh.test-names=sqbm.sqbm2b

It takes approx 4.5 minutes to run (load and multiple select count(*) from a 1 million row table)

Fails at this query:

select count(*) from bench1m where k2 = 2 and not (K1K = 3);

-- returns:

+---------+

| EXPR$0 |

+---------+

| 499897 |

+---------+

-- expecting

+---------+

| EXPR$0 |

+---------+

| 499901 |

+---------+

Note that I just updated the ref file .. the correct return should be 499901. (checked against excel) Before, when this test was "passing", it was returning 499900.