← Back to branch summary

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

« back to all changes in this revision

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

  • 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/status_dictionary/tests/r/data_dictionary.result
1
1
use data_dictionary;
2
2
show create table GLOBAL_STATUS ;
3
3
Table   Create Table
4
 
GLOBAL_STATUS   CREATE TABLE `global_status` (
5
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
6
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
7
 
) ENGINE=FunctionEngine
8
 
show create table GLOBAL_STATEMENTS ;
9
 
Table   Create Table
10
 
GLOBAL_STATEMENTS       CREATE TABLE `global_statements` (
11
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
12
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
13
 
) ENGINE=FunctionEngine
 
4
GLOBAL_STATUS   CREATE TABLE `GLOBAL_STATUS` (
 
5
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
 
6
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
 
7
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
14
8
show create table GLOBAL_VARIABLES ;
15
9
Table   Create Table
16
 
GLOBAL_VARIABLES        CREATE TABLE `global_variables` (
17
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
18
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
19
 
) ENGINE=FunctionEngine
20
 
show create table SESSION_STATEMENTS;
21
 
Table   Create Table
22
 
SESSION_STATEMENTS      CREATE TABLE `session_statements` (
23
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
24
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
25
 
) ENGINE=FunctionEngine
 
10
GLOBAL_VARIABLES        CREATE TABLE `GLOBAL_VARIABLES` (
 
11
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
 
12
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
 
13
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
26
14
show create table SESSION_STATUS;
27
15
Table   Create Table
28
 
SESSION_STATUS  CREATE TABLE `session_status` (
29
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
30
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
31
 
) ENGINE=FunctionEngine
 
16
SESSION_STATUS  CREATE TABLE `SESSION_STATUS` (
 
17
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
 
18
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
 
19
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
32
20
show create table SESSION_VARIABLES;
33
21
Table   Create Table
34
 
SESSION_VARIABLES       CREATE TABLE `session_variables` (
35
 
  `VARIABLE_NAME` varchar(64) NOT NULL DEFAULT '',
36
 
  `VARIABLE_VALUE` varchar(1024) NOT NULL DEFAULT ''
37
 
) ENGINE=FunctionEngine
38
 
SELECT count(*) FROM data_dictionary.GLOBAL_STATEMENTS;
39
 
count(*)
40
 
#
 
22
SESSION_VARIABLES       CREATE TABLE `SESSION_VARIABLES` (
 
23
  `VARIABLE_NAME` VARCHAR(256) NOT NULL,
 
24
  `VARIABLE_VALUE` VARCHAR(1024) NOT NULL
 
25
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
41
26
SELECT count(*) FROM data_dictionary.GLOBAL_STATUS;
42
27
count(*)
43
28
#
44
29
SELECT count(*) FROM data_dictionary.GLOBAL_VARIABLES;
45
30
count(*)
46
31
#
47
 
SELECT count(*) FROM data_dictionary.SESSION_STATEMENTS;
48
 
count(*)
49
 
#
50
32
SELECT count(*) FROM data_dictionary.SESSION_STATUS;
51
33
count(*)
52
34
#