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