Issue Details (XML | Word | Printable)

Key: CORE-4375
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Alex Bekhtin
Votes: 0
Watchers: 2
Operations

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

Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block

Created: 26/Mar/14 10:12 AM   Updated: 22/Sep/15 09:41 AM
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 successfully
Test Details:
On Alpha2 (WI-T3.0.0.30809):
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Invalid command
-no column name specified for column number 1 in derived table ...
On Beta2 (WI-T3.0.0.31807) works OK.


 Description  « Hide
-- STEP 1
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
-------
--STEP 2
manually run code from blob
-------
-- STEP 3
-- indefinitely wait for
select count(*) from test_proc


But it works for smaller code



 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov made changes - 26/Mar/14 04:30 PM
Field Original Value New Value
Assignee Dmitry Yemanov [ dimitr ]
Dmitry Yemanov made changes - 26/Mar/14 04:40 PM
Summary indefinitely wait when calling big psql procedure Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
Dmitry Yemanov made changes - 26/Mar/14 04:40 PM
Status Open [ 1 ] Resolved [ 5 ]
Fix Version/s 3.0 Beta 1 [ 10332 ]
Resolution Fixed [ 1 ]
Pavel Zotov made changes - 28/May/15 02:52 PM
Status Resolved [ 5 ] Resolved [ 5 ]
Test Details On Alpha2 (WI-T3.0.0.30809):
Statement failed, SQLSTATE = 42000
Dynamic SQL Error
-SQL error code = -104
-Invalid command
-no column name specified for column number 1 in derived table ...
On Beta2 (WI-T3.0.0.31807) works OK.
QA Status Done successfully
Pavel Cisar made changes - 22/Sep/15 09:41 AM
Status Resolved [ 5 ] Closed [ 6 ]