1255
1255
SELECT @@skip_name_resolve;
1256
1256
SHOW VARIABLES LIKE 'skip_name_resolve';
1259
--echo # Bug #43233 : Some server variables are clipped during "update,"
1260
--echo # not "check" stage
1263
SET @kbs=@@global.key_buffer_size;
1264
SET @kcbs=@@global.key_cache_block_size;
1266
--echo throw errors in STRICT mode
1267
SET SQL_MODE=STRICT_ALL_TABLES;
1269
# sys_var_ulonglong_ptr: sys_max_binlog_cache_size
1270
--error ER_WRONG_VALUE_FOR_VAR
1271
SET @@global.max_binlog_cache_size=-1;
1273
# sys_var_thd_ha_rows: "max_join_size" et al.
1274
--error ER_WRONG_VALUE_FOR_VAR
1275
SET @@global.max_join_size=0;
1277
# sys_var_key_buffer_size: "key_buffer_size"
1278
--error ER_WARN_CANT_DROP_DEFAULT_KEYCACHE
1279
SET @@global.key_buffer_size=0;
1281
# sys_var_key_cache_long: "key_cache_block_size" et al.
1282
--error ER_WRONG_VALUE_FOR_VAR
1283
SET @@global.key_cache_block_size=0;
1285
--echo throw warnings in default mode
1286
SET SQL_MODE=DEFAULT;
1288
SET @@global.max_binlog_cache_size=-1;
1289
SET @@global.max_join_size=0;
1290
# this is an exception. since this is a new error/warning, let's stay
1291
# compatible with the upcoming 5.6.
1292
--error ER_WARN_CANT_DROP_DEFAULT_KEYCACHE
1293
SET @@global.key_buffer_size=0;
1294
SET @@global.key_cache_block_size=0;
1297
# Bug#56976: added new start-up parameter
1299
select @@max_long_data_size;
1302
--echo # Bug#11766424 59527: DECIMAL_BIN_SIZE: ASSERTION `SCALE >= 0 && PRECISION > 0 && SCALE <= PRE
1305
CREATE TABLE t1(f1 DECIMAL(1,1) UNSIGNED);
1306
INSERT INTO t1 VALUES (0.2),(0.1);
1307
SELECT 1 FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE @a=f1);
1310
CREATE TABLE t1 AS SELECT @a:= CAST(1 AS UNSIGNED) AS a;
1311
SHOW CREATE TABLE t1;
1315
SET @@global.max_binlog_cache_size=DEFAULT;
1316
SET @@global.max_join_size=DEFAULT;
1317
SET @@global.key_buffer_size=@kbs;
1318
SET @@global.key_cache_block_size=@kcbs;
1258
1321
--echo End of 5.1 tests