← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/comment_index.test

  • Committer: Brian Aker
  • Date: 2010-02-17 01:56:39 UTC
  • mfrom: (1273.13.69 build)
  • Revision ID: brian@gaz-20100217015639-ou3s722vekucn5fd
Many updates. Brian, Monty.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/comment_index.test
6
6
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
7
7
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
8
8
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
9
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
9
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
10
10
--replace_result $ENGINE ENGINE
11
11
SHOW CREATE TABLE t1;
12
12
 
15
15
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
16
16
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
17
17
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
18
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
18
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
19
19
--replace_result $ENGINE ENGINE
20
20
SHOW CREATE TABLE t1;
21
21
 
24
24
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
25
25
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
26
26
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
27
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
27
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
28
28
--replace_result $ENGINE ENGINE
29
29
SHOW CREATE TABLE t1;
30
30
 
33
33
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
34
34
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
35
35
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
36
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
36
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
37
37
--replace_result $ENGINE ENGINE
38
38
SHOW CREATE TABLE t1;
39
39
 
41
41
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
42
42
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
43
43
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
44
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
44
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
45
45
--replace_result $ENGINE ENGINE
46
46
SHOW CREATE TABLE t1;
47
47
 
51
51
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
52
52
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
53
53
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
54
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
54
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
55
55
--replace_result $ENGINE ENGINE
56
56
SHOW CREATE TABLE t1;
57
57
 
62
62
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
63
63
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
64
64
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
65
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
65
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
66
66
--replace_result $ENGINE ENGINE
67
67
SHOW CREATE TABLE t1;
68
68
 
71
71
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
72
72
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
73
73
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
74
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
74
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
75
75
--replace_result $ENGINE ENGINE
76
76
SHOW CREATE TABLE t1;
77
77
 
83
83
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
84
84
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
85
85
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
86
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
86
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
87
87
--replace_result $ENGINE ENGINE
88
88
SHOW CREATE TABLE t1;
89
89
 
93
93
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
94
94
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
95
95
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
96
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
96
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
97
97
--replace_result $ENGINE ENGINE
98
98
SHOW CREATE TABLE t1;
99
99