Debian Codegraph @

mysql-test/suite/innodb/r/index_length.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 connect stop_purge,localhost,root;
3 START TRANSACTION WITH CONSISTENT SNAPSHOT;
4 connection default;
5 CREATE TABLE t1(a INT PRIMARY KEY, b VARCHAR(1024))
6 ENGINE=InnoDB STATS_PERSISTENT=1;
7 INSERT INTO t1 VALUES (1,REPEAT('b',1024));
8 SELECT index_length FROM information_schema.tables
9 WHERE table_schema = 'test' AND table_name = 't1';
10 index_length
11 0
12 ALTER TABLE t1 ADD INDEX b (b(800));
13 SELECT FLOOR(index_length/@@innodb_page_size) FROM information_schema.tables
14 WHERE table_schema = 'test' AND table_name = 't1';
15 FLOOR(index_length/@@innodb_page_size)
16 1
17 ALTER TABLE t1 ADD INDEX ba (b(800),a);
18 SELECT FLOOR(index_length/@@innodb_page_size) FROM information_schema.tables
19 WHERE table_schema = 'test' AND table_name = 't1';
20 FLOOR(index_length/@@innodb_page_size)
21 2
22 disconnect stop_purge;
23 DROP TABLE t1;
24 #
25 # MDEV-22855 Assertion (!field->prefix_len ||
26 # field->fixed_len == field->prefix_len)
27 # failed in btr_node_ptr_max_size
28 #
29 CREATE TABLE t1(c CHAR(194) CHARACTER SET UTF32, KEY k1(c(193)))ENGINE=InnoDB;
30 INSERT INTO t1 SET c='';
31 DROP TABLE t1;
32 # End of 10.4 tests
33 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;