Submitted by: hschlup (hschlup)

Assigned to: @ArnoBrinkman

SFID: 660298#⁠
Submitted By: hschlup

To resolve my problem with Unions in Sub-Query I tried
following. I created a view:

CREATE VIEW V_Call_User
(ID, User_ID)
AS
SELECT id,owner_id FROM call
UNION
SELECT id,responsible_id FROM call
UNION
SELECT id,supervisor_id FROM call
UNION
SELECT call_id,responsible_id FROM call_task

That gives me a simple list...

A simple select to this list works fine. But when I
execute the following SQL:

SELECT * FROM V_CALL WHERE id IN
( SELECT id FROM V_CALL_USER
WHERE user_id = '1')

I get a AV and even the Server shut's down and i have to
restart the server
service.

This bug was confirmed by Arno Brinkman in the
newsgroup: borland.public.interbase.general

Yes, it's a BUG !

I can reproduce it !

Have you tried and Stored Procedure instead ? Maybe
you can workaround wit
an SP.

Regards,
Arno Brinkman