diff options
Diffstat (limited to 'mysql-test/suite/maria/maria-page-checksum.result')
| -rw-r--r-- | mysql-test/suite/maria/maria-page-checksum.result | 940 |
1 files changed, 940 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-page-checksum.result b/mysql-test/suite/maria/maria-page-checksum.result new file mode 100644 index 00000000..fbb7ba78 --- /dev/null +++ b/mysql-test/suite/maria/maria-page-checksum.result @@ -0,0 +1,940 @@ +drop table if exists t1; +select @@global.aria_page_checksum; +@@global.aria_page_checksum +1 +# iteration 1a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 2a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 3a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 4a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 5a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 6a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 7a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 8a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 9a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 10a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 11a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 12a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 13a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 14a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 15a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 16a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 17a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 18a +set global aria_page_checksum = 0 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 19a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 20a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 21a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 22a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 23a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 24a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 25a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 26a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 27a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 28a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 29a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 30a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 31a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 32a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 33a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 0 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 34a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 engine=aria ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 35a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=0 ; +show create table t1 /* expecting PAGE_CHECKSUM=0 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=0 +Page checksums are not used +drop table t1; +# iteration 36a +set global aria_page_checksum = 1 ; +create table t1(a int) engine=aria PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +set global aria_page_checksum = 1 ; +alter table t1 PAGE_CHECKSUM=1 ; +show create table t1 /* expecting PAGE_CHECKSUM=1 */ ; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Page checksums are used +drop table t1; +# iteration 1b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +alter table t1 modify a bigint ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +drop table t1; +# iteration 2b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria 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=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 3b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +alter table t1 transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 4b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +alter table t1 engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +drop table t1; +# iteration 5b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +alter table t1 engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 6b +create table t1(a int) engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 +Crashsafe: yes +alter table t1 engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 7b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +alter table t1 modify a bigint ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 8b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +alter table t1 transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 9b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria 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=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 10b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +alter table t1 engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 11b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +alter table t1 engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 12b +create table t1(a int) engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +alter table t1 engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 13b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +alter table t1 modify a bigint ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` bigint(20) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 14b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria 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=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 15b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +alter table t1 transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 16b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +alter table t1 engine=aria ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; +# iteration 17b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +alter table t1 engine=aria transactional=0 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 +Crashsafe: no +drop table t1; +# iteration 18b +create table t1(a int) engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +alter table t1 engine=aria transactional=1 ; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +Crashsafe: yes +drop table t1; |