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