Hi Everyone,



Me again, sorry to be a pest...I'm having a great week at the Office.



Try this on Ingres2006R2 or better...



1. createdb bowtest

2. sql bowtest < setup.sql

3. sql bowtest << SQL_END

\r

-- Lets see whats in the view, there should be 11 rows.

select a, b from fleabane_view;

\p\g

-- now populate the table, this should simply add the sequence counter
to

-- each row selected from the view.

insert into test_this(a,b)

select a, b from fleabane_view;

\p\g

-- Trouble is that it doesn't.

-- It seems to have repeated one of the qualifying rows from
fleabane_view

-- ad nauseum rather than use each row in the view.

-- It also got the wrong number of rows. (10 not 11)

select * from test_this;

\p\g

\q

SQL_END



Martin Bowes