Bug #23022 Can't drop trigger of an altered merge table
| Submitted: | 5 Oct 2006 17:12 | Modified: | 13 Oct 2010 14:56 |
|---|---|---|---|
| Reporter: | Peter Gulutzan | Email Updates: | |
| Status: | Won't fix | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
| Version: | 5.1.12-beta-debug | OS: | Linux (SUSE 10.0 / 64-bit) |
| Assigned to: | Konstantin Osipov | CPU Architecture: | Any |
[5 Oct 2006 17:12]
Peter Gulutzan
[5 Oct 2006 18:37]
MySQL Verification Team
Thank you for the bug report. Notice that the error messages had changed from a server built some days ago with the current one: mysql> drop trigger tm3_bi; /* Result: error 1168 */ ERROR 1017 (HY000): Can't find file: 'tm3' (errno: 2) mysql> exit mysql> drop trigger tm3_bi; /* Result: error 1168 */ ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exists
[20 Feb 2008 19:33]
Omer Barnir
workaround: Drop and create the merge table
[13 Oct 2010 14:56]
Konstantin Osipov
Won't fix: please don't do that.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.