Subject | Re: [ib-support] Re: Database grows rapidly (3 to 770MB) when using BLOB views/UDFs |
---|---|
Author | Ivan Prenosil |
Post date | 2002-03-22T10:47:20Z |
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
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