You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
When MON$ tables are queried the first time, only information for the current connection is returned. If some other connection in turn queries MON$ then it gets information for both connections. After that, the first connection also gets full information. And so on.
Submitted by: @sim1984
When MON$ tables are queried the first time, only information for the current connection is returned. If some other connection in turn queries MON$ then it gets information for both connections. After that, the first connection also gets full information. And so on.
Simplified test case:
isql #1
SQL> connect 'test';
Database: 'test', User: dimitr
isql #2
SQL> connect 'test';
Database: 'test', User: dimitr
isql #1
SQL> select count(*) from mon$attachments;
============
1
isql #2
SQL> select count(*) from mon$attachments;
============
2
isql #1
SQL> commit;
SQL> select count(*) from mon$attachments;
============
2
Commits: a18788a FirebirdSQL/fbt-repository@26bdd18
====== Test Details ======
Could not reproduce on WI-T3.0.0.30566 Firebird 3.0 Alpha 1.
Window-1:
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB
SQL> create user u01 password '123'; commit;
SQL> exit;
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01
Window-2:
C:\MIX\firebird\oldfb30a1\isql /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB -user u01 -pas 123
Database: /3298:C:\MIX\firebird\QA\fbt-repo\tmp\E30A1.FDB, User: u01
Window-1:
SQL> select count(*) from mon$attachments where mon$user='U01';
=====================
2
The text was updated successfully, but these errors were encountered: