Afternoon all,
I'm doing a bit of lunchtime work on the isql manual (hooray!) and I've
come across this bit in the existing version, in the Transaction
Handling section:
You can use various SHOW commands in isql to query database metatdata.
Metatdata is stored in system tables. When a SHOW command is issued,
isql commits the current transaction and begins a new one, in READ
COMMITTED isolation. This ensures that users will always view the most
current state of the database.
Ok, Similar to Oracle I thought - which commits a transaction any time
you run DDL commands. So I tested it:
SQL> create table test (a integer);
SQL> commit;
SQL> insert into test values (1);
SQL> insert into test values (2);
SQL> insert into test values (3);
SQL> commit;
SQL> update test
CON> set a = 7
CON> where a = 2;
SQL> show table test;
A INTEGER Nullable
SQL> select * from test;
A
============
1
7
3
SQL> rollback;
SQL> select * from test;
A
============
1
2
3
So, it's plainly obvious that the above is not true in Firebird 2.5 at
least.
Are there any specific SHOW commands which cause any DML transactions to
be committed or is the original statement about a commit being executed,
completely false?
I don't have time to go through all the SHOW commands to see which ones
may commit and which don't!
Thanks.
Cheers,
Norm.
--
Norman Dunbar
Dunbar IT Consultants Ltd
Registered address:
Thorpe House
61 Richardshaw Lane
Pudsey
West Yorkshire
United Kingdom
LS28 7EL
Company Number: 05132767
------------------------------------------------------------------------------
AppSumo Presents a FREE Video for the SourceForge Community by Eric
Ries, the creator of the Lean Startup Methodology on "Lean Startup
Secrets Revealed." This video shows you how to validate your ideas,
optimize your ideas and identify your business strategy.
http://p.sf.net/sfu/appsumosfdev2dev
_______________________________________________
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
