Debian Codegraph @

mysql-test/suite/sys_vars/r/myisam_data_pointer_size_func.result

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