Debian Codegraph @

mysql-test/suite/innodb/t/innodb_prefix_index_restart_server.test

raw
1 --source include/have_innodb.inc
2 ######## suite/innodb/t/innodb_prefix_iindex_restart_server.test #####
3 # #
4 # Testcase for worklog WL#5743: Lift the limit of index key prefixes #
5 # Test scenario : Stop the server in between when prefix index are #
6 # created and see if state is preserved after restart #
7 # #
8 # Creation: #
9 # 2011-06-02 Implemented this test as part of WL#5743 #
10 # #
11 ######################################################################
12
13 # Embedded server tests do not support restarting
14 --source include/not_embedded.inc
15 --source include/test_db_charset_latin1.inc
16
17 #------------------------------------------------------------------------------
18 # Stop the server in between when prefix index are created and see if state is
19 # correct when server is restarted.
20 # Server is restarted at differnt points.
21
22 CREATE TABLE worklog5743 (
23 col_1_text TEXT(4000) , col_2_text TEXT(4000) ,
24 PRIMARY KEY (col_1_text(3072))
25 ) ROW_FORMAT=DYNAMIC, engine = innodb;
26 INSERT INTO worklog5743 VALUES(REPEAT("a", 3500) , REPEAT("o", 3500));
27 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
28 worklog5743;
29
30 --connect (con1,localhost,root,,)
31 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
32 worklog5743;
33 SELECT COUNT(*) FROM worklog5743;
34
35
36 --connect (con2,localhost,root,,)
37 START TRANSACTION;
38 INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500));
39
40
41 --connection con1
42 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
43 worklog5743;
44 SELECT COUNT(*) FROM worklog5743;
45 START TRANSACTION;
46
47
48 --connection default
49 # Restart the server
50 SET GLOBAL innodb_fast_shutdown=3;
51 -- source include/restart_mysqld.inc
52 SELECT COUNT(*) FROM worklog5743;
53 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
54 worklog5743;
55
56 --disconnect con1
57 --disconnect con2
58
59 --connect (con1,localhost,root,,)
60 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
61 worklog5743;
62 SELECT COUNT(*) FROM worklog5743;
63 START TRANSACTION;
64 INSERT INTO worklog5743 VALUES(REPEAT("b", 3500) , REPEAT("o", 3500));
65 DELETE FROM worklog5743 WHERE col_1_text = REPEAT("b", 3500);
66 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
67 worklog5743;
68
69 --connection default
70 # Restart the server
71 SET GLOBAL innodb_fast_shutdown=3;
72 -- source include/restart_mysqld.inc
73 SELECT COUNT(*) FROM worklog5743;
74 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
75 worklog5743;
76
77 --disconnect con1
78
79 --connect (con2,localhost,root,,)
80 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
81 worklog5743;
82 SELECT COUNT(*) FROM worklog5743;
83 START TRANSACTION;
84 UPDATE worklog5743 SET col_1_text = REPEAT("b", 3500) WHERE col_1_text = REPEAT("a", 3500);
85 SELECT col_1_text = REPEAT("b", 3500) , col_2_text = REPEAT("o", 3500) FROM
86 worklog5743;
87
88 --connection default
89 # Restart the server
90 SET GLOBAL innodb_fast_shutdown=3;
91 -- source include/restart_mysqld.inc
92 SELECT COUNT(*) FROM worklog5743;
93 SELECT col_1_text = REPEAT("a", 3500) , col_2_text = REPEAT("o", 3500) FROM
94 worklog5743;
95
96 DROP TABLE worklog5743;
97
98 --echo #
99 --echo # MDEV-21245 InnoDB: Using a partial-field key prefix in search
100 --echo #
101 CREATE TABLE t1 (a VARCHAR(255), KEY k(a)) DEFAULT CHARSET=utf8mb3
102 ENGINE=InnoDB;
103 INSERT INTO t1 set a='';
104 --enable_info
105 alter table t1 change a a varchar(3000);
106 --disable_info
107 SELECT * FROM t1 WHERE a IN ('');
108 DROP TABLE t1;
109
110 --echo # End of 10.4 tests
111
112 --source include/test_db_charset_restore.inc