Attachment: gdb-crash-when-tried-to-recreate-table-that-was-in-use.7z [ 13211 ]

description: 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

=>

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

PS. Used config:

BugCheckAbort=1
RemoteServicePort = 3333
IpcName = fb30ss

Providers = Remote,Engine12,Loopback
#⁠Providers = Remote,Loopback
#⁠Providers = Engine12

AuthServer = Srp, Win_Sspi, Legacy_Auth
AuthClient = Srp, Win_Sspi, Legacy_Auth
UserManager = Srp,Legacy_UserManager
WireCrypt = Enabled
#⁠WireCompression = false

assignee: Dmitry Yemanov [ dimitr ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 4.0 Beta 1 [ 10750 ]

Fix Version: 3.0.4 [ 10863 ]

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: No test => Done successfully

status: Resolved [ 5 ] => Closed [ 6 ]