← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

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

  • Committer: Lee Bieber
  • Date: 2011-03-12 15:53:38 UTC
  • mfrom: (2048.2.2 mysql-migrate-tests)
  • mto: This revision was merged to the branch mainline in revision 2232.
  • Revision ID: kalebral@gmail.com-20110312155338-qbifjqp24vsyiluo
Merge Patrick - add suite to test drizzledump

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/suite/mysql_migrate/r/all_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
CREATE SCHEMA tmp_test;
 
5
USE tmp_test;
 
6
DROP SCHEMA test;
 
7
Dropping test database on MySQL...
 
8
Create test database on MySQL...
 
9
populating MySQL with test data...
 
10
calling drizzledump to populate Drizzle...
 
11
../client/drizzledump --compact --host=127.0.0.1 --port=13000 --destination-type=database --destination-host=localhost --destination-port=9306 --destination-user=root --user=root --all-databases;
 
12
see our schemas
 
13
SHOW SCHEMAS;
 
14
Database
 
15
DATA_DICTIONARY
 
16
drizzledump_migrate_test1
 
17
drizzledump_migrate_test2
 
18
drizzledump_migrate_test3
 
19
INFORMATION_SCHEMA
 
20
mtr
 
21
mysql
 
22
test
 
23
tmp_test
 
24
test our table:
 
25
SHOW CREATE TABLE drizzledump_migrate_test1.t1;
 
26
Table   Create Table
 
27
t1      CREATE TABLE `t1` (
 
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_test1.t2;
 
32
Table   Create Table
 
33
t2      CREATE TABLE `t2` (
 
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.t1;
 
38
Table   Create Table
 
39
t1      CREATE TABLE `t1` (
 
40
  `a` INT DEFAULT NULL,
 
41
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
42
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
43
SHOW CREATE TABLE drizzledump_migrate_test2.t2;
 
44
Table   Create Table
 
45
t2      CREATE TABLE `t2` (
 
46
  `a` INT DEFAULT NULL,
 
47
  `b` VARCHAR(10) COLLATE utf8_general_ci DEFAULT NULL
 
48
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
49
The table_name is a lie!
 
50
SHOW CREATE TABLE drizzledump_migrate_test3.not_on_drizzle;
 
51
Table   Create Table
 
52
not_on_drizzle  CREATE TABLE `not_on_drizzle` (
 
53
  `a` VARCHAR(50) COLLATE utf8_general_ci DEFAULT NULL
 
54
) ENGINE=InnoDB COLLATE = utf8_general_ci
 
55
SELECT * FROM drizzledump_migrate_test1.t1;
 
56
a       b
 
57
1       Jen
 
58
2       Roy
 
59
3       Moss
 
60
SELECT * FROM drizzledump_migrate_test1.t2;
 
61
a       b
 
62
1       Vince
 
63
2       Howard
 
64
3       Naboo
 
65
4       Bollo
 
66
5       Bob Fossil
 
67
SELECT * FROM drizzledump_migrate_test2.t1;
 
68
a       b
 
69
1       Jen
 
70
2       Moss
 
71
SELECT * FROM drizzledump_migrate_test2.t2;
 
72
a       b
 
73
1       Naboo
 
74
2       Bollo
 
75
The table_name is a lie!
 
76
SELECT * FROM drizzledump_migrate_test3.not_on_drizzle;
 
77
a
 
78
You shouldnt see this on Drizzle
 
79
Dropping test database on MySQL...
 
80
DROP SCHEMA drizzledump_migrate_test1;
 
81
DROP SCHEMA drizzledump_migrate_test2;
 
82
DROP SCHEMA drizzledump_migrate_test3;
 
83
USE test;
 
84
DROP SCHEMA tmp_test;