summaryrefslogtreecommitdiff
path: root/mysql-test/suite/archive/discover.result
diff options
context:
space:
mode:
authorSergei Golubchik <sergii@pisem.net>2013-04-09 16:18:33 +0200
committerSergei Golubchik <sergii@pisem.net>2013-04-09 16:18:33 +0200
commit02c712aa546df8d6e9c285e6adc95309925673e3 (patch)
tree8d6654dac2666dcd738db1f10dbd919610087795 /mysql-test/suite/archive/discover.result
parentf6168bb67bb5cab0584809c876c674a92051b5d1 (diff)
downloadmariadb-git-02c712aa546df8d6e9c285e6adc95309925673e3.tar.gz
* frm extra2 segment.
* persistent table versions in the extra2 * ha_archive::frm_compare using TABLE_SHARE::tabledef_version * distinguish between "important" and "optional" extra2 frm values * write engine-defined attributes (aka "table options") to extra2, not to extra, but still read from the old location, if they're found there.
Diffstat (limited to 'mysql-test/suite/archive/discover.result')
-rw-r--r--mysql-test/suite/archive/discover.result38
1 files changed, 19 insertions, 19 deletions
diff --git a/mysql-test/suite/archive/discover.result b/mysql-test/suite/archive/discover.result
index 8cae289733b..7ffaf30d4d2 100644
--- a/mysql-test/suite/archive/discover.result
+++ b/mysql-test/suite/archive/discover.result
@@ -17,6 +17,8 @@ select * from t1;
a
1
2
+t1.ARZ
+t1.frm
#
# show tables
#
@@ -28,10 +30,9 @@ show tables;
Tables_in_test
t1
t2
-select * from t1;
-a
-1
-2
+t1.ARZ
+t2.ARZ
+t2.frm
#
# show full tables
#
@@ -40,29 +41,27 @@ show full tables;
Tables_in_test Table_type
t1 BASE TABLE
t2 BASE TABLE
-select * from t1;
-a
-1
-2
+t1.ARZ
+t2.ARZ
+t2.frm
#
# discover on truncate
#
flush tables;
truncate table t1;
ERROR HY000: Table storage engine for 't1' doesn't have this option
-show tables;
-Tables_in_test
-t1
-t2
+t1.ARZ
+t1.frm
+t2.ARZ
+t2.frm
#
# discover on rename
#
flush tables;
rename table t2 to t0;
-show tables;
-Tables_in_test
-t0
-t1
+t0.ARZ
+t1.ARZ
+t1.frm
#
# discover on HA_ERR_TABLE_DEF_CHANGED
#
@@ -77,9 +76,7 @@ t1 CREATE TABLE `t1` (
#
flush tables;
drop table t1;
-show tables;
-Tables_in_test
-t0
+t0.ARZ
#
# discover of table non-existance on drop
#
@@ -89,6 +86,9 @@ flush tables;
select * from t1;
ERROR 42S02: Table 'test.t1' doesn't exist
drop table t0;
+show status like 'Handler_discover';
+Variable_name Value
+Handler_discover 7
#
# Bug#45377: ARCHIVE tables aren't discoverable after OPTIMIZE
#