dynamobi/dynamobi — Issue #787: [FRG-83] Need scoping of dynamic parameters
Author: dynamobi-build
Created: 2011-12-30 03:48:52+00:00
State: closed
Labels: FRG, Statement Processing

[reporter="zfong", created="Mon, 20 Mar 2006 18:03:28 -0500 (GMT-05:00)"]
Currently, dynamic parameters are created during rule processing. This causes problems if a subtree that uses dynamic parameters is duplicated elsewhere in a statement. The following illustrates the problem:

create table t(a int, b int, c int) server sys_column_store_data_server;

create index ita on t(a);

create index itb on t(b);

create view v as select * from t where a = 1 and b = 2;

select * from v v1, v v2;

The select will result in an assert in Fennel when trying to create the same dynamic parameter id a second time.