Inserting into an uncommitted temporary table corrupts the database
-------------------------------------------------------------------
Key: CORE-3574
URL: http://tracker.firebirdsql.org/browse/CORE-3574
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2.5.0
Environment: Tested on Linux server, Windows 7 client
Reporter: Jonathan Neve
The following SQL corrupts the database :
create global temporary table tmp_test (code integer) on commit delete rows;
create procedure pr_test
as
begin
insert into tmp_test (code) values (0);
end;
execute procedure pr_test;
commit;
If the temporary table is committed before creating the procedure, it works
correctly. Trying to insert into the uncommitted temporary table outside the
context of a stored procedure correctly results in an error message (saying
that the table does not exist). But inserting into the temporary table from a
stored procedure is accepted (no error message) but results in a corrupted
database!
--
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
------------------------------------------------------------------------------
uberSVN's rich system and user administration capabilities and model
configuration take the hassle out of deploying and managing Subversion and
the tools developers use with it. Learn more about uberSVN and get a free
download at: http://p.sf.net/sfu/wandisco-dev2dev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
