Re: [Firebird-docs] ATTN Norman: isql guide
On 18/07/11 14:37, Dmitry Yemanov wrote: > SHOW commands operate on a separate transaction from user statements. > They run as READ COMMITTED background statements and acknowledge all > metadata changes immediately. Thanks. I've updated the isql manual with these details. 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
Re: [Firebird-docs] ATTN Norman: isql guide
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
Re: [Firebird-docs] ATTN Norman: isql guide
Hi Norman, > 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! > 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? Sorry, I've got no idea. But with Dmitry on the list... :-) Cheers, Paul Vinkenoog BTW: 'metatdata'? (twice) -- 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
Re: [Firebird-docs] ATTN Norman: isql guide
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
Re: [Firebird-docs] ATTN Norman: isql guide
14.07.2011 18:55, Norman Dunbar wrote: > So it seems as if it wasn't quite ready for publication as it would > break the pdf version. Just for the record, this is how it currently looks in PDF: http://www.firebirdsql.org/file/documentation/reference_manuals/user_manuals/Firebird-isql.pdf 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
Re: [Firebird-docs] ATTN Norman: isql guide
Hi Paul, On 10/07/11 00:50, Paul Vinkenoog wrote: > Do you know why the isql guide was never published until now? It seems you > updated it in October 2009 - wasn't it ready yet? Sorry, been away for a few days, just back. Been in Dorset sampling cider! ;-) As far as I can recall, I've never updated the isql manual! However looking at "cvs log" i see the following: == revision 1.3 date: 2009/10/20 19:15:40; author: normandunbar; state: Exp; lines: +2513 -2301 All Firebird Command Line Utilities now have a separate stand alone manual. Old inro, outro and appndx 'chapters' no longer required and have been deleted. == So it seems that I *have* updated it. I have no idea why it was never published except that I have an email from you which reads as follows: == Hi all, The fbutils-isql chapter is in CVS now. For whoever picks it up (probably Norman himself), these are some points that need attention: - Spaces around interpunction (on the wrong side / too many / none). I've corrected a number but there are probably some left. - elements with lines that are too long for the PDF. - elements that appear screwed up in the PDF. This may be a stylesheet error somewhere. Don't know if it will take long to fix, but the problem can also be circumvented by converting to or . - Improper use of and some other elements, which may arouse the suspicion of the DocBook Semantics Police. - Some of the SHOW examples, while enlightening, are extremely long. They could be truncated after 6-8 lines and followed by ".." - Some lists (esp. nested lists) could benefit from compact spacing. (BTW, we still have to implement compact spacing in the HTML stylesheet.) - Some tables need (proportional) width attributes to make them more presentable in the PDF. The above are some issues I've noticed, but I've not read the entire chapter intently, so there may be more. Greetings, Paul Vinkenoog == So it seems as if it wasn't quite ready for publication as it would break the pdf version. I'll have a look at it ASAP. 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
