Views will report an error, "Data Type Unknown" if you combine
multiple statements and do some math on one of the columns.

See the example below.

create table test1 (id varchar(10), qty integer);
create table test2 (id varchar(10), qty integer);

commit;

insert into test1 (id, qty) VALUES('1', 20);
insert into test2 (id, qty) VALUES('1', 30);

commit;

create view v_test
as
SELECT id, qty FROM test1
UNION ALL
SELECT id, qty * -1 FROM test2; <--causes error

commit;


Invalid token.Dynamic SQL Error.
SQL error code = -104.
Invalid command.
Data type unknown.


If this is a bug, how would it get placed in the Firebird bug list?

Someone else can post it to the bug list f they want.

Version 1.5.2 SuperServer, WindowsXP