RE: [Firebird-devel] Blob sharing bug

[Claudio V. C. <cv...@us...>]

> -----Original Message-----
> From: fir...@li...
> [mailto:fir...@li...]On Behalf Of Claudio
> Valderrama C.
> Sent: Domingo 24 de Junio de 2001 0:35

Hello, this was before:

> SQL> set blob off;
> SQL> select * from tprenosil;
>
>            I                 B
> ============ =================
>            1              8b:0
>
> SQL> debug 99;
> Statement failed, SQLCODE = -501
>
> invalid request handle
> SQL> EXECUTE PROCEDURE pprenosil 1;
> SQL> EXECUTE PROCEDURE pprenosil 101;
> SQL> EXECUTE PROCEDURE pprenosil 101;
> SQL> select * from tprenosil;
>
>            I                 B
> ============ =================
>            1              8b:0
>          101              8b:2
>          201              8b:2
>          201              8b:2
>
> SQL>

After the two modifications suggested by Ann:

H:\ibdev\fbbuild\interbase>isql c:/proy/fbtest.gdb
Database:  c:/proy/fbtest.gdb
SQL> execute procedure pprenosil 1;
SQL> execute procedure pprenosil 101;
SQL> execute procedure pprenosil 101;
SQL> set blob off;
SQL> select * from tprenosil;

           I                 B
============ =================

         101              8b:1
         201              8b:3
         201              8b:5
           1             8b:42

SQL> ^Z

[Will flattery take you anywhere?] Oh, Mom, you're wonderful, the blob bug
has been squashed after I simply did a copy/paste of your code.

This is going to lower revenues at IBPhoenix, but...
:-)

We will have to check if Ivan's second bug report (varchar not being
cleared) has been solved, too.

C.