diff options
author | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
---|---|---|
committer | Michael Widenius <monty@askmonty.org> | 2012-04-04 00:16:38 +0300 |
commit | b04c4801b0529aebb39c8d9be95c123d2f3b7d46 (patch) | |
tree | 0a4f72935b5ac6816996172ae412b62327b4caf4 /mysql-test/suite/maria/maria-no-logging.result | |
parent | 34ed8f33795b639d21817003236ce0f6c069481d (diff) | |
download | mariadb-git-b04c4801b0529aebb39c8d9be95c123d2f3b7d46.tar.gz |
Created suites for heap, archive and csv.
Moved test from main suite to the new suites.
Move tests from maria/t and maria/r to maria
mysql-test/mysql-test-run.pl:
Added support for the new suites
Diffstat (limited to 'mysql-test/suite/maria/maria-no-logging.result')
-rw-r--r-- | mysql-test/suite/maria/maria-no-logging.result | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/mysql-test/suite/maria/maria-no-logging.result b/mysql-test/suite/maria/maria-no-logging.result new file mode 100644 index 00000000000..9c50245d05d --- /dev/null +++ b/mysql-test/suite/maria/maria-no-logging.result @@ -0,0 +1,51 @@ +set global aria_log_file_size=4294959104; +drop database if exists mysqltest; +create database mysqltest; +use mysqltest; +set global aria_checkpoint_interval=0; +create table t2 (a varchar(100)) engine=myisam; +insert into t2 select repeat('z',100); +insert into t2 select * from t2; +insert into t2 select * from t2; +insert into t2 select * from t2; +insert into t2 select * from t2; +insert into t2 select * from t2; +insert into t2 select * from t2; +* shut down mysqld, removed logs, restarted it +create table t1 (a varchar(100)) engine=aria transactional=1; +show create table t1; +Table Create Table +t1 CREATE TABLE `t1` ( + `a` varchar(100) DEFAULT NULL +) ENGINE=Aria DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=1 +show engine aria logs; +Type Name Status +Aria Size 16384 aria_log.00000001 unknown +insert into t1 values('a'); +insert into t1 select * from t2; +show engine aria logs; +Type Name Status +Aria Size 24576 aria_log.00000001 unknown +* shut down mysqld, removed logs, restarted it +truncate table t1; +insert into t1 select * from t2; +show engine aria logs; +Type Name Status +Aria Size 16384 aria_log.00000001 unknown +drop table t1; +* shut down mysqld, removed logs, restarted it +create table t1 (a varchar(100)) engine=aria transactional=1; +insert into t1 values('a'); +create table if not exists t1 select * from t2; +Warnings: +Note 1050 Table 't1' already exists +show engine aria logs; +Type Name Status +Aria Size 16384 aria_log.00000001 unknown +* shut down mysqld, removed logs, restarted it +drop table t1; +create table t1 engine=aria transactional=1 select * from t2; +show engine aria logs; +Type Name Status +Aria Size 16384 aria_log.00000001 unknown +drop database mysqltest; |