You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In 3.0 we can create big PSQL-code, but can't call 'execute statement' with big code contained in blob
---
execute block
returns (SQL blob sub_type text)
as
begin
select 'create or alter procedure test_proc returns(id integer) as begin '||
list('SUSPEND;', '
')||'
end' from rdb$types, rdb$types
rows 35000
into :SQL;
execute statement :SQL;
suspend;
end
------------------
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
blob truncation when converting to a string: length limit exceeded.
Memory consumption of procedural objects under 64-bit environment is much bigger than on 32-bit one.
This test was retyped because it was encountered that previous limit for the size of BLR is too weak:
test failed at runtime with error "implementation limit exceeds".
New (more rigorous) limit was found by using 64-bit FB, build LI-T3.0.0.31822: BLR can not be larger
than ~2.35 Mb (previous: ~3.21 Mb)
Discussion with dimitr: letter 05-may-2015 12:27, "Расхождения в результатах прогонов по сравнению с данными от 08-апр-2015 build #31780"
The text was updated successfully, but these errors were encountered:
Test Details: Memory consumption of procedural objects under 64-bit environment is much bigger than on 32-bit one.
This test was retyped because it was encountered that previous limit for the size of BLR is too weak:
test failed at runtime with error "implementation limit exceeds".
New (more rigorous) limit was found by using 64-bit FB, build LI-T3.0.0.31822: BLR can not be larger
than ~2.35 Mb (previous: ~3.21 Mb)
Discussion with dimitr: letter 05-may-2015 12:27, "Расхождения в результатах прогонов по сравнению с данными от 08-апр-2015 build #31780"
Submitted by: Alex Bekhtin (afgm)
In 3.0 we can create big PSQL-code, but can't call 'execute statement' with big code contained in blob
---
execute block
returns (SQL blob sub_type text)
as
begin
select 'create or alter procedure test_proc returns(id integer) as begin '||
list('SUSPEND;', '
')||'
end' from rdb$types, rdb$types
rows 35000
into :SQL;
execute statement :SQL;
suspend;
end
------------------
Arithmetic overflow or division by zero has occurred.
arithmetic exception, numeric overflow, or string truncation.
blob truncation when converting to a string: length limit exceeded.
Commits: 2d330eb FirebirdSQL/fbt-repository@eadaed1
====== Test Details ======
Memory consumption of procedural objects under 64-bit environment is much bigger than on 32-bit one.
This test was retyped because it was encountered that previous limit for the size of BLR is too weak:
test failed at runtime with error "implementation limit exceeds".
New (more rigorous) limit was found by using 64-bit FB, build LI-T3.0.0.31822: BLR can not be larger
than ~2.35 Mb (previous: ~3.21 Mb)
Discussion with dimitr: letter 05-may-2015 12:27, "Расхождения в результатах прогонов по сравнению с данными от 08-апр-2015 build #31780"
The text was updated successfully, but these errors were encountered: