~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to plugin/haildb/test-suite-dir/haildb/tests/r/config_table_function.result

  • Committer: lbieber
  • Date: 2010-10-02 00:25:54 UTC
  • mfrom: (1804.1.2 build)
  • Revision ID: lbieber@orisndriz08-20101002002554-sf30ezteu701kzzu
Merge Stewart - Rename embedded_innodb to HailDB everywhere EXCEPT the plugin name 

Show diffs side-by-side

added added

removed removed

Lines of Context:
1
 
SHOW CREATE TABLE DATA_DICTIONARY.INNODB_CONFIGURATION;
 
1
SHOW CREATE TABLE DATA_DICTIONARY.HAILDB_CONFIGURATION;
2
2
Table   Create Table
3
 
INNODB_CONFIGURATION    CREATE TABLE `INNODB_CONFIGURATION` (
 
3
HAILDB_CONFIGURATION    CREATE TABLE `HAILDB_CONFIGURATION` (
4
4
  `NAME` VARCHAR(256) NOT NULL,
5
5
  `TYPE` VARCHAR(256) NOT NULL,
6
6
  `VALUE` VARCHAR(64) DEFAULT NULL
7
7
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
8
 
SELECT COUNT(*) FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
 
8
SELECT COUNT(*) FROM DATA_DICTIONARY.HAILDB_CONFIGURATION;
9
9
COUNT(*)
10
10
36
11
 
SELECT NAME,TYPE FROM DATA_DICTIONARY.INNODB_CONFIGURATION;
 
11
SELECT NAME,TYPE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION;
12
12
NAME    TYPE
13
13
adaptive_hash_index     BOOL
14
14
adaptive_flushing       BOOL
46
46
sync_spin_loops ULONG
47
47
use_sys_malloc  BOOL
48
48
version TEXT
49
 
SELECT * FROM DATA_DICTIONARY.INNODB_CONFIGURATION where NAME NOT IN ("VERSION");
 
49
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION where NAME NOT IN ("VERSION");
50
50
NAME    TYPE    VALUE
51
51
adaptive_hash_index     BOOL    true
52
52
adaptive_flushing       BOOL    true
83
83
status_file     BOOL    false
84
84
sync_spin_loops ULONG   30
85
85
use_sys_malloc  BOOL    true
86
 
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME IN ("data_file_path", "data_home_dir");
 
86
SELECT NAME,VALUE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME IN ("data_file_path", "data_home_dir");
87
87
NAME    VALUE
88
88
data_file_path  NULL
89
89
data_home_dir   ./
90
 
SELECT NAME,VALUE FROM DATA_DICTIONARY.INNODB_CONFIGURATION WHERE NAME = "file_per_table";
 
90
SELECT NAME,VALUE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME = "file_per_table";
91
91
NAME    VALUE
92
92
file_per_table  false