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 disconnect con2;
17 '#--------------------FN_DYNVARS_093_02-------------------------#'
18 connection con1;
19 DROP PROCEDURE IF EXISTS sp_addRec;
20 DROP TABLE IF EXISTS t1;
21 CREATE PROCEDURE sp_addRec(IN count INT)
22 BEGIN
23 WHILE (count>0) DO
24 INSERT INTO t1 value(1);
25 SET count = count -1;
26 END WHILE;
27 END //
28 SET @@global.myisam_data_pointer_size = 2;
29 CREATE TABLE t1(a INT);
30 CALL sp_addRec(65535);
31 CALL sp_addRec(1);
32 ERROR HY000: The table 't1' is full
33 SELECT count(*) from t1;
34 count(*)
35 65535
36 '--Checking myisam_data_pointer_size with MAX_ROWS table option--'
37 SET @@global.myisam_data_pointer_size = 2;
38 DROP TABLE IF EXISTS t1;
39 CREATE TABLE t1(a INT)MAX_ROWS=70000;
40 CALL sp_addRec(65536);
41 SELECT count(*) from t1;
42 count(*)
43 65536
44 DROP PROCEDURE sp_addRec;
45 DROP TABLE t1;
46 connection default;
47 SET @@global.myisam_data_pointer_size= @start_value;