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
-- 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
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.
The text was updated successfully, but these errors were encountered:
summary: indefinitely wait when calling big psql procedure => Procedure executes infinitely if contains more than 32767 statements inside any BEGIN/END block
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.
Submitted by: Alex Bekhtin (afgm)
-- 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
Commits: d279f3a FirebirdSQL/fbt-repository@0c87dd8
====== 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.
The text was updated successfully, but these errors were encountered: