http://forums.enterprisedb.com/posts/list/7.page JForum - http://www.jforum.net 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.]]> http://forums.enterprisedb.com/posts/preList/1542/5398.page http://forums.enterprisedb.com/posts/preList/1542/5398.page GMT This looks like a bug. We are looking into this and will post an update soon.

--
Atul]]> http://forums.enterprisedb.com/posts/preList/1542/5401.page http://forums.enterprisedb.com/posts/preList/1542/5401.page GMT A patch has been committed in the CVS that resolves this issue.

Thanks,
Atul]]> http://forums.enterprisedb.com/posts/preList/1542/5420.page http://forums.enterprisedb.com/posts/preList/1542/5420.page GMT