Regression: FB crashes when trying to recreate table that is in use by DML
(3.0.3; 3.0.4; 4.0.0)
------------------------------------------------------------------------------------------------
Key: CORE-5756
URL: http://tracker.firebirdsql.org/browse/CORE-5756
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 4.0 Alpha 1
Reporter: Pavel Zotov
Attachments: gdb-crash-when-tried-to-recreate-table-that-was-in-use.7z
Try to run following script:
===
shell rm -f /var/tmp/tmptest.fdb;
create database 'localhost:/var/tmp/tmptest.fdb' user 'SYSDBA'password
'masterkey';
set list on;
set echo on;
recreate table test(x int);
select 1 from test;
recreate table test(x int, y int);
===
Output will be:
-------------------
Statement failed, SQLSTATE = 08006
Error reading data from the connection.
After line 8 in file /opt/scripts/recreate-used-table.sql
Statement failed, SQLSTATE = 08006
Error writing data to the connection.
------------------
I can reproduce this on 3.0.3.32875, 3.0.4.32819 and 4.0.0.853.
Stack traces for 3.0.3 and 3.0.4 seems to be equal, but i attach them both.
2.5.x is not afttected and raised expected error:
===
Statement failed, SQLSTATE = 42000
unsuccessful metadata update
-object TABLE "TEST" is in use
===
--
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
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
