← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/suite/mysql_migrate/r/databases.result

  • Committer: Lee Bieber
  • Date: 2011-03-12 19:26:59 UTC
  • mfrom: (2231.1.2 build)
  • Revision ID: kalebral@gmail.com-20110312192659-7gea5egdp0y06nfk
Merge Patrick - add suite to test drizzledump
Merge Patrick - 732061: need a way to execute dtr test cases with the slave plugin

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_migrate/r/databases.result
 
1
DROP SCHEMA IF EXISTS drizzledump_migrate_test1;
 
2
DROP SCHEMA IF EXISTS drizzledump_migrate_test2;
 
3
DROP SCHEMA IF EXISTS drizzledump_migrate_test3;
 
4
Dropping test database on MySQL...
 
5
Create test database on MySQL...
 
6
populating MySQL with test data...
 
7
calling drizzledump to populate Drizzle...
 
8
../client/drizzledump --compact --host=127.0.0.1 --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --user=root --databases drizzledump_migrate_test1 drizzledump_migrate_test2
 
9
see our schemas
 
10
SHOW SCHEMAS;
 
11
Database
 
12
DATA_DICTIONARY
 
13
drizzledump_migrate_test1
 
14
drizzledump_migrate_test2
 
15
INFORMATION_SCHEMA
 
16
mysql
 
17
test
 
18
test our table:
 
19
SHOW CREATE TABLE drizzledump_migrate_test1.t1;
 
20
Table   Create Table
 
21
t1      CREATE TABLE `t1` (
 
22
  `a` INT DEFAULT NULL,
 
23
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
24
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
25
SHOW CREATE TABLE drizzledump_migrate_test1.t2;
 
26
Table   Create Table
 
27
t2      CREATE TABLE `t2` (
 
28
  `a` INT DEFAULT NULL,
 
29
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
30
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
31
SHOW CREATE TABLE drizzledump_migrate_test2.t1;
 
32
Table   Create Table
 
33
t1      CREATE TABLE `t1` (
 
34
  `a` INT DEFAULT NULL,
 
35
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
36
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
37
SHOW CREATE TABLE drizzledump_migrate_test2.t2;
 
38
Table   Create Table
 
39
t2      CREATE TABLE `t2` (
 
40
  `a` INT DEFAULT NULL,
 
41
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
42
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
43
this doesn't fail, just doesn't show anything...
 
44
SHOW CREATE TABLE drizzledump_migrate_test3.t1;
 
45
Table   Create Table
 
46
SELECT * FROM drizzledump_migrate_test1.t1;
 
47
a       b
 
48
1       Jen
 
49
2       Roy
 
50
3       Moss
 
51
SELECT * FROM drizzledump_migrate_test1.t2;
 
52
a       b
 
53
1       Vince
 
54
2       Howard
 
55
3       Naboo
 
56
4       Bollo
 
57
5       Bob Fossil
 
58
SELECT * FROM drizzledump_migrate_test2.t1;
 
59
a       b
 
60
1       Jen
 
61
2       Moss
 
62
SELECT * FROM drizzledump_migrate_test2.t2;
 
63
a       b
 
64
1       Naboo
 
65
2       Bollo
 
66
SELECT * FROM drizzledump_migrate_test3.t1;
 
67
ERROR 42S02: Table 'drizzledump_migrate_test3.t1' doesn't exist
 
68
Dropping test database on MySQL...
 
69
DROP SCHEMA drizzledump_migrate_test1;
 
70
DROP SCHEMA drizzledump_migrate_test2;