Debian Codegraph @

mysql-test/suite/period/r/perfschema.result

raw
1 #
2 # MDEV-36720 Possible memory leak on updating table with index without overlaps
3 #
4 create table t1 (id int not null primary key auto_increment, rel_id int not null, start_date datetime not null, end_date datetime not null, period for p (start_date, end_date), unique key (rel_id, p without overlaps));
5 insert into t1 (rel_id, start_date, end_date) values (1, '2024-01-01', '2025-01-01');
6 select object_type,object_schema,object_name,owner_thread_id,owner_event_id,internal_lock,external_lock from performance_schema.table_handles where object_name='t1';
7 object_type object_schema object_name owner_thread_id owner_event_id internal_lock external_lock
8 TABLE test t1 0 0 WRITE CONCURRENT INSERT NULL
9 update t1 set end_date = '2025-01-16' where id = 1;
10 select object_type,object_schema,object_name,owner_thread_id,owner_event_id,internal_lock,external_lock from performance_schema.table_handles where object_name='t1';
11 object_type object_schema object_name owner_thread_id owner_event_id internal_lock external_lock
12 TABLE test t1 0 0 WRITE NULL
13 update t1 set end_date = '2025-01-16' where id = 1;
14 select object_type,object_schema,object_name,owner_thread_id,owner_event_id,internal_lock,external_lock from performance_schema.table_handles where object_name='t1';
15 object_type object_schema object_name owner_thread_id owner_event_id internal_lock external_lock
16 TABLE test t1 0 0 WRITE NULL
17 update t1 set end_date = '2025-01-16' where id = 1;
18 select object_type,object_schema,object_name,owner_thread_id,owner_event_id,internal_lock,external_lock from performance_schema.table_handles where object_name='t1';
19 object_type object_schema object_name owner_thread_id owner_event_id internal_lock external_lock
20 TABLE test t1 0 0 WRITE NULL
21 update t1 set end_date = '2025-01-16' where id = 1;
22 select object_type,object_schema,object_name,owner_thread_id,owner_event_id,internal_lock,external_lock from performance_schema.table_handles where object_name='t1';
23 object_type object_schema object_name owner_thread_id owner_event_id internal_lock external_lock
24 TABLE test t1 0 0 WRITE NULL
25 drop table t1;
26 # End of 10.11 tests