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:
None 
Category:MySQL Server: Maria storage engine Severity:S3 (Non-critical)
Version:5.1-maria OS:Any
Assigned to: Guilhem Bichot CPU Architecture:Any
Triage: D2 (Serious) / R1 (None/Negligible) / E2 (Low)

[27 May 2008 13:54] Guilhem Bichot
Description:
create table t(a int) engine=maria;
insert into t values(1);
show create table t;
flush table t;
"maria_chk -dvv t" says "crashsafe: yes".
Then
alter table t transactional=0;
show create table t; # says transactional=0, good
flush table t;
"maria_chk -dvv t" still says "crashsafe: yes". Should say "no".
Could be similar to BUG#35441 "Cannot change PAGE_CHECKSUM table option".

How to repeat:
run commands above
[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