← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to plugin/schema_dictionary/tests/t/data_dictionary.test

  • Committer: Bazaar Package Importer
  • Author(s): Monty Taylor
  • Date: 2010-10-02 14:17:48 UTC
  • mfrom: (1.1.1 upstream)
  • mto: (2.1.17 sid)
  • mto: This revision was merged to the branch mainline in revision 3.
  • Revision ID: james.westby@ubuntu.com-20101002141748-m6vbfbfjhrw1153e
Tags: 2010.09.1802-1
* New upstream release.
* Removed pid-file argument hack.
* Updated GPL-2 address to be new address.
* Directly copy in drizzledump.1 since debian doesn't have sphinx 1.0 yet.
* Link to jquery from libjs-jquery. Add it as a depend.
* Add drizzled.8 symlink to the install files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/schema_dictionary/tests/t/data_dictionary.test
2
2
 
3
3
use data_dictionary;
4
4
 
5
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
5
--sorted_result
6
6
SELECT count(*) FROM columns;
7
7
 
8
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
8
--sorted_result
9
9
SELECT count(*) FROM indexes;
10
10
 
11
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
11
--sorted_result
12
12
SELECT count(*) FROM index_parts;
13
13
 
14
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
15
 
SELECT SCHEMA_NAME  FROM schemas;
 
14
SELECT SCHEMA_NAME  FROM schemas ORDER BY SCHEMA_NAME;
16
15
 
17
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
16
--sorted_result
18
17
SELECT COLUMN_NAME  FROM columns;
19
18
 
20
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
19
--sorted_result
21
20
SELECT count(*) FROM REFERENTIAL_CONSTRAINTS;
22
21
 
23
 
--replace_column 1 #  6 # 7 # 8 # 9 # 10 #
 
22
--sorted_result
24
23
SELECT count(*) FROM TABLE_CONSTRAINTS;
25
24
 
26
25
# Make sure we don't change the names of the columns
30
29
show create table INDEX_PARTS ;
31
30
show create table REFERENTIAL_CONSTRAINTS ;
32
31
show create table SCHEMAS ;
33
 
show create table SCHEMA_NAMES;
34
32
show create table TABLES ;
35
33
show create table TABLE_CONSTRAINTS ;
36
34
 
38
36
CREATE SCHEMA A;
39
37
use A;
40
38
create table A (a int);
 
39
--sorted_result
41
40
SELECT COUNT(*) FROM data_dictionary.tables WHERE TABLE_NAME = "A";
42
41
 
 
42
# Here to confirm fix for bug lp:514009
 
43
use data_dictionary;
 
44
--sorted_result
 
45
SELECT TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
 
46
 
 
47
--sorted_result
 
48
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_SCHEMA,TABLE_NAME, COLUMN_NAME;
 
49
 
 
50
--sorted_result
 
51
SELECT TABLE_NAME,TABLE_SCHEMA,COLUMN_NAME from COLUMNS ORDER BY TABLE_NAME,TABLE_SCHEMA, COLUMN_NAME;
 
52
 
43
53
DROP SCHEMA A;