Union All in subquery causes failure

GridSQL -> create table t1 (col1 int, col2 int) replicated;
OK
Response time: 0m 0s 35ms Total time: 0m 0s 35ms

GridSQL -> create table t2 (id int) replicated;
OK

GridSQL -> select * from (select col1 from t1 union all select col2 from t1) as x where x.col1 not in (select id from t2);
SQLException: ERROR: Can not prepare request: Table x has not been found in database mydb

Same query works when executed directly on all nodes.

Hi Don,
This looks like a bug. We are looking into this and will post an update soon.

--
Atul

Hi Don,
A patch has been committed in the CVS that resolves this issue.

Thanks,
Atul