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

   1 --disable_warnings
   2 DROP TABLE IF EXISTS t2;
   3 --enable_warnings
   4 CREATE TABLE t2(c1 CHAR(50) NULL);
   5 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  10 CREATE TABLE t2(c1 VARCHAR(50) NULL);
  11 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  16 CREATE TABLE t2(c1 BINARY(50) NULL);
  17 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  22 CREATE TABLE t2(c1 VARBINARY(50) NULL);
  23 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  28 CREATE TABLE t2(c1 CHAR(50) NOT NULL);
  29 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  34 CREATE TABLE t2(c1 VARCHAR(50) NOT NULL);
  35 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  40 CREATE TABLE t2(c1 BINARY(50) NOT NULL);
  41 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  46 CREATE TABLE t2(c1 VARBINARY(50) NOT NULL);
  47 CREATE INDEX i1 ON t2(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 t2; DROP TABLE t2; SHOW TABLES;
  52