diff options
author | Sergei Golubchik <serg@mariadb.org> | 2015-06-01 16:01:23 +0200 |
---|---|---|
committer | Sergei Golubchik <serg@mariadb.org> | 2015-06-01 16:01:23 +0200 |
commit | fce4ab0ab405e112035bda98176c5834200d26df (patch) | |
tree | 97ccac45b59d1523c22408427f701353284d66ec /mysql-test/r | |
parent | 5091a4ba755250ed8e35f4f5a39a118d476cd8f1 (diff) | |
download | mariadb-git-fce4ab0ab405e112035bda98176c5834200d26df.tar.gz |
generalize ER_TABLE_NEEDS_UPGRADE to work for views too
Diffstat (limited to 'mysql-test/r')
-rw-r--r-- | mysql-test/r/ctype_upgrade.result | 10 | ||||
-rw-r--r-- | mysql-test/r/mysqlcheck.result | 2 | ||||
-rw-r--r-- | mysql-test/r/perror.result | 2 | ||||
-rw-r--r-- | mysql-test/r/repair.result | 2 | ||||
-rw-r--r-- | mysql-test/r/upgrade.result | 2 | ||||
-rw-r--r-- | mysql-test/r/varbinary.result | 2 |
6 files changed, 10 insertions, 10 deletions
diff --git a/mysql-test/r/ctype_upgrade.result b/mysql-test/r/ctype_upgrade.result index 6bef89f6cd6..b317be42d5c 100644 --- a/mysql-test/r/ctype_upgrade.result +++ b/mysql-test/r/ctype_upgrade.result @@ -6,7 +6,7 @@ call mtr.add_suppression("Table rebuild required"); # Copying maria050313_utf8_croatian_ci.* to MYSQLD_DATADIR CHECK TABLE maria050313_utf8_croatian_ci FOR UPGRADE; Table Op Msg_type Msg_text -test.maria050313_utf8_croatian_ci check error Table upgrade required. Please do "REPAIR TABLE `maria050313_utf8_croatian_ci`" or dump/reload to fix it! +test.maria050313_utf8_croatian_ci check error Upgrade required. Please do "REPAIR TABLE `maria050313_utf8_croatian_ci`" or dump/reload to fix it! SHOW CREATE TABLE maria050313_utf8_croatian_ci; ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.maria050313_utf8_croatian_c` FORCE" or dump/reload to fix it! REPAIR TABLE maria050313_utf8_croatian_ci; @@ -43,7 +43,7 @@ DROP TABLE maria050313_utf8_croatian_ci; # Copying maria050313_ucs2_croatian_ci.* to MYSQLD_DATADIR CHECK TABLE maria050313_ucs2_croatian_ci_def FOR UPGRADE; Table Op Msg_type Msg_text -test.maria050313_ucs2_croatian_ci_def check error Table upgrade required. Please do "REPAIR TABLE `maria050313_ucs2_croatian_ci_def`" or dump/reload to fix it! +test.maria050313_ucs2_croatian_ci_def check error Upgrade required. Please do "REPAIR TABLE `maria050313_ucs2_croatian_ci_def`" or dump/reload to fix it! SELECT count(*) FROM maria050313_ucs2_croatian_ci_def; ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.maria050313_ucs2_croatian_c` FORCE" or dump/reload to fix it! REPAIR TABLE maria050313_ucs2_croatian_ci_def; @@ -58,7 +58,7 @@ DROP TABLE maria050313_ucs2_croatian_ci_def; # Copying maria050313_ucs2_croatian_ci.* to MYSQLD_DATADIR CHECK TABLE maria050313_ucs2_croatian_ci_def; Table Op Msg_type Msg_text -test.maria050313_ucs2_croatian_ci_def check error Table upgrade required. Please do "REPAIR TABLE `maria050313_ucs2_croatian_ci_def`" or dump/reload to fix it! +test.maria050313_ucs2_croatian_ci_def check error Upgrade required. Please do "REPAIR TABLE `maria050313_ucs2_croatian_ci_def`" or dump/reload to fix it! REPAIR TABLE maria050313_ucs2_croatian_ci_def; Table Op Msg_type Msg_text test.maria050313_ucs2_croatian_ci_def repair status OK @@ -84,7 +84,7 @@ DROP TABLE maria050313_ucs2_croatian_ci_def; # Copying maria050533_xxx_croatian_ci.* to MYSQLD_DATADIR CHECK TABLE maria050533_xxx_croatian_ci FOR UPGRADE; Table Op Msg_type Msg_text -test.maria050533_xxx_croatian_ci check error Table upgrade required. Please do "REPAIR TABLE `maria050533_xxx_croatian_ci`" or dump/reload to fix it! +test.maria050533_xxx_croatian_ci check error Upgrade required. Please do "REPAIR TABLE `maria050533_xxx_croatian_ci`" or dump/reload to fix it! REPAIR TABLE maria050533_xxx_croatian_ci; Table Op Msg_type Msg_text test.maria050533_xxx_croatian_ci repair status OK @@ -141,7 +141,7 @@ DROP TABLE maria050533_xxx_croatian_ci; # Copying maria100004_xxx_croatian_ci.* to MYSQLD_DATADIR CHECK TABLE maria100004_xxx_croatian_ci FOR UPGRADE; Table Op Msg_type Msg_text -test.maria100004_xxx_croatian_ci check error Table upgrade required. Please do "REPAIR TABLE `maria100004_xxx_croatian_ci`" or dump/reload to fix it! +test.maria100004_xxx_croatian_ci check error Upgrade required. Please do "REPAIR TABLE `maria100004_xxx_croatian_ci`" or dump/reload to fix it! SELECT count(*) FROM maria100004_xxx_croatian_ci; ERROR HY000: Table rebuild required. Please do "ALTER TABLE `test.maria100004_xxx_croatian_ci` FORCE" or dump/reload to fix it! REPAIR TABLE maria100004_xxx_croatian_ci; diff --git a/mysql-test/r/mysqlcheck.result b/mysql-test/r/mysqlcheck.result index 2d4a053b3a2..adfc56fcd69 100644 --- a/mysql-test/r/mysqlcheck.result +++ b/mysql-test/r/mysqlcheck.result @@ -329,7 +329,7 @@ DROP TABLE bug47205; # Should indicate that REPAIR TABLE is needed CHECK TABLE bug47205 FOR UPGRADE; Table Op Msg_type Msg_text -test.bug47205 check error Table upgrade required. Please do "REPAIR TABLE `bug47205`" or dump/reload to fix it! +test.bug47205 check error Upgrade required. Please do "REPAIR TABLE `bug47205`" or dump/reload to fix it! # Running mysqlcheck to check and upgrade test.bug47205 Needs upgrade diff --git a/mysql-test/r/perror.result b/mysql-test/r/perror.result index 30a56840b1b..432a4fd4c04 100644 --- a/mysql-test/r/perror.result +++ b/mysql-test/r/perror.result @@ -2,5 +2,5 @@ Illegal error code: 10000 MySQL error code 1062 (ER_DUP_ENTRY): Duplicate entry '%-.192s' for key %d MySQL error code 1408 (ER_STARTUP): %s: ready for connections. Version: '%s' socket: '%s' port: %d %s -MySQL error code 1459 (ER_TABLE_NEEDS_UPGRADE): Table upgrade required. Please do "REPAIR TABLE `%-.32s`" or dump/reload to fix it! +MySQL error code 1459 (ER_TABLE_NEEDS_UPGRADE): Upgrade required. Please do "REPAIR %s %`s" or dump/reload to fix it! MySQL error code 1461 (ER_MAX_PREPARED_STMT_COUNT_REACHED): Can't create more than max_prepared_stmt_count statements (current value: %lu) diff --git a/mysql-test/r/repair.result b/mysql-test/r/repair.result index 79bc6d55c55..79ee0c7a9b8 100644 --- a/mysql-test/r/repair.result +++ b/mysql-test/r/repair.result @@ -126,7 +126,7 @@ id # Run CHECK TABLE, it should indicate table need a REPAIR TABLE CHECK TABLE t1 FOR UPGRADE; Table Op Msg_type Msg_text -test.t1 check error Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! +test.t1 check error Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! # REPAIR old table USE_FRM should fail REPAIR TABLE t1 USE_FRM; Table Op Msg_type Msg_text diff --git a/mysql-test/r/upgrade.result b/mysql-test/r/upgrade.result index b6e924c71cc..74b888e49c5 100644 --- a/mysql-test/r/upgrade.result +++ b/mysql-test/r/upgrade.result @@ -67,7 +67,7 @@ drop table `txu@0023p@0023p1`; # check the table created using mysql 4.0 CHECK TABLE t1; Table Op Msg_type Msg_text -test.t1 check error Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! +test.t1 check error Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! # query the table created using mysql 4.0 SELECT * FROM t1; c1 c2 c3 diff --git a/mysql-test/r/varbinary.result b/mysql-test/r/varbinary.result index 689db16b5d4..b5f6d065174 100644 --- a/mysql-test/r/varbinary.result +++ b/mysql-test/r/varbinary.result @@ -91,7 +91,7 @@ length(a) length(b) 255 3 CHECK TABLE t1 FOR UPGRADE; Table Op Msg_type Msg_text -test.t1 check error Table upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! +test.t1 check error Upgrade required. Please do "REPAIR TABLE `t1`" or dump/reload to fix it! REPAIR TABLE t1; Table Op Msg_type Msg_text test.t1 repair status OK |