Link: This issue relate to CORE3953 [ CORE3953 ]

Link: This issue relate to CORE3951 [ CORE3951 ]

Attachment: blob_case_sp.sql [ 12322 ]

description: Do the folllowing:

1. Create a database. Product of this step we obtain a database of 2464 KB.

2. Create the next SP:

CREATE PROCEDURE "BLOB_Case_SP"

AS

DECLARE VARIABLE i INTEGER;
DECLARE VARIABLE fmemo BLOB SUB_TYPE TEXT SEGMENT SIZE 80;

BEGIN

fmemo = '';

i = 1;
WHILE (i < 1280) DO BEGIN

fmemo = fmemo \|\| '1\*2\*3\*4\*5\*6\*7\*8\*';

i = i \+ 1;

END

END

// Obs. We use a blob type variable, sub_type text. Then we built a string using successive concatenations (eg. 1280) always adding a string of length 16.

3. Execute the SP:

EXECUTE BLOB_CASE_SP;

Results:

We obtain the next error message: "unknow ISC error 0." and the database size increased to 11472 KB.

Now, if we replace in the SP the line:

fmemo = fmemo \|\| '1\*2\*3\*4\*5\*6\*7\*8\*';

by this lines:

fmemo = fmemo \|\| '1\*';
fmemo = fmemo \|\| '2\*';
fmemo = fmemo \|\| '3\*';
fmemo = fmemo \|\| '4\*';
fmemo = fmemo \|\| '5\*';
fmemo = fmemo \|\| '6\*';
fmemo = fmemo \|\| '7\*';
fmemo = fmemo \|\| '8\*';

and we do it all from scratch, we obtain the same error message and a database file of 74384 KB!

=>

Do the folllowing:

1. Create a database. Product of this step we obtain a database of 2464 KB.

2. Create the next SP:

CREATE PROCEDURE "BLOB_Case_SP"

AS

DECLARE VARIABLE i INTEGER;
DECLARE VARIABLE fmemo BLOB SUB_TYPE TEXT SEGMENT SIZE 80;

BEGIN

fmemo = '';

i = 1;
WHILE (i < 1280) DO BEGIN

fmemo = fmemo \|\| '1\*2\*3\*4\*5\*6\*7\*8\*';

i = i \+ 1;

END

END

// Obs. We use a blob type variable, sub_type text. Then we built a string using successive concatenations (eg. 1280) always adding a string of length 16.

3. Execute the SP:

EXECUTE "BLOB_Case_SP";

Results:

We obtain the next error message: "unknow ISC error 0." and the database size increased to 11472 KB.

Now, if we replace in the SP the line:

fmemo = fmemo \|\| '1\*2\*3\*4\*5\*6\*7\*8\*';

by this lines:

fmemo = fmemo \|\| '1\*';
fmemo = fmemo \|\| '2\*';
fmemo = fmemo \|\| '3\*';
fmemo = fmemo \|\| '4\*';
fmemo = fmemo \|\| '5\*';
fmemo = fmemo \|\| '6\*';
fmemo = fmemo \|\| '7\*';
fmemo = fmemo \|\| '8\*';

and we do it all from scratch, we obtain the same error message and a database file of 74384 KB!

environment: Windows XP SP3/Vista/7/8 32 | 64 bits, Firebird 2.1.518497, IBExpert 20130220 => Windows XP SP3/Vista/7/8 32 | 64 bits, Firebird 2.1.5.18497, IBExpert 20130220

Link: This issue duplicates CORE3951 [ CORE3951 ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

status: Resolved [ 5 ] => Closed [ 6 ]

QA Status: No test