Issue Details (XML | Word | Printable)

Key: CORE-4374
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Alex Bekhtin
Votes: 0
Watchers: 3
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Truncation error when using EXECUTE STATEMENT with a blob

Created: 26/Mar/14 10:04 AM   Updated: 28/Sep/15 12:57 PM
Component/s: Engine
Affects Version/s: 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

Environment: Firebird-3.0.0.30988-0_x64

QA Status: Done with caveats
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"


 Description  « Hide
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.

 All   Comments   Change History   Subversion Commits      Sort Order: Descending order - Click to sort in ascending order
There are no comments yet on this issue.