Submitted by: Ralf Steinhaeusser (ralfiii)

Duplicates CORE3211

Run the following script on a database, then try to view the view-data.
You'll get an error
"Arithmetic overflow or division by zero has occurred. arithmetic exception, numeric overflow, or string truncation. string right truncation."

The view works well with firebird 2.1.3

#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠#⁠

CREATE TABLE TEST (
ID INTEGER,
MYNAME VARCHAR(10));

insert into test (ID, MyName) Values(0, 'foo');
insert into test (ID, MyName) Values(1, 'foo');
insert into test (ID, MyName) Values(1, 'test');

create view TestView(ID, MyName)
as
select * from Test where Id=0
union all
Select * From Test where Id=1
and MYNAME not in
(Select MYNAME from Test where Id=0);

====== Test Details ======

See test for core-3211 (query is almost the same).