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

   1 --disable_warnings
   2 DROP TABLE IF EXISTS t1;
   3 --enable_warnings
   4 CREATE TEMPORARY TABLE t1(c1 BIT 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 t1; DROP TABLE t1; SHOW TABLES;
   9 CREATE TEMPORARY TABLE t1(c1 TINYINT 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 t1; DROP TABLE t1; SHOW TABLES;
  14 CREATE TEMPORARY TABLE t1(c1 SMALLINT 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 t1; DROP TABLE t1; SHOW TABLES;
  19 CREATE TEMPORARY TABLE t1(c1 MEDIUMINT 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 t1; DROP TABLE t1; SHOW TABLES;
  24 CREATE TEMPORARY TABLE t1(c1 INT 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 t1; DROP TABLE t1; SHOW TABLES;
  29 CREATE TEMPORARY TABLE t1(c1 INTEGER 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 t1; DROP TABLE t1; SHOW TABLES;
  34 CREATE TEMPORARY TABLE t1(c1 BIGINT 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 t1; DROP TABLE t1; SHOW TABLES;
  39 CREATE TEMPORARY TABLE t1(c1 DECIMAL 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 t1; DROP TABLE t1; SHOW TABLES;
  44 CREATE TEMPORARY TABLE t1(c1 DEC 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 t1; DROP TABLE t1; SHOW TABLES;
  49 CREATE TEMPORARY TABLE t1(c1 FIXED 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 t1; DROP TABLE t1; SHOW TABLES;
  54 CREATE TEMPORARY TABLE t1(c1 NUMERIC 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 t1; DROP TABLE t1; SHOW TABLES;
  59 CREATE TEMPORARY TABLE t1(c1 DOUBLE 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 t1; DROP TABLE t1; SHOW TABLES;
  64 CREATE TEMPORARY TABLE t1(c1 REAL 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 t1; DROP TABLE t1; SHOW TABLES;
  69 CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION 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 t1; DROP TABLE t1; SHOW TABLES;
  74 CREATE TEMPORARY TABLE t1(c1 FLOAT 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 t1; DROP TABLE t1; SHOW TABLES;
  79 CREATE TEMPORARY TABLE t1(c1 DATE 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 t1; DROP TABLE t1; SHOW TABLES;
  84 CREATE TEMPORARY TABLE t1(c1 TIME 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 t1; DROP TABLE t1; SHOW TABLES;
  89 CREATE TEMPORARY TABLE t1(c1 TIMESTAMP 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 t1; DROP TABLE t1; SHOW TABLES;
  94 CREATE TEMPORARY TABLE t1(c1 DATETIME 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 t1; DROP TABLE t1; SHOW TABLES;
  99 CREATE TEMPORARY TABLE t1(c1 YEAR 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 t1; DROP TABLE t1; SHOW TABLES;
 104 CREATE TEMPORARY TABLE t1(c1 TINYBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 109 CREATE TEMPORARY TABLE t1(c1 BLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 114 CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 119 CREATE TEMPORARY TABLE t1(c1 LONGBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 124 CREATE TEMPORARY TABLE t1(c1 TINYTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 129 CREATE TEMPORARY TABLE t1(c1 TEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 134 CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 139 CREATE TEMPORARY TABLE t1(c1 LONGTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 144 CREATE TEMPORARY TABLE t1(c1 BIT 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 t1; DROP TABLE t1; SHOW TABLES;
 149 CREATE TEMPORARY TABLE t1(c1 TINYINT 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 t1; DROP TABLE t1; SHOW TABLES;
 154 CREATE TEMPORARY TABLE t1(c1 SMALLINT 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 t1; DROP TABLE t1; SHOW TABLES;
 159 CREATE TEMPORARY TABLE t1(c1 MEDIUMINT 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 t1; DROP TABLE t1; SHOW TABLES;
 164 CREATE TEMPORARY TABLE t1(c1 INT 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 t1; DROP TABLE t1; SHOW TABLES;
 169 CREATE TEMPORARY TABLE t1(c1 INTEGER 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 t1; DROP TABLE t1; SHOW TABLES;
 174 CREATE TEMPORARY TABLE t1(c1 BIGINT 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 t1; DROP TABLE t1; SHOW TABLES;
 179 CREATE TEMPORARY TABLE t1(c1 DECIMAL 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 t1; DROP TABLE t1; SHOW TABLES;
 184 CREATE TEMPORARY TABLE t1(c1 DEC 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 t1; DROP TABLE t1; SHOW TABLES;
 189 CREATE TEMPORARY TABLE t1(c1 FIXED 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 t1; DROP TABLE t1; SHOW TABLES;
 194 CREATE TEMPORARY TABLE t1(c1 NUMERIC 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 t1; DROP TABLE t1; SHOW TABLES;
 199 CREATE TEMPORARY TABLE t1(c1 DOUBLE 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 t1; DROP TABLE t1; SHOW TABLES;
 204 CREATE TEMPORARY TABLE t1(c1 REAL 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 t1; DROP TABLE t1; SHOW TABLES;
 209 CREATE TEMPORARY TABLE t1(c1 DOUBLE PRECISION 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 t1; DROP TABLE t1; SHOW TABLES;
 214 CREATE TEMPORARY TABLE t1(c1 FLOAT 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 t1; DROP TABLE t1; SHOW TABLES;
 219 CREATE TEMPORARY TABLE t1(c1 DATE 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 t1; DROP TABLE t1; SHOW TABLES;
 224 CREATE TEMPORARY TABLE t1(c1 TIME 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 t1; DROP TABLE t1; SHOW TABLES;
 229 CREATE TEMPORARY TABLE t1(c1 TIMESTAMP 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 t1; DROP TABLE t1; SHOW TABLES;
 234 CREATE TEMPORARY TABLE t1(c1 DATETIME 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 t1; DROP TABLE t1; SHOW TABLES;
 239 CREATE TEMPORARY TABLE t1(c1 YEAR 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 t1; DROP TABLE t1; SHOW TABLES;
 244 CREATE TEMPORARY TABLE t1(c1 TINYBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 249 CREATE TEMPORARY TABLE t1(c1 BLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 254 CREATE TEMPORARY TABLE t1(c1 MEDIUMBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 259 CREATE TEMPORARY TABLE t1(c1 LONGBLOB 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 t1; DROP TABLE t1; SHOW TABLES;
 264 CREATE TEMPORARY TABLE t1(c1 TINYTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 269 CREATE TEMPORARY TABLE t1(c1 TEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 274 CREATE TEMPORARY TABLE t1(c1 MEDIUMTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 279 CREATE TEMPORARY TABLE t1(c1 LONGTEXT 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 t1; DROP TABLE t1; SHOW TABLES;
 284