indefinitely wait when calling big psql procedure
-------------------------------------------------
Key: CORE-4375
URL: http://tracker.firebirdsql.org/browse/CORE-4375
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 Alpha 2
Environment: Firebird-3.0.0.30988-0_x64
Reporter: Alex Bekhtin
-- 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
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Learn Graph Databases - Download FREE O'Reilly Book
"Graph Databases" is the definitive new guide to graph databases and their
applications. Written by three acclaimed leaders in the field,
this first edition is now available. Download your free book today!
http://p.sf.net/sfu/13534_NeoTech
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
