← Back to branch summary

~ubuntu-branches/ubuntu/lucid/mysql-dfsg-5.1/lucid-security

« back to all changes in this revision

Viewing changes to mysql-test/suite/engines/funcs/r/ai_init_insert.result

  • Committer: Package Import Robot
  • Author(s): Marc Deslauriers
  • Date: 2012-02-22 22:33:55 UTC
  • mto: (1.2.1) (37.1.1 lucid-security)
  • mto: This revision was merged to the branch mainline in revision 36.
  • Revision ID: package-import@ubuntu.com-20120222223355-ku1tb4r70osci6v2
Tags: upstream-5.1.61
Import upstream version 5.1.61

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/suite/engines/funcs/r/ai_init_insert.result
 
1
DROP TABLE IF EXISTS t1;
 
2
create table t1 (c1 VARCHAR(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd', c2 INTEGER COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd',c3 INTEGER COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789', c4 INTEGER, c5 INTEGER, c6 INTEGER, c7 INTEGER, c8 VARCHAR(100), c9 CHAR(50), c10 DATETIME, c11 DATETIME, c12 DATETIME,c13 DATETIME, INDEX i1 (c1), INDEX i2(c2) 
 
3
) COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd';
 
4
Warnings:
 
5
Warning 1629    Comment for field 'c1' is too long (max = 255)
 
6
Warning 1629    Comment for field 'c2' is too long (max = 255)
 
7
Warning 1629    Comment for field 'c3' is too long (max = 255)
 
8
Warning 1628    Comment for table 't1' is too long (max = 60)
 
9
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
10
table_comment   char_length(table_comment)
 
11
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
12
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
13
column_comment  char_length(column_comment)
 
14
        0
 
15
        0
 
16
        0
 
17
        0
 
18
        0
 
19
        0
 
20
        0
 
21
        0
 
22
        0
 
23
        0
 
24
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
25
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
26
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
27
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
28
comment
 
29
 
 
30
 
 
31
SHOW CREATE TABLE t1;
 
32
Table   Create Table
 
33
t1      CREATE TABLE `t1` (
 
34
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
35
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
36
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
37
  `c4` int(11) DEFAULT NULL,
 
38
  `c5` int(11) DEFAULT NULL,
 
39
  `c6` int(11) DEFAULT NULL,
 
40
  `c7` int(11) DEFAULT NULL,
 
41
  `c8` varchar(100) DEFAULT NULL,
 
42
  `c9` char(50) DEFAULT NULL,
 
43
  `c10` datetime DEFAULT NULL,
 
44
  `c11` datetime DEFAULT NULL,
 
45
  `c12` datetime DEFAULT NULL,
 
46
  `c13` datetime DEFAULT NULL,
 
47
  KEY `i1` (`c1`),
 
48
  KEY `i2` (`c2`)
 
49
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
50
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
51
table_comment   char_length(table_comment)
 
52
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
53
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
54
column_comment  char_length(column_comment)
 
55
        0
 
56
        0
 
57
        0
 
58
        0
 
59
        0
 
60
        0
 
61
        0
 
62
        0
 
63
        0
 
64
        0
 
65
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
66
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
67
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
68
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
69
comment
 
70
 
 
71
 
 
72
SHOW CREATE TABLE t1;
 
73
Table   Create Table
 
74
t1      CREATE TABLE `t1` (
 
75
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
76
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
77
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
78
  `c4` int(11) DEFAULT NULL,
 
79
  `c5` int(11) DEFAULT NULL,
 
80
  `c6` int(11) DEFAULT NULL,
 
81
  `c7` int(11) DEFAULT NULL,
 
82
  `c8` varchar(100) DEFAULT NULL,
 
83
  `c9` char(50) DEFAULT NULL,
 
84
  `c10` datetime DEFAULT NULL,
 
85
  `c11` datetime DEFAULT NULL,
 
86
  `c12` datetime DEFAULT NULL,
 
87
  `c13` datetime DEFAULT NULL,
 
88
  KEY `i1` (`c1`),
 
89
  KEY `i2` (`c2`)
 
90
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
91
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
92
table_comment   char_length(table_comment)
 
93
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
94
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
95
column_comment  char_length(column_comment)
 
96
        0
 
97
        0
 
98
        0
 
99
        0
 
100
        0
 
101
        0
 
102
        0
 
103
        0
 
104
        0
 
105
        0
 
106
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
107
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
108
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
109
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
110
comment
 
111
 
 
112
 
 
113
SHOW CREATE TABLE t1;
 
114
Table   Create Table
 
115
t1      CREATE TABLE `t1` (
 
116
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
117
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
118
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
119
  `c4` int(11) DEFAULT NULL,
 
120
  `c5` int(11) DEFAULT NULL,
 
121
  `c6` int(11) DEFAULT NULL,
 
122
  `c7` int(11) DEFAULT NULL,
 
123
  `c8` varchar(100) DEFAULT NULL,
 
124
  `c9` char(50) DEFAULT NULL,
 
125
  `c10` datetime DEFAULT NULL,
 
126
  `c11` datetime DEFAULT NULL,
 
127
  `c12` datetime DEFAULT NULL,
 
128
  `c13` datetime DEFAULT NULL,
 
129
  KEY `i1` (`c1`),
 
130
  KEY `i2` (`c2`)
 
131
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
132
DROP INDEX i1 ON t1;
 
133
ALTER TABLE t1 DROP INDEX i2;
 
134
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
135
table_comment   char_length(table_comment)
 
136
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
137
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
138
column_comment  char_length(column_comment)
 
139
        0
 
140
        0
 
141
        0
 
142
        0
 
143
        0
 
144
        0
 
145
        0
 
146
        0
 
147
        0
 
148
        0
 
149
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
150
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
151
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
152
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
153
comment
 
154
SHOW CREATE TABLE t1;
 
155
Table   Create Table
 
156
t1      CREATE TABLE `t1` (
 
157
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
158
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
159
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
160
  `c4` int(11) DEFAULT NULL,
 
161
  `c5` int(11) DEFAULT NULL,
 
162
  `c6` int(11) DEFAULT NULL,
 
163
  `c7` int(11) DEFAULT NULL,
 
164
  `c8` varchar(100) DEFAULT NULL,
 
165
  `c9` char(50) DEFAULT NULL,
 
166
  `c10` datetime DEFAULT NULL,
 
167
  `c11` datetime DEFAULT NULL,
 
168
  `c12` datetime DEFAULT NULL,
 
169
  `c13` datetime DEFAULT NULL
 
170
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
171
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
172
table_comment   char_length(table_comment)
 
173
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
174
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
175
column_comment  char_length(column_comment)
 
176
        0
 
177
        0
 
178
        0
 
179
        0
 
180
        0
 
181
        0
 
182
        0
 
183
        0
 
184
        0
 
185
        0
 
186
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
187
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
188
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
189
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
190
comment
 
191
SHOW CREATE TABLE t1;
 
192
Table   Create Table
 
193
t1      CREATE TABLE `t1` (
 
194
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
195
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
196
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
197
  `c4` int(11) DEFAULT NULL,
 
198
  `c5` int(11) DEFAULT NULL,
 
199
  `c6` int(11) DEFAULT NULL,
 
200
  `c7` int(11) DEFAULT NULL,
 
201
  `c8` varchar(100) DEFAULT NULL,
 
202
  `c9` char(50) DEFAULT NULL,
 
203
  `c10` datetime DEFAULT NULL,
 
204
  `c11` datetime DEFAULT NULL,
 
205
  `c12` datetime DEFAULT NULL,
 
206
  `c13` datetime DEFAULT NULL
 
207
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
208
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
209
table_comment   char_length(table_comment)
 
210
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
211
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
212
column_comment  char_length(column_comment)
 
213
        0
 
214
        0
 
215
        0
 
216
        0
 
217
        0
 
218
        0
 
219
        0
 
220
        0
 
221
        0
 
222
        0
 
223
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
224
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
225
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
226
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
227
comment
 
228
SHOW CREATE TABLE t1;
 
229
Table   Create Table
 
230
t1      CREATE TABLE `t1` (
 
231
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
232
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
233
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
234
  `c4` int(11) DEFAULT NULL,
 
235
  `c5` int(11) DEFAULT NULL,
 
236
  `c6` int(11) DEFAULT NULL,
 
237
  `c7` int(11) DEFAULT NULL,
 
238
  `c8` varchar(100) DEFAULT NULL,
 
239
  `c9` char(50) DEFAULT NULL,
 
240
  `c10` datetime DEFAULT NULL,
 
241
  `c11` datetime DEFAULT NULL,
 
242
  `c12` datetime DEFAULT NULL,
 
243
  `c13` datetime DEFAULT NULL
 
244
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
245
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
246
table_comment   char_length(table_comment)
 
247
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
248
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
249
column_comment  char_length(column_comment)
 
250
        0
 
251
        0
 
252
        0
 
253
        0
 
254
        0
 
255
        0
 
256
        0
 
257
        0
 
258
        0
 
259
        0
 
260
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
261
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
262
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
263
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
264
comment
 
265
SHOW CREATE TABLE t1;
 
266
Table   Create Table
 
267
t1      CREATE TABLE `t1` (
 
268
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
269
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
270
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
271
  `c4` int(11) DEFAULT NULL,
 
272
  `c5` int(11) DEFAULT NULL,
 
273
  `c6` int(11) DEFAULT NULL,
 
274
  `c7` int(11) DEFAULT NULL,
 
275
  `c8` varchar(100) DEFAULT NULL,
 
276
  `c9` char(50) DEFAULT NULL,
 
277
  `c10` datetime DEFAULT NULL,
 
278
  `c11` datetime DEFAULT NULL,
 
279
  `c12` datetime DEFAULT NULL,
 
280
  `c13` datetime DEFAULT NULL
 
281
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
282
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
283
table_comment   char_length(table_comment)
 
284
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
285
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
286
column_comment  char_length(column_comment)
 
287
        0
 
288
        0
 
289
        0
 
290
        0
 
291
        0
 
292
        0
 
293
        0
 
294
        0
 
295
        0
 
296
        0
 
297
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
298
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
299
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
300
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
301
comment
 
302
SHOW CREATE TABLE t1;
 
303
Table   Create Table
 
304
t1      CREATE TABLE `t1` (
 
305
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
306
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
307
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
308
  `c4` int(11) DEFAULT NULL,
 
309
  `c5` int(11) DEFAULT NULL,
 
310
  `c6` int(11) DEFAULT NULL,
 
311
  `c7` int(11) DEFAULT NULL,
 
312
  `c8` varchar(100) DEFAULT NULL,
 
313
  `c9` char(50) DEFAULT NULL,
 
314
  `c10` datetime DEFAULT NULL,
 
315
  `c11` datetime DEFAULT NULL,
 
316
  `c12` datetime DEFAULT NULL,
 
317
  `c13` datetime DEFAULT NULL
 
318
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
319
set sql_mode='TRADITIONAL';
 
320
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
321
table_comment   char_length(table_comment)
 
322
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
323
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
324
column_comment  char_length(column_comment)
 
325
        0
 
326
        0
 
327
        0
 
328
        0
 
329
        0
 
330
        0
 
331
        0
 
332
        0
 
333
        0
 
334
        0
 
335
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
336
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
337
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
338
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
339
comment
 
340
SHOW CREATE TABLE t1;
 
341
Table   Create Table
 
342
t1      CREATE TABLE `t1` (
 
343
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
344
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
345
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
346
  `c4` int(11) DEFAULT NULL,
 
347
  `c5` int(11) DEFAULT NULL,
 
348
  `c6` int(11) DEFAULT NULL,
 
349
  `c7` int(11) DEFAULT NULL,
 
350
  `c8` varchar(100) DEFAULT NULL,
 
351
  `c9` char(50) DEFAULT NULL,
 
352
  `c10` datetime DEFAULT NULL,
 
353
  `c11` datetime DEFAULT NULL,
 
354
  `c12` datetime DEFAULT NULL,
 
355
  `c13` datetime DEFAULT NULL
 
356
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
357
set sql_mode='TRADITIONAL';
 
358
SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 
359
table_comment   char_length(table_comment)
 
360
ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij    60
 
361
SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 
362
column_comment  char_length(column_comment)
 
363
        0
 
364
        0
 
365
        0
 
366
        0
 
367
        0
 
368
        0
 
369
        0
 
370
        0
 
371
        0
 
372
        0
 
373
012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234 255
 
374
Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
375
aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde 255
 
376
SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 
377
comment
 
378
SHOW CREATE TABLE t1;
 
379
Table   Create Table
 
380
t1      CREATE TABLE `t1` (
 
381
  `c1` varchar(10) NOT NULL COMMENT 'Abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
382
  `c2` int(11) DEFAULT NULL COMMENT 'aBcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde',
 
383
  `c3` int(11) DEFAULT NULL COMMENT '012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234567890123456789012345678901234',
 
384
  `c4` int(11) DEFAULT NULL,
 
385
  `c5` int(11) DEFAULT NULL,
 
386
  `c6` int(11) DEFAULT NULL,
 
387
  `c7` int(11) DEFAULT NULL,
 
388
  `c8` varchar(100) DEFAULT NULL,
 
389
  `c9` char(50) DEFAULT NULL,
 
390
  `c10` datetime DEFAULT NULL,
 
391
  `c11` datetime DEFAULT NULL,
 
392
  `c12` datetime DEFAULT NULL,
 
393
  `c13` datetime DEFAULT NULL
 
394
) ENGINE=ENGINE DEFAULT CHARSET=latin1 COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij'
 
395
DROP TABLE t1;