← Back to branch summary

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

« back to all changes in this revision

Viewing changes to plugin/haildb/tests/r/config_table_function.result

  • Committer: Package Import Robot
  • Author(s): Clint Byrum
  • Date: 2012-06-19 10:46:49 UTC
  • mfrom: (1.1.6)
  • mto: This revision was merged to the branch mainline in revision 29.
  • Revision ID: package-import@ubuntu.com-20120619104649-e2l0ggd4oz3um0f4
Tags: upstream-7.1.36-stable
Import upstream version 7.1.36-stable

Show diffs side-by-side

added added

removed removed

Lines of Context:
plugin/haildb/tests/r/config_table_function.result
1
 
SHOW CREATE TABLE DATA_DICTIONARY.HAILDB_CONFIGURATION;
2
 
Table   Create Table
3
 
HAILDB_CONFIGURATION    CREATE TABLE `HAILDB_CONFIGURATION` (
4
 
  `NAME` VARCHAR(256) NOT NULL,
5
 
  `TYPE` VARCHAR(256) NOT NULL,
6
 
  `VALUE` VARCHAR(64) DEFAULT NULL
7
 
) ENGINE=FunctionEngine COLLATE = utf8_general_ci
8
 
SELECT COUNT(*) FROM DATA_DICTIONARY.HAILDB_CONFIGURATION;
9
 
COUNT(*)
10
 
36
11
 
SELECT NAME,TYPE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION;
12
 
NAME    TYPE
13
 
adaptive_hash_index     BOOL
14
 
adaptive_flushing       BOOL
15
 
additional_mem_pool_size        ULINT
16
 
autoextend_increment    ULONG
17
 
buffer_pool_size        ULINT
18
 
checksums       BOOL
19
 
data_file_path  TEXT
20
 
data_home_dir   TEXT
21
 
doublewrite     BOOL
22
 
file_format     TEXT
23
 
file_io_threads ULINT
24
 
file_per_table  BOOL
25
 
flush_log_at_trx_commit ULONG
26
 
flush_method    TEXT
27
 
force_recovery  ULINT
28
 
io_capacity     ULONG
29
 
lock_wait_timeout       ULINT
30
 
log_buffer_size ULINT
31
 
log_file_size   ULINT
32
 
log_files_in_group      ULINT
33
 
log_group_home_dir      TEXT
34
 
max_dirty_pages_pct     ULONG
35
 
max_purge_lag   ULONG
36
 
lru_old_blocks_pct      ULINT
37
 
lru_block_access_recency        ULINT
38
 
open_files      ULINT
39
 
read_io_threads ULINT
40
 
write_io_threads        ULINT
41
 
pre_rollback_hook       CALLBACK
42
 
print_verbose_log       BOOL
43
 
rollback_on_timeout     BOOL
44
 
stats_sample_pages      ULINT
45
 
status_file     BOOL
46
 
sync_spin_loops ULONG
47
 
use_sys_malloc  BOOL
48
 
version TEXT
49
 
SELECT * FROM DATA_DICTIONARY.HAILDB_CONFIGURATION where NAME NOT IN ("VERSION");
50
 
NAME    TYPE    VALUE
51
 
adaptive_hash_index     BOOL    true
52
 
adaptive_flushing       BOOL    true
53
 
additional_mem_pool_size        ULINT   8388608
54
 
autoextend_increment    ULONG   8
55
 
buffer_pool_size        ULINT   134217728
56
 
checksums       BOOL    true
57
 
data_file_path  TEXT    NULL
58
 
data_home_dir   TEXT    ./
59
 
doublewrite     BOOL    true
60
 
file_format     TEXT    Barracuda
61
 
file_io_threads ULINT   10
62
 
file_per_table  BOOL    false
63
 
flush_log_at_trx_commit ULONG   1
64
 
flush_method    TEXT    fsync
65
 
force_recovery  ULINT   0
66
 
io_capacity     ULONG   200
67
 
lock_wait_timeout       ULINT   5
68
 
log_buffer_size ULINT   8388608
69
 
log_file_size   ULINT   20971520
70
 
log_files_in_group      ULINT   2
71
 
log_group_home_dir      TEXT    NULL
72
 
max_dirty_pages_pct     ULONG   75
73
 
max_purge_lag   ULONG   0
74
 
lru_old_blocks_pct      ULINT   37
75
 
lru_block_access_recency        ULINT   0
76
 
open_files      ULINT   300
77
 
read_io_threads ULINT   4
78
 
write_io_threads        ULINT   4
79
 
pre_rollback_hook       CALLBACK        NULL
80
 
print_verbose_log       BOOL    true
81
 
rollback_on_timeout     BOOL    false
82
 
stats_sample_pages      ULINT   8
83
 
status_file     BOOL    false
84
 
sync_spin_loops ULONG   30
85
 
use_sys_malloc  BOOL    true
86
 
SELECT NAME,VALUE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME IN ("data_file_path", "data_home_dir");
87
 
NAME    VALUE
88
 
data_file_path  NULL
89
 
data_home_dir   ./
90
 
SELECT NAME,VALUE FROM DATA_DICTIONARY.HAILDB_CONFIGURATION WHERE NAME = "file_per_table";
91
 
NAME    VALUE
92
 
file_per_table  false