Hi All,

I have a distributed database which has a native view (named all_box_store)which is a select with many union all's of several registered tables.

If I run the query...
select * from c_slot_allocation a
where a.box_cid not in (
select s.box_cid
from all_box_store s
where a.project_cid = s.project_cid
and a.rack_cid = s.rack_cid
and a.slot_position = s.slot_position
);
Then I get errors:
E_US100F String cannot be converted to numeric due to incorrect syntax.
E_RQ0042 Preceding message is from LDB=ldbc, NODE=brat.ctsu.ox.ac.uk, DBMS=INGRES
E_QE0514 An (LDB) query error or warning occurred.

But if I instantiate the view as a table: create table x as select * from all_box_store
And then alter the above query to use the instantiated table it works perfectly well.

This is Ingres10.0.0 (a64.lnx/132)NPTL + 13957

Anyone got any ideas aboutr this?

Martin Bowes