Subject Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs
Author Ivan Prenosil
What I also do not understand is that I _can_ read temporary blob

a) by using it in SP, e.g.
CREATE PROCEDURE P RETURNS (B BLOB) AS BEGIN B=MyUDF(1); SUSPEND; END

b) by using it in View, e.g.
CREATE VIEW V (A,B) AS
SELECT X, MyUDF(X) FROM T;

but I _can't_ read it directly, like

c) SELECT X, MyUDF(X) FROM T;

What is the difference between selecting temporary blob from table
and from view ? Is it as designed or is it a bug ?

Ivan
http://www.volny.cz/iprenosil/interbase