| 1 |
--source include/not_embedded.inc |
| 2 |
--source include/have_perfschema.inc |
| 3 |
--echo # |
| 4 |
--echo # MDEV-36720 Possible memory leak on updating table with index without overlaps |
| 5 |
--echo # |
| 6 |
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)); |
| 7 |
insert into t1 (rel_id, start_date, end_date) values (1, '2024-01-01', '2025-01-01'); |
| 8 |
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'; |
| 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 |
update t1 set end_date = '2025-01-16' where id = 1; |
| 12 |
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'; |
| 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 |
update t1 set end_date = '2025-01-16' where id = 1; |
| 16 |
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'; |
| 17 |
drop table t1; |
| 18 |
|
| 19 |
--echo # End of 10.11 tests |