← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/r/drizzledump_restore.result

  • Committer: Brian Aker
  • Date: 2010-06-28 16:17:36 UTC
  • mfrom: (1637.4.1 drizzle)
  • Revision ID: brian@gaz-20100628161736-eormhb2mnd551i2h
Merge unused

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/r/drizzledump_restore.result
78
78
Comparing tables test.t1 and test.t1_orig
79
79
# Cleanup
80
80
DROP TABLE test.t1, test.t1_orig;
81
 
#
82
 
# Bug#550091 in Drizzle: "drizzledump dumps data_dictionary"
83
 
#
84
 
CREATE TABLE t1 (a char(100), b int);
85
 
INSERT INTO t1 values ('a',100);
86
 
INSERT INTO t1 values ('b',200);
87
 
CREATE SCHEMA drizzledump_test;
88
 
USE drizzledump_test;
89
 
CREATE TABLE t1 (a int, b char(100));
90
 
INSERT INTO t1 VALUES (1, 'abbazabba');
91
 
DROP original schemas
92
 
DROP DATABASE test;
93
 
DROP DATABASE drizzledump_test;
94
 
Ensure we don't have those tables (verify we restored something)
95
 
SELECT * FROM test.t1;
96
 
ERROR 42S02: Unknown table 'test.t1'
97
 
SELECT * FROM drizzledump_test.t1;
98
 
ERROR 42S02: Unknown table 'drizzledump_test.t1'
99
 
Restoring from dumpfile
100
 
USE test;
101
 
SELECT * FROM t1;
102
 
a       b
103
 
a       100
104
 
b       200
105
 
SELECT * FROM drizzledump_test.t1;
106
 
a       b
107
 
1       abbazabba
108
 
Cleanup
109
 
DROP DATABASE drizzledump_test;
110
 
DROP TABLE t1;
111
81
# End tests
112
82
# Cleanup
113
83
# remove drizzledumpfile