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