Re: Only setting autommit to 0 will create a transaction - Thimble Smith - com.mysql.lists.bugs

1 message in com.mysql.lists.bugsRe: Only setting autommit to 0 will c...

From	Sent On	Attachments
Thimble Smith	25 Oct 2000 11:06

Subject:	Re: Only setting autommit to 0 will create a transaction
From:	Thimble Smith (ti...@mysql.com)
Date:	10/25/2000 11:06:56 AM
List:	com.mysql.lists.bugs

Thanks for the bug report. This should be fixed in the next version of MySQL.

In the future, please send such wonderful, complete bug reports to the bu...@lists.mysql.com list, so they can be tracked more easily.

Thanks!

Tim

On Wed, Oct 25, 2000 at 07:31:28PM +0200, hamd...@libertysurf.fr wrote:

Description:

I tried the transaction in the new version of mysql and found that when doing a begin; ...; commit; there isn't any transaction there. The only way to have one is to set autocommit to 0;

How-To-Repeat:

create table tabtestmysqlhamdouni ( id int NOT NULL PRIMARY KEY, nom
varchar(64)) type=BDB; begin; insert into tabtestmysqlhamdouni values(1,'hamdouni'); select id as afterbegin_id,nom as afterbegin_nom from tabtestmysqlhamdouni; rollback; select id as afterrollback_id,nom as afterrollback_nom from
tabtestmysqlhamdouni; set autocommit=0; insert into tabtestmysqlhamdouni values(2,'mysql'); select id as afterautocommit0_id,nom as afterautocommit0_nom from
tabtestmysqlhamdouni; rollback; select id as afterrollback_id,nom as afterrollback_nom from
tabtestmysqlhamdouni; drop table tabtestmysqlhamdouni;

Fix:

Submitter-Id: <submitter ID> Originator: Hamdouni El Bachir Organization:

|\_/| El Bachir HAMDOUNI - mailto:hamd...@libertysurf.fr |o.o| Ingénieur R&D, Chez.com ( Groupe LibertySurf ) =(_)= tel 01 41 66 47 12 U

MySQL support: none Synopsis: Only setting autommit to 0 will create a transaction Severity: Priority: Category: mysql Class: Release: mysql-3.23.27-beta (Official MySQL RPM)

Environment:

System: Linux bach.intra.zehc.net 2.2.14-5.0 #1 Tue Mar 7 21:07:39 EST 2000 i686
unknown Architecture: i686

Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS=' -O6 -fomit-frame-pointer' CXX='egcs'
CXXFLAGS=' -O6 -fomit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 avr 10 2000 /lib/libc.so.6 ->
libc-2.1.3.so -rwxr-xr-x 1 root root 4101324 fév 29 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20272704 fév 29 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 fév 29 2000 /usr/lib/libc.so Configure command: ./configure --disable-shared
--with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static
--enable-assembler --with-mysqld-user=mysql
--with-unix-socket-path=/opt/var/lib/mysql/mysql.sock --with-berkeley-db=/opt
--prefix=/opt --with-extra-charsets=complex --exec-prefix=/opt
--libexecdir=/opt/sbin --sysconfdir=/opt/etc --datadir=/opt/share
--localstatedir=/opt/var/lib/mysql --infodir=/opt/info --includedir=/opt/include
--mandir=/opt/man '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux