280
280
set global net_buffer_length=2000000000;
282
282
Warning 1292 Truncated incorrect net_buffer_length value: '2000000000'
283
Warning 1105 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
283
284
show global variables like 'net_buffer_length';
284
285
Variable_name Value
285
286
net_buffer_length 1048576
502
503
set global max_allowed_packet=100;
504
505
Warning 1292 Truncated incorrect max_allowed_packet value: '100'
506
Warning 1105 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
505
507
set global max_binlog_cache_size=100;
507
509
Warning 1292 Truncated incorrect max_binlog_cache_size value: '100'
1059
1061
set global myisam_data_pointer_size =@my_myisam_data_pointer_size;
1060
1062
set global myisam_max_sort_file_size =@my_myisam_max_sort_file_size;
1061
1063
set global net_buffer_length =@my_net_buffer_length;
1065
Warning 1105 The value of 'max_allowed_packet' should be no less than the value of 'net_buffer_length'
1062
1066
set global net_write_timeout =@my_net_write_timeout;
1063
1067
set global net_read_timeout =@my_net_read_timeout;
1064
1068
set global query_cache_limit =@my_query_cache_limit;
1511
1515
SHOW VARIABLES LIKE 'skip_name_resolve';
1512
1516
Variable_name Value
1513
1517
skip_name_resolve OFF
1519
# Bug #43233 : Some server variables are clipped during "update,"
1522
SET @kbs=@@global.key_buffer_size;
1523
SET @kcbs=@@global.key_cache_block_size;
1524
throw errors in STRICT mode
1525
SET SQL_MODE=STRICT_ALL_TABLES;
1526
SET @@global.max_binlog_cache_size=-1;
1527
ERROR 42000: Variable 'max_binlog_cache_size' can't be set to the value of '-1'
1528
SET @@global.max_join_size=0;
1529
ERROR 42000: Variable 'max_join_size' can't be set to the value of '0'
1530
SET @@global.key_buffer_size=0;
1531
ERROR HY000: Cannot drop default keycache
1532
SET @@global.key_cache_block_size=0;
1533
ERROR 42000: Variable 'key_cache_block_size' can't be set to the value of '0'
1534
throw warnings in default mode
1535
SET SQL_MODE=DEFAULT;
1536
SET @@global.max_binlog_cache_size=-1;
1538
Warning 1292 Truncated incorrect max_binlog_cache_size value: '-1'
1539
SET @@global.max_join_size=0;
1541
Warning 1292 Truncated incorrect max_join_size value: '0'
1542
SET @@global.key_buffer_size=0;
1543
ERROR HY000: Cannot drop default keycache
1544
SET @@global.key_cache_block_size=0;
1546
Warning 1292 Truncated incorrect key_cache_block_size value: '0'
1547
select @@max_long_data_size;
1548
@@max_long_data_size
1551
# Bug#11766424 59527: DECIMAL_BIN_SIZE: ASSERTION `SCALE >= 0 && PRECISION > 0 && SCALE <= PRE
1553
CREATE TABLE t1(f1 DECIMAL(1,1) UNSIGNED);
1554
INSERT INTO t1 VALUES (0.2),(0.1);
1555
SELECT 1 FROM t1 GROUP BY @a:= (SELECT ROUND(f1) FROM t1 WHERE @a=f1);
1559
CREATE TABLE t1 AS SELECT @a:= CAST(1 AS UNSIGNED) AS a;
1560
SHOW CREATE TABLE t1;
1562
t1 CREATE TABLE `t1` (
1563
`a` int(1) unsigned NOT NULL DEFAULT '0'
1564
) ENGINE=MyISAM DEFAULT CHARSET=latin1
1566
SET @@global.max_binlog_cache_size=DEFAULT;
1567
SET @@global.max_join_size=DEFAULT;
1568
SET @@global.key_buffer_size=@kbs;
1569
SET @@global.key_cache_block_size=@kcbs;
1514
1570
End of 5.1 tests