Bug #37005 Maria: ALTER TABLE TRANSACTIONAL=0 leaves table transactional inside Maria
| Submitted: | 27 May 2008 13:54 | Modified: | 11 Jun 2008 20:51 |
|---|---|---|---|
| Reporter: | Guilhem Bichot | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Maria storage engine | Severity: | S3 (Non-critical) |
| Version: | 5.1-maria | OS: | Any |
| Assigned to: | Guilhem Bichot | CPU Architecture: | Any |
[27 May 2008 13:54]
Guilhem Bichot
[11 Jun 2008 20:27]
Guilhem Bichot
Test of multiple combinations shows 3 forms of this bug: # iteration 2 create table t1(a int) engine=maria ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 Crashsafe: yes alter table t1 transactional=0 ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 Crashsafe: yes # should be no # iteration 9 create table t1(a int) engine=maria transactional=0 ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 Crashsafe: no alter table t1 transactional=1 ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 Crashsafe: no # should be yes # iteration 14 create table t1(a int) engine=maria transactional=1 ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 Crashsafe: yes alter table t1 transactional=0 ; show create table t1; Table Create Table t1 CREATE TABLE `t1` ( `a` int(11) DEFAULT NULL ) ENGINE=MARIA DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 Crashsafe: yes # should be no
[11 Jun 2008 20:51]
Guilhem Bichot
http://lists.mysql.com/maria/66 is the patch. Thank you for your bug report. This issue has been committed to our source repository of that product and will be incorporated into the next release. If necessary, you can access the source repository and build the latest available version, including the bug fix. More information about accessing the source trees is available at http://dev.mysql.com/doc/en/installing-source.html
[30 Jun 2008 18:11]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:16]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:19]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:22]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:25]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:28]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:30]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:32]
Bugs System
Pushed into 5.1.25-maria-alpha
[30 Jun 2008 18:33]
Bugs System
Pushed into 5.1.25-maria-alpha
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.042 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.