Hi All,

This one was a complete surprise....

Using a vnode to go from an Ingres9 installation to an ingres 10 installation.

The Ingres 10 database has a few procedures loaded, and on the Ingres9 siteI run a query which downloads some information about them.

When a sufficient number of procedures is loaded the following query will stall and needs to be killed...brutaly.

declare global temporary table session.x as
select procedure_name, procedure_owner, text_sequence, text_segment
from iiprocedures
on commit preserve rows with norecovery;
copy session.x(
procedure_name = c0tab,
procedure_owner = c0tab,
text_sequence = c0tab,
text_segment = c0tab,
nl=d1
) into '/tmp/fred';
rollback;

The session does create the file...it just won't come back to tell me that.

But bizarrly, If I alter the query to include a junk command between the two prior commands It works...
declare global temporary table session.x as
select procedure_name, procedure_owner, text_sequence, text_segment
from iiprocedures
on commit preserve rows with norecovery;
help session.x; -- pure junk, but it makes the copy return, select 1 won't do that!
copy session.x(
procedure_name = c0tab,
procedure_owner = c0tab,
text_sequence = c0tab,
text_segment = c0tab,
nl=d1
) into '/tmp/fred';
rollback;
Executing . . .

(65 rows)
No tables were found that matched 'session.x'


(65 rows)

The query now completes.

Anyone got any idea what the hell is going on?

Martin Bowes