release/src/router/mysql/mysql-test/suite/engines/funcs/t/tc_column_zerofill.test

   1 --disable_warnings
   2 DROP TABLE IF EXISTS t4;
   3 --enable_warnings
   4 CREATE TABLE t4(c1 TINYINT   ZEROFILL NULL);
   5 SHOW TABLES;
   6 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
   7 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
   8 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
   9 CREATE TABLE t4(c1 SMALLINT   ZEROFILL NULL);
  10 SHOW TABLES;
  11 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  12 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  13 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  14 CREATE TABLE t4(c1 MEDIUMINT   ZEROFILL NULL);
  15 SHOW TABLES;
  16 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  17 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  18 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  19 CREATE TABLE t4(c1 INT   ZEROFILL NULL);
  20 SHOW TABLES;
  21 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  22 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  23 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  24 CREATE TABLE t4(c1 INTEGER   ZEROFILL NULL);
  25 SHOW TABLES;
  26 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  27 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  28 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  29 CREATE TABLE t4(c1 BIGINT   ZEROFILL NULL);
  30 SHOW TABLES;
  31 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  32 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  33 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  34 CREATE TABLE t4(c1 DECIMAL   ZEROFILL NULL);
  35 SHOW TABLES;
  36 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  37 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  38 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  39 CREATE TABLE t4(c1 DEC   ZEROFILL NULL);
  40 SHOW TABLES;
  41 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  42 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  43 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  44 CREATE TABLE t4(c1 FIXED   ZEROFILL NULL);
  45 SHOW TABLES;
  46 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  47 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  48 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  49 CREATE TABLE t4(c1 NUMERIC   ZEROFILL NULL);
  50 SHOW TABLES;
  51 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  52 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  53 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  54 CREATE TABLE t4(c1 DOUBLE   ZEROFILL NULL);
  55 SHOW TABLES;
  56 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  57 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  58 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  59 CREATE TABLE t4(c1 REAL   ZEROFILL NULL);
  60 SHOW TABLES;
  61 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  62 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  63 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  64 CREATE TABLE t4(c1 DOUBLE PRECISION   ZEROFILL NULL);
  65 SHOW TABLES;
  66 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  67 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  68 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  69 CREATE TABLE t4(c1 FLOAT   ZEROFILL NULL);
  70 SHOW TABLES;
  71 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  72 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  73 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  74 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NULL);
  75 SHOW TABLES;
  76 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  77 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  78 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  79 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NULL);
  80 SHOW TABLES;
  81 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  82 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  83 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  84 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NULL);
  85 SHOW TABLES;
  86 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  87 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  88 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  89 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NULL);
  90 SHOW TABLES;
  91 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  92 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  93 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  94 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NULL);
  95 SHOW TABLES;
  96 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  97 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  98 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
  99 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NULL);
 100 SHOW TABLES;
 101 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 102 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 103 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 104 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NULL);
 105 SHOW TABLES;
 106 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 107 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 108 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 109 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NULL);
 110 SHOW TABLES;
 111 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 112 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 113 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 114 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NULL);
 115 SHOW TABLES;
 116 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 117 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 118 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 119 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NULL);
 120 SHOW TABLES;
 121 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 122 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 123 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 124 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NULL);
 125 SHOW TABLES;
 126 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 127 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 128 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 129 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NULL);
 130 SHOW TABLES;
 131 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 132 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 133 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 134 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NULL);
 135 SHOW TABLES;
 136 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 137 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 138 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 139 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NULL);
 140 SHOW TABLES;
 141 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 142 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 143 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 144 CREATE TABLE t4(c1 TINYINT   ZEROFILL NOT NULL);
 145 SHOW TABLES;
 146 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 147 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 148 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 149 CREATE TABLE t4(c1 SMALLINT   ZEROFILL NOT NULL);
 150 SHOW TABLES;
 151 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 152 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 153 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 154 CREATE TABLE t4(c1 MEDIUMINT   ZEROFILL NOT NULL);
 155 SHOW TABLES;
 156 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 157 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 158 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 159 CREATE TABLE t4(c1 INT   ZEROFILL NOT NULL);
 160 SHOW TABLES;
 161 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 162 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 163 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 164 CREATE TABLE t4(c1 INTEGER   ZEROFILL NOT NULL);
 165 SHOW TABLES;
 166 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 167 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 168 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 169 CREATE TABLE t4(c1 BIGINT   ZEROFILL NOT NULL);
 170 SHOW TABLES;
 171 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 172 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 173 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 174 CREATE TABLE t4(c1 DECIMAL   ZEROFILL NOT NULL);
 175 SHOW TABLES;
 176 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 177 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 178 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 179 CREATE TABLE t4(c1 DEC   ZEROFILL NOT NULL);
 180 SHOW TABLES;
 181 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 182 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 183 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 184 CREATE TABLE t4(c1 FIXED   ZEROFILL NOT NULL);
 185 SHOW TABLES;
 186 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 187 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 188 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 189 CREATE TABLE t4(c1 NUMERIC   ZEROFILL NOT NULL);
 190 SHOW TABLES;
 191 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 192 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 193 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 194 CREATE TABLE t4(c1 DOUBLE   ZEROFILL NOT NULL);
 195 SHOW TABLES;
 196 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 197 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 198 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 199 CREATE TABLE t4(c1 REAL   ZEROFILL NOT NULL);
 200 SHOW TABLES;
 201 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 202 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 203 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 204 CREATE TABLE t4(c1 DOUBLE PRECISION   ZEROFILL NOT NULL);
 205 SHOW TABLES;
 206 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 207 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 208 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 209 CREATE TABLE t4(c1 FLOAT   ZEROFILL NOT NULL);
 210 SHOW TABLES;
 211 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 212 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 213 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 214 CREATE TABLE t4(c1 TINYINT UNSIGNED ZEROFILL NOT NULL);
 215 SHOW TABLES;
 216 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 217 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 218 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 219 CREATE TABLE t4(c1 SMALLINT UNSIGNED ZEROFILL NOT NULL);
 220 SHOW TABLES;
 221 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 222 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 223 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 224 CREATE TABLE t4(c1 MEDIUMINT UNSIGNED ZEROFILL NOT NULL);
 225 SHOW TABLES;
 226 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 227 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 228 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 229 CREATE TABLE t4(c1 INT UNSIGNED ZEROFILL NOT NULL);
 230 SHOW TABLES;
 231 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 232 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 233 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 234 CREATE TABLE t4(c1 INTEGER UNSIGNED ZEROFILL NOT NULL);
 235 SHOW TABLES;
 236 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 237 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 238 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 239 CREATE TABLE t4(c1 BIGINT UNSIGNED ZEROFILL NOT NULL);
 240 SHOW TABLES;
 241 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 242 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 243 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 244 CREATE TABLE t4(c1 DECIMAL UNSIGNED ZEROFILL NOT NULL);
 245 SHOW TABLES;
 246 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 247 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 248 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 249 CREATE TABLE t4(c1 DEC UNSIGNED ZEROFILL NOT NULL);
 250 SHOW TABLES;
 251 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 252 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 253 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 254 CREATE TABLE t4(c1 FIXED UNSIGNED ZEROFILL NOT NULL);
 255 SHOW TABLES;
 256 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 257 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 258 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 259 CREATE TABLE t4(c1 NUMERIC UNSIGNED ZEROFILL NOT NULL);
 260 SHOW TABLES;
 261 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 262 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 263 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 264 CREATE TABLE t4(c1 DOUBLE UNSIGNED ZEROFILL NOT NULL);
 265 SHOW TABLES;
 266 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 267 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 268 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 269 CREATE TABLE t4(c1 REAL UNSIGNED ZEROFILL NOT NULL);
 270 SHOW TABLES;
 271 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 272 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 273 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 274 CREATE TABLE t4(c1 DOUBLE PRECISION UNSIGNED ZEROFILL NOT NULL);
 275 SHOW TABLES;
 276 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 277 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 278 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 279 CREATE TABLE t4(c1 FLOAT UNSIGNED ZEROFILL NOT NULL);
 280 SHOW TABLES;
 281 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 282 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 283 SHOW CREATE TABLE t4; DROP TABLE t4; SHOW TABLES;
 284