← Back to branch summary

~drizzle-trunk/drizzle/development

« back to all changes in this revision

Viewing changes to tests/t/comment_column.test

Updates for DD.

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/t/comment_column.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
 
14
14
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
15
15
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
16
16
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
17
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
17
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
18
18
--replace_result $ENGINE ENGINE
19
19
SHOW CREATE TABLE t1;
20
20
 
23
23
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
24
24
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
25
25
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
26
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
26
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
27
27
--replace_result $ENGINE ENGINE
28
28
SHOW CREATE TABLE t1;
29
29
 
32
32
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
33
33
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
34
34
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
35
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
35
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
36
36
--replace_result $ENGINE ENGINE
37
37
SHOW CREATE TABLE t1;
38
38
 
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
ALTER TABLE t1 CHANGE COLUMN c9 c9_1 INTEGER COMMENT '1234567890';
48
48
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
49
49
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
50
50
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
51
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
51
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
52
52
--replace_result $ENGINE ENGINE
53
53
SHOW CREATE TABLE t1;
54
54
 
56
56
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
57
57
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
58
58
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
59
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
59
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
60
60
--replace_result $ENGINE ENGINE
61
61
SHOW CREATE TABLE t1;
62
62
 
67
67
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
68
68
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
69
69
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
70
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
70
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
71
71
--replace_result $ENGINE ENGINE
72
72
SHOW CREATE TABLE t1;
73
73
 
77
77
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
78
78
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
79
79
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
80
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
80
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
81
81
--replace_result $ENGINE ENGINE
82
82
SHOW CREATE TABLE t1;
83
83
 
85
85
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
86
86
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
87
87
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
88
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
88
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
89
89
--replace_result $ENGINE ENGINE
90
90
SHOW CREATE TABLE t1;
91
91
 
98
98
SELECT table_comment,char_length(table_comment) FROM data_dictionary.tables WHERE table_name='t1';
99
99
SELECT column_comment,char_length(column_comment) FROM information_schema.old_columns WHERE table_name='t1';
100
100
SELECT comment,index_comment,char_length(index_comment) FROM information_schema.old_statistics WHERE table_name='t1';
101
 
let $ENGINE=`select variable_value from information_schema.old_global_variables where variable_name='STORAGE_ENGINE'`;
 
101
let $ENGINE=`select variable_value from data_dictionary.global_variables where variable_name='STORAGE_ENGINE'`;
102
102
--replace_result $ENGINE ENGINE
103
103
--error 1146
104
104
SHOW CREATE TABLE t1;