summaryrefslogtreecommitdiff
path: root/mysql-test/r/backup.result
diff options
context:
space:
mode:
authorunknown <monty@narttu.mysql.fi>2003-03-17 15:05:04 +0200
committerunknown <monty@narttu.mysql.fi>2003-03-17 15:05:04 +0200
commitb0b315dce3d961e5b29830dfafdff6bc4e58aaa0 (patch)
tree7762c42e75102f122a8c9f5423ed0b676d5430a4 /mysql-test/r/backup.result
parenta821703912e84b6be1f0a686f27e1c81a0040ff8 (diff)
downloadmariadb-git-b0b315dce3d961e5b29830dfafdff6bc4e58aaa0.tar.gz
After merge fixes
Don't create temporary objects with no table name myisam/mi_open.c: After merge fix mysql-test/r/analyse.result: After merge fix mysql-test/r/backup.result: After merge fix mysql-test/r/create.result: After merge fix mysql-test/r/delete.result: After merge fix mysql-test/r/func_like.result: After merge fix mysql-test/r/innodb.result: After merge fix mysql-test/r/rpl_loaddatalocal.result: After merge fix mysql-test/r/type_timestamp.result: After merge fix mysql-test/t/delete.test: Change to not use table 't' sql/sql_class.h: Remove usage of thd when creating 'Table_ident' Don't create temporary objects with no table name sql/sql_derived.cc: Indentation fix sql/sql_select.cc: After merge fix Fixed wrong return -> DBUG_RETURN() sql/sql_yacc.yy: Remove usage of thd when creating 'Table_ident'
Diffstat (limited to 'mysql-test/r/backup.result')
-rw-r--r--mysql-test/r/backup.result39
1 files changed, 22 insertions, 17 deletions
diff --git a/mysql-test/r/backup.result b/mysql-test/r/backup.result
index e4f41517f94..e53c3c3eb55 100644
--- a/mysql-test/r/backup.result
+++ b/mysql-test/r/backup.result
@@ -1,20 +1,25 @@
set SQL_LOG_BIN=0;
drop table if exists t1, t2, t3;
-create table t1(n int);
-backup table t1 to '../bogus';
+create table t4(n int);
+backup table t4 to '../bogus';
Table Op Msg_type Msg_text
-test.t1 backup error Failed copying .frm file: errno = X
-test.t1 backup status Operation failed
-backup table t1 to '../tmp';
+test.t4 backup error Failed copying .frm file (errno: X)
+test.t4 backup status Operation failed
+backup table t4 to '../tmp';
Table Op Msg_type Msg_text
-test.t1 backup status OK
-drop table t1;
-restore table t1 from '../tmp';
+test.t4 backup status OK
+backup table t4 to '../tmp';
Table Op Msg_type Msg_text
-test.t1 restore status OK
-select count(*) from t1;
+test.t4 backup error Failed copying .frm file (errno: X)
+test.t4 backup status Operation failed
+drop table t4;
+restore table t4 from '../tmp';
+Table Op Msg_type Msg_text
+test.t4 restore status OK
+select count(*) from t4;
count(*)
0
+create table t1(n int);
insert into t1 values (23),(45),(67);
backup table t1 to '../tmp';
Table Op Msg_type Msg_text
@@ -35,9 +40,8 @@ create table t2(m int not null primary key);
create table t3(k int not null primary key);
insert into t2 values (123),(145),(167);
insert into t3 values (223),(245),(267);
-backup table t1,t2,t3 to '../tmp';
+backup table t2,t3 to '../tmp';
Table Op Msg_type Msg_text
-test.t1 backup status OK
test.t2 backup status OK
test.t3 backup status OK
drop table t1,t2,t3;
@@ -61,13 +65,14 @@ k
223
245
267
-drop table t1,t2,t3;
+drop table t1,t2,t3,t4;
restore table t1 from '../tmp';
Table Op Msg_type Msg_text
test.t1 restore status OK
-lock tables t1 write;
-backup table t1 to '../tmp';
+rename table t1 to t5;
+lock tables t5 write;
+backup table t5 to '../tmp';
unlock tables;
Table Op Msg_type Msg_text
-test.t1 backup status OK
-drop table t1;
+test.t5 backup status OK
+drop table t5;