~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/status_dictionary/tests/r/data_dictionary.result

  • Committer: Brian Aker
  • Date: 2011-04-04 21:37:55 UTC
  • mfrom: (2241.6.2 drizzle-trunk)
  • mto: This revision was merged to the branch mainline in revision 2268.
  • Revision ID: brian@tangent.org-20110404213755-k4kl3qd5fkbvjmhe
Merge in owner tree.

Show diffs side-by-side

added added

removed removed

Lines of Context:
4
4
GLOBAL_STATUS   CREATE TABLE `GLOBAL_STATUS` (
5
5
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
6
6
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
7
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
7
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
8
8
show create table GLOBAL_VARIABLES ;
9
9
Table   Create Table
10
10
GLOBAL_VARIABLES        CREATE TABLE `GLOBAL_VARIABLES` (
11
11
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
12
12
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
13
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
13
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
14
14
show create table SESSION_STATUS;
15
15
Table   Create Table
16
16
SESSION_STATUS  CREATE TABLE `SESSION_STATUS` (
17
17
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
18
18
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
19
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
19
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
20
20
show create table SESSION_VARIABLES;
21
21
Table   Create Table
22
22
SESSION_VARIABLES       CREATE TABLE `SESSION_VARIABLES` (
23
23
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
24
24
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
25
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE
 
25
) ENGINE=FunctionEngine COLLATE = utf8_general_ci REPLICATE = FALSE DEFINER SYSTEM
26
26
SELECT count(*) FROM data_dictionary.GLOBAL_STATUS;
27
27
count(*)
28
28
#