18.07.2011 16:51, Paul Vinkenoog wrote: > >> 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. > > As you showed below, this is not (always) true. Maybe it only commits DDL? > > Personally, I would't like SHOW to commit anything at all! I expect SHOW > to SHOW me something, not to CHANGE anything!
The truth can be found in the Borland's Operation Guide: "SHOW commands operate on a separate transaction from user statements. They run as READ COMMITTED background statements and acknowledge all metadata changes immediately." i.e. it doesn't commit any user DML/DDL transaction, but runs in its own transaction context (usually this means starting a new transaction before selecting metadata and committing it afterwards). Dmitry ------------------------------------------------------------------------------ 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
