|
If you were logged in you would be able to see more operations.
|
|
|
|
Environment:
|
Windows XP, Firebird-2.5.0.26084-0_Win32 shapshot
|
|
| Planning Status: |
Unspecified
|
|
Steps to reproduce
1.Create test base and ordinary user in isql
CREATE DATABASE "localhost:lab" USER "SYSDBA" PASSWORD "masterkey" PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1251;
CREATE USER TEST2 PASSWORD 'TEST2';
EXIT;
2. Succesfully change MON$ATTACHMENTS structure under TEST2
CONNECT "localhost:lab" USER "TEST2" PASSWORD "TEST2";
ALTER TABLE MON$ATTACHMENTS DROP MON$SERVER_PID;
EXIT;
Then SELECT * FROM MON$ATTACHMENTS from any connection returns
Statement failed, SQLSTATE = XX000
internal error
--
BR, Eugene
|
|
Description
|
Steps to reproduce
1.Create test base and ordinary user in isql
CREATE DATABASE "localhost:lab" USER "SYSDBA" PASSWORD "masterkey" PAGE_SIZE 8192 DEFAULT CHARACTER SET WIN1251;
CREATE USER TEST2 PASSWORD 'TEST2';
EXIT;
2. Succesfully change MON$ATTACHMENTS structure under TEST2
CONNECT "localhost:lab" USER "TEST2" PASSWORD "TEST2";
ALTER TABLE MON$ATTACHMENTS DROP MON$SERVER_PID;
EXIT;
Then SELECT * FROM MON$ATTACHMENTS from any connection returns
Statement failed, SQLSTATE = XX000
internal error
--
BR, Eugene |
Show » |
|
Bug
Closed
Major
Internal error or crash occurs when accessing any MON$ table after altering its structure
Such scenario crashes 2.1.4 (but not 2.5)
CONNECT "localhost:lab" USER "TEST2" PASSWORD "TEST2";
SELECT * FROM MON$ATTACHMENTS;
ALTER TABLE MON$ATTACHMENTS DROP MON$SERVER_PID;
SELECT * FROM MON$ATTACHMENTS;
SELECT MON$USER FROM MON$ATTACHMENTS;
ALTER TABLE MON$ATTACHMENTS DROP MON$USER;
SELECT * FROM MON$ATTACHMENTS;
Statement failed, SQLCODE = -902
Unable to complete network request to host "localhost".
...