diff options
| author | Konstantin Osipov <kostja@sun.com> | 2009-12-09 12:37:54 +0300 |
|---|---|---|
| committer | Konstantin Osipov <kostja@sun.com> | 2009-12-09 12:37:54 +0300 |
| commit | 59f82702a18799621a19f1a880e9f80cb374b1ce (patch) | |
| tree | 44caba681d1acf8c1f22dafb73162564d126ad67 /mysql-test/r/trigger.result | |
| parent | c03174458a46f382926abfcd669e8edd521dd59c (diff) | |
| download | mariadb-git-59f82702a18799621a19f1a880e9f80cb374b1ce.tar.gz | |
Backport of:
------------------------------------------------------------
revno: 2617.69.32
committer: Dmitry Lenev <dlenev@mysql.com>
branch nick: mysql-next-bg46747
timestamp: Wed 2009-08-19 18:12:27 +0400
message:
Fix for bug #46747 "Crash in MDL_ticket::upgrade_shared_lock_to_exclusive
on TRIGGER + TEMP table".
Server crashed when one tried to drop trigger which had its subject
table shadowed by a temporary table with the same name.
This problem occured because in such situation DROP TRIGGER has opened
temporary table instead of base table on which trigger was defined.
Attempt to upgrade metadata lock on this temporary table led to crash
(we don't acquire metadata locks for temporary tables).
This fix ensures that DROP TRIGGER ignores temporary tables when
trying to open table on which trigger to be dropped is defined.
mysql-test/r/trigger.result:
Added test case for bug #46747 "Crash in
MDL_ticket::upgrade_shared_lock_to_exclusive
on TRIGGER + TEMP table".
mysql-test/t/trigger.test:
Added test case for bug #46747 "Crash in
MDL_ticket::upgrade_shared_lock_to_exclusive
on TRIGGER + TEMP table".
sql/sql_trigger.cc:
Prevent DROP TRIGGER from opening temporary table which might
shadow base table on which trigger to be dropped is defined.
Diffstat (limited to 'mysql-test/r/trigger.result')
| -rw-r--r-- | mysql-test/r/trigger.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/trigger.result b/mysql-test/r/trigger.result index 47b50b233b3..5c63604a325 100644 --- a/mysql-test/r/trigger.result +++ b/mysql-test/r/trigger.result @@ -2162,3 +2162,23 @@ Warning 1265 Data truncated for column 'trg2' at row 1 DROP TRIGGER trg1; DROP TRIGGER trg2; DROP TABLE t1; +# +# Bug #46747 "Crash in MDL_ticket::upgrade_shared_lock_to_exclusive +# on TRIGGER + TEMP table". +# +drop trigger if exists t1_bi; +drop temporary table if exists t1; +drop table if exists t1; +create table t1 (i int); +create trigger t1_bi before insert on t1 for each row set @a:=1; +# Create temporary table which shadows base table with trigger. +create temporary table t1 (j int); +# Dropping of trigger should succeed. +drop trigger t1_bi; +select trigger_name from information_schema.triggers +where event_object_schema = 'test' and event_object_table = 't1'; +trigger_name +# Clean-up. +drop temporary table t1; +drop table t1; +End of 6.0 tests. |