Hi,
I get an error with the following statement on 7.5.01.00 (in SqlStudio):
insert into table1 (col1, col2)
select 1,2 from dual
where not exists (select 1 from table where col1=1)
The error is:
General error;-602 POS(1) System error: Move error.
or
System error: KB Stack type illegal.
depending on the table used.
If I change the query in:
insert into table1 (col1, col2)
select 1,2 from dual
where (select count(*) from table where col1=1)=0
Everything works fine.
It seems that "not exist" statement doesn't work.
There's something more: if you remove the "not" from the first query, it works (but
obviously is not what I need).
Thanks in advance
Fabio Pinotti
