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

   1 --disable_warnings
   2 DROP TABLE IF EXISTS t1;
   3 --enable_warnings
   4 CREATE TABLE t1(c1 BIT NULL);
   5 CREATE INDEX i1 ON t1(c1);
   6 SHOW TABLES;
   7 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
   8 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
   9  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  10 CREATE TABLE t1(c1 TINYINT NULL);
  11 CREATE INDEX i1 ON t1(c1);
  12 SHOW TABLES;
  13 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  14 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  15  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  16 CREATE TABLE t1(c1 SMALLINT NULL);
  17 CREATE INDEX i1 ON t1(c1);
  18 SHOW TABLES;
  19 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  20 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  21  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  22 CREATE TABLE t1(c1 MEDIUMINT NULL);
  23 CREATE INDEX i1 ON t1(c1);
  24 SHOW TABLES;
  25 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  26 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  27  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  28 CREATE TABLE t1(c1 INT NULL);
  29 CREATE INDEX i1 ON t1(c1);
  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 TABLE t1(c1 INTEGER NULL);
  35 CREATE INDEX i1 ON t1(c1);
  36 SHOW TABLES;
  37 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  38 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  39  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  40 CREATE TABLE t1(c1 BIGINT NULL);
  41 CREATE INDEX i1 ON t1(c1);
  42 SHOW TABLES;
  43 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  44 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  45  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  46 CREATE TABLE t1(c1 REAL NULL);
  47 CREATE INDEX i1 ON t1(c1);
  48 SHOW TABLES;
  49 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  50 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  51  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  52 CREATE TABLE t1(c1 DOUBLE NULL);
  53 CREATE INDEX i1 ON t1(c1);
  54 SHOW TABLES;
  55 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  56 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  57  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  58 CREATE TABLE t1(c1 FLOAT NULL);
  59 CREATE INDEX i1 ON t1(c1);
  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 TABLE t1(c1 DECIMAL NULL);
  65 CREATE INDEX i1 ON t1(c1);
  66 SHOW TABLES;
  67 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  68 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  69  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  70 CREATE TABLE t1(c1 NUMERIC NULL);
  71 CREATE INDEX i1 ON t1(c1);
  72 SHOW TABLES;
  73 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  74 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  75  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  76 CREATE TABLE t1(c1 DATE NULL);
  77 CREATE INDEX i1 ON t1(c1);
  78 SHOW TABLES;
  79 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  80 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  81  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  82 CREATE TABLE t1(c1 TIME NULL);
  83 CREATE INDEX i1 ON t1(c1);
  84 SHOW TABLES;
  85 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  86 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  87  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
  88 CREATE TABLE t1(c1 TIMESTAMP NULL);
  89 CREATE INDEX i1 ON t1(c1);
  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 TABLE t1(c1 YEAR NULL);
  95 CREATE INDEX i1 ON t1(c1);
  96 SHOW TABLES;
  97 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  98 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  99  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 100 CREATE TABLE t1(c1 BIT NOT NULL);
 101 CREATE INDEX i1 ON t1(c1);
 102 SHOW TABLES;
 103 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 104 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 105  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 106 CREATE TABLE t1(c1 TINYINT NOT NULL);
 107 CREATE INDEX i1 ON t1(c1);
 108 SHOW TABLES;
 109 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 110 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 111  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 112 CREATE TABLE t1(c1 SMALLINT NOT NULL);
 113 CREATE INDEX i1 ON t1(c1);
 114 SHOW TABLES;
 115 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 116 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 117  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 118 CREATE TABLE t1(c1 MEDIUMINT NOT NULL);
 119 CREATE INDEX i1 ON t1(c1);
 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 TABLE t1(c1 INT NOT NULL);
 125 CREATE INDEX i1 ON t1(c1);
 126 SHOW TABLES;
 127 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 128 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 129  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 130 CREATE TABLE t1(c1 INTEGER NOT NULL);
 131 CREATE INDEX i1 ON t1(c1);
 132 SHOW TABLES;
 133 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 134 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 135  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 136 CREATE TABLE t1(c1 BIGINT NOT NULL);
 137 CREATE INDEX i1 ON t1(c1);
 138 SHOW TABLES;
 139 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 140 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 141  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 142 CREATE TABLE t1(c1 REAL NOT NULL);
 143 CREATE INDEX i1 ON t1(c1);
 144 SHOW TABLES;
 145 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 146 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 147  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 148 CREATE TABLE t1(c1 DOUBLE NOT NULL);
 149 CREATE INDEX i1 ON t1(c1);
 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 TABLE t1(c1 FLOAT NOT NULL);
 155 CREATE INDEX i1 ON t1(c1);
 156 SHOW TABLES;
 157 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 158 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 159  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 160 CREATE TABLE t1(c1 DECIMAL NOT NULL);
 161 CREATE INDEX i1 ON t1(c1);
 162 SHOW TABLES;
 163 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 164 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 165  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 166 CREATE TABLE t1(c1 NUMERIC NOT NULL);
 167 CREATE INDEX i1 ON t1(c1);
 168 SHOW TABLES;
 169 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 170 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 171  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 172 CREATE TABLE t1(c1 DATE NOT NULL);
 173 CREATE INDEX i1 ON t1(c1);
 174 SHOW TABLES;
 175 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 176 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 177  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 178 CREATE TABLE t1(c1 TIME NOT NULL);
 179 CREATE INDEX i1 ON t1(c1);
 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 TABLE t1(c1 TIMESTAMP NOT NULL);
 185 CREATE INDEX i1 ON t1(c1);
 186 SHOW TABLES;
 187 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 188 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 189  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 190 CREATE TABLE t1(c1 YEAR NOT NULL);
 191 CREATE INDEX i1 ON t1(c1);
 192 SHOW TABLES;
 193 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 194 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 195  SHOW CREATE TABLE t1; DROP TABLE t1; SHOW TABLES;
 196