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

   1 --disable_warnings
   2 DROP TABLE IF EXISTS t1;
   3 --enable_warnings
   4 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)
   5 ) COMMENT='ABCDEFGHIJabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd';
   6
   7
   8 --sorted_result
   9 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  10
  11
  12 --sorted_result
  13 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  14
  15
  16 --sorted_result
  17 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  18 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  19 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  20 SHOW CREATE TABLE t1;
  21
  22
  23 --sorted_result
  24 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  25
  26
  27 --sorted_result
  28 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  29
  30
  31 --sorted_result
  32 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  33 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  34 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  35 SHOW CREATE TABLE t1;
  36
  37
  38 --sorted_result
  39 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  40
  41
  42 --sorted_result
  43 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  44
  45
  46 --sorted_result
  47 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  48 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  49 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  50 SHOW CREATE TABLE t1;
  51
  52 DROP INDEX i1 ON t1;
  53 ALTER TABLE t1 DROP INDEX i2;
  54
  55
  56 --sorted_result
  57 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  58
  59
  60 --sorted_result
  61 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  62
  63
  64 --sorted_result
  65 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  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;
  69
  70 --sorted_result
  71 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  72
  73
  74 --sorted_result
  75 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  76
  77
  78 --sorted_result
  79 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  80 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  81 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  82 SHOW CREATE TABLE t1;
  83
  84
  85 --sorted_result
  86 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
  87
  88
  89 --sorted_result
  90 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
  91
  92
  93 --sorted_result
  94 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
  95 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
  96 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
  97 SHOW CREATE TABLE t1;
  98
  99
 100 --sorted_result
 101 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 102
 103
 104 --sorted_result
 105 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 106
 107
 108 --sorted_result
 109 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 110 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 111 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 112 SHOW CREATE TABLE t1;
 113
 114 --sorted_result
 115 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 116
 117
 118 --sorted_result
 119 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 120
 121
 122 --sorted_result
 123 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 124 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 125 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 126 SHOW CREATE TABLE t1;
 127
 128
 129
 130
 131 set sql_mode='TRADITIONAL';
 132
 133
 134 --sorted_result
 135 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 136
 137
 138 --sorted_result
 139 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 140
 141
 142 --sorted_result
 143 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 144 let $ENGINE=`select variable_value from information_schema.global_variables where variable_name='STORAGE_ENGINE'`;
 145 --replace_result $ENGINE ENGINE " PAGE_CHECKSUM=0" ""
 146 SHOW CREATE TABLE t1;
 147
 148
 149 set sql_mode='TRADITIONAL';
 150
 151 --sorted_result
 152 SELECT table_comment,char_length(table_comment) FROM information_schema.tables WHERE table_name='t1';
 153
 154
 155 --sorted_result
 156 SELECT column_comment,char_length(column_comment) FROM information_schema.columns WHERE table_name='t1';
 157
 158
 159 --sorted_result
 160 SELECT comment FROM information_schema.statistics WHERE table_name='t1';
 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;
 164 DROP TABLE t1;
 165