dynamobi/dynamobi — Issue #662: [FRG-210] Fennel calc returns wrong result when filter contains CURRENT_TIMESTAMP comparison and an IS NULL predicate
Author: dynamobi-build
Created: 2011-12-30 03:41:54+00:00
State: open
Labels: Fennel Calc Codegen, FRG

[reporter="zfong", created="Wed, 20 Sep 2006 09:39:15 -0500 (GMT-05:00)"]
Here's the repro against a Farrago personality:

alter system set "calcVirtualMachine" = 'CALCVM_FENNEL';

create table t(k int primary key, a bigint, b timestamp);

insert into t values(1, null, current_timestamp);

select * from t where a is null or b <> current_timestamp;

The select should return one row. It returns none. If you switch to Java calc, the row is returned.