1call mtr.add_suppression("The table 't1' is full"); 2'#--------------------FN_DYNVARS_093_01-------------------------#' 3SET @start_value= @@global.myisam_data_pointer_size; 4SET @@global.myisam_data_pointer_size = 2; 5'connect (con1,localhost,root,,,,)' 6'connection con1' 7SELECT @@global.myisam_data_pointer_size; 8@@global.myisam_data_pointer_size 92 10SET @@global.myisam_data_pointer_size = 3; 11'connect (con2,localhost,root,,,,)' 12'connection con2' 13SELECT @@global.myisam_data_pointer_size; 14@@global.myisam_data_pointer_size 153 16'#--------------------FN_DYNVARS_093_02-------------------------#' 17'connection con1' 18DROP PROCEDURE IF EXISTS sp_addRec; 19DROP TABLE IF EXISTS t1; 20CREATE PROCEDURE sp_addRec(IN count INT) 21BEGIN 22WHILE (count>0) DO 23INSERT INTO t1 value(1); 24SET count = count -1; 25END WHILE; 26END // 27SET @@global.myisam_data_pointer_size = 2; 28CREATE TABLE t1(a INT); 29CALL sp_addRec(65535); 30CALL sp_addRec(1); 31ERROR HY000: The table 't1' is full 32SELECT count(*) from t1; 33count(*) 3465535 35'--Checking myisam_data_pointer_size with MAX_ROWS table option--' 36SET @@global.myisam_data_pointer_size = 2; 37DROP TABLE IF EXISTS t1; 38CREATE TABLE t1(a INT)MAX_ROWS=70000; 39CALL sp_addRec(65536); 40SELECT count(*) from t1; 41count(*) 4265536 43DROP PROCEDURE sp_addRec; 44DROP TABLE t1; 45SET @@global.myisam_data_pointer_size= @start_value; 46