Re: [Maria-discuss] R: transactions and UNLOCK TABLES

2014-09-23 Thread Roberto Spadim
ha scritto: > > Oggetto: Re: [Maria-discuss] R: transactions and UNLOCK TABLES > A: "Federico Razzoli" , > maria-discuss@lists.launchpad.net > Data: Martedì 23 settembre 2014, 11:51 > > Hi Federico, > > On 23.09.2014 12:50, Federico > Razzoli wrote: > >

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

2014-09-23 Thread Roberto Spadim
+1 =) mysql manual sometimes don't help, that's why i really prefer mariadb kb i think that many years ago mysql implement this nontransactional like locks to innodb just to allow guys porting from myisam to innodb using old apps without rewriting the lock/unlock to begin/commit if you are using

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

2014-09-23 Thread Federico Razzoli
erico Mar 23/9/14, Elena Stepanova ha scritto: Oggetto: Re: [Maria-discuss] R: transactions and UNLOCK TABLES A: "Federico Razzoli" , maria-discuss@lists.launchpad.net Data: Martedì 23 settembre 2014, 11:51 Hi Federico, On 23.09.2014 12:50, Federico Razzoli

Re: [Maria-discuss] R: transactions and UNLOCK TABLES

2014-09-23 Thread Elena Stepanova
Hi Federico, On 23.09.2014 12:50, Federico Razzoli wrote: Let's make the snippet simpler. Only one table, non-transactional, please look at the difference from what docs say and the real behaviour. If one could explain what UNLOCK TABLES exactly does, it would be great. MariaDB [test]> SELECT

[Maria-discuss] R: transactions and UNLOCK TABLES

2014-09-23 Thread Federico Razzoli
Let's make the snippet simpler. Only one table, non-transactional, please look at the difference from what docs say and the real behaviour. If one could explain what UNLOCK TABLES exactly does, it would be great. MariaDB [test]> SELECT @@in_transaction, @@autocommit; +--+