diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 15:57:09 +0200 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-04-09 15:57:09 +0200 |
| commit | e06cb31719ce31fb1cd7944d1de86d4de9e3eca6 (patch) | |
| tree | 2c740b5851514787748799604b6c724d7c4e10b9 /mysql-test/suite/archive/archive.result | |
| parent | b3e70c4ae713abeddd47b3987f898ed763fa4eca (diff) | |
| download | mariadb-git-e06cb31719ce31fb1cd7944d1de86d4de9e3eca6.tar.gz | |
CREATE TABLE and frm-less discovering engines.
Now CREATE TABLE does not write the frm file on disk,
if the engine can discover it
Diffstat (limited to 'mysql-test/suite/archive/archive.result')
| -rw-r--r-- | mysql-test/suite/archive/archive.result | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/suite/archive/archive.result b/mysql-test/suite/archive/archive.result index 9208b987df0..23636021d2a 100644 --- a/mysql-test/suite/archive/archive.result +++ b/mysql-test/suite/archive/archive.result @@ -12816,7 +12816,35 @@ DROP TABLE t1; create table t1 (a int, b char(50)) engine=archive; select * from t1; a b +flush tables; +select * from t1; +a b 1 aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa show warnings; Level Code Message drop table t1; +create temporary table t1 (a int) engine=archive; +insert t1 values (1),(2),(3); +select * from t1; +a +1 +2 +3 +show create table t1; +Table Create Table +t1 CREATE TEMPORARY TABLE `t1` ( + `a` int(11) DEFAULT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +alter table t1 add column b varchar(10); +select * from t1; +a b +1 NULL +2 NULL +3 NULL +show create table t1; +Table Create Table +t1 CREATE TEMPORARY TABLE `t1` ( + `a` int(11) DEFAULT NULL, + `b` varchar(10) DEFAULT NULL +) ENGINE=ARCHIVE DEFAULT CHARSET=latin1 +drop table t1; |