1--source include/have_rocksdb.inc 2 3# 4# NOT NULL column attribute 5# 6 7######################################### 8# TODO: 9# Currently the test produces incorrect (?) result 10# due to bug MySQL:68472. If the bug is ever fixed, 11# the test and result files will need to be updated. 12######################################### 13 14 15let $extra_col_opts = NOT NULL; 16 17--echo ######################## 18--echo # BINARY columns 19--echo ######################## 20 21--source type_binary.inc 22--let $col_type = BINARY 23--let $col_default = 0 24--source col_not_null.inc 25 26--echo ######################## 27--echo # VARBINARY columns 28--echo ######################## 29 30--source type_varbinary.inc 31--let $col_type = VARBINARY(64) 32--let $col_default = 'test' 33--source col_not_null.inc 34 35--echo ######################## 36--echo # BIT columns 37--echo ######################## 38 39--source type_bit.inc 40--let $col_type = BIT 41--let $col_default = 1 42--source col_not_null.inc 43 44--echo ######################## 45--echo # BLOB columns 46--echo ######################## 47 48--source type_blob.inc 49 50--let $col_default = '' 51 52--let $col_type = BLOB 53--source col_not_null.inc 54 55--let $col_type = TINYBLOB 56--source col_not_null.inc 57 58--let $col_type = MEDIUMBLOB 59--source col_not_null.inc 60 61--let $col_type = LONGBLOB 62--source col_not_null.inc 63 64--echo ######################## 65--echo # BOOL columns 66--echo ######################## 67 68--source type_bool.inc 69--let $col_type = BOOL 70--let $col_default = '0' 71--source col_not_null.inc 72 73--echo ######################## 74--echo # CHAR columns 75--echo ######################## 76 77--source type_char.inc 78--let $col_type = CHAR 79--let $col_default = '_' 80--source col_not_null.inc 81 82--echo ######################## 83--echo # VARCHAR columns 84--echo ######################## 85 86--source type_varchar.inc 87--let $col_type = VARCHAR(64) 88--let $col_default = 'test default' 89--source col_not_null.inc 90 91--echo ######################## 92--echo # date and time columns 93--echo ######################## 94 95set @col_opt_not_nullsave_time_zone=@@time_zone; 96set time_zone='UTC'; 97 98--source type_date_time.inc 99 100SET TIMESTAMP=UNIX_TIMESTAMP('2013-12-12 12:12:12'); 101 102--let $col_type = DATE 103--let $col_default = '2012-12-21' 104--source col_not_null.inc 105 106--let $col_type = DATETIME 107--let $col_default = '2012-12-21 12:21:12' 108--source col_not_null.inc 109 110# Even with explicit-defaults-for-timestamps, we still can't use 111# the standard include file, due to bug MySQL:68472 112 113--let $col_type = TIMESTAMP 114--let $col_default = '2012-12-21 12:21:12' 115--source col_not_null_timestamp.inc 116 117--let $col_type = TIME 118--let $col_default = '12:21:12' 119--source col_not_null.inc 120 121--let $col_type = YEAR 122--let $col_default = '2012' 123--source col_not_null.inc 124 125--let $col_type = YEAR(2) 126--let $col_default = '12' 127--source col_not_null.inc 128 129set time_zone= @col_opt_not_nullsave_time_zone; 130 131--echo ######################## 132--echo # ENUM columns 133--echo ######################## 134 135--source type_enum.inc 136 137--let $col_type = ENUM('test1','test2','test3') 138--let $col_default = 'test2' 139--source col_not_null.inc 140 141--echo ######################## 142--echo # Fixed point columns (NUMERIC, DECIMAL) 143--echo ######################## 144 145--source type_fixed.inc 146 147--let $col_type = DECIMAL 148--let $col_default = 1.1 149--source col_not_null.inc 150 151--let $col_type = NUMERIC 152--let $col_default = 0 153--source col_not_null.inc 154 155--echo ######################## 156--echo # Floating point columns (FLOAT, DOUBLE) 157--echo ######################## 158 159--source type_float.inc 160 161--let $col_type = FLOAT 162--let $col_default = 1.1 163--source col_not_null.inc 164 165--let $col_type = DOUBLE 166--let $col_default = 0 167--source col_not_null.inc 168 169--echo ######################## 170--echo # INT columns 171--echo ######################## 172 173--source type_int.inc 174 175--let $col_type = INT 176--let $col_default = 2147483647 177--source col_not_null.inc 178 179--let $col_type = TINYINT 180--let $col_default = 127 181--source col_not_null.inc 182 183--let $col_type = SMALLINT 184--let $col_default = 0 185--source col_not_null.inc 186 187--let $col_type = MEDIUMINT 188--let $col_default = 1 189--source col_not_null.inc 190 191--let $col_type = BIGINT 192--let $col_default = 9223372036854775807 193--source col_not_null.inc 194 195--echo ######################## 196--echo # SET columns 197--echo ######################## 198 199--source type_set.inc 200--let $col_type = SET('test1','test2','test3') 201--let $col_default = 'test2,test3' 202--source col_not_null.inc 203 204--echo ######################## 205--echo # TEXT columns 206--echo ######################## 207 208--source type_text.inc 209 210--let $col_default = '' 211 212--let $col_type = TEXT 213--source col_not_null.inc 214 215--let $col_type = TINYTEXT 216--source col_not_null.inc 217 218--let $col_type = MEDIUMTEXT 219--source col_not_null.inc 220 221--let $col_type = LONGTEXT 222--source col_not_null.inc 223 224 225--let $col_type = 226--let $col_default = 227--let $extra_col_opts = 228 229 230