View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0005958 | VCOMPONENT-VKERNEL | SQL | public | 2012-09-12 15:13 | 2014-01-29 19:20 |
Reporter | Igor Nikitin | Assigned To | Ivan Smahin | ||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | resolved | Resolution | fixed | ||
Product Version | |||||
Target Version | 5.5.3 | Fixed in Version | 5.5.3 | ||
Summary | 0005958: SHOW TRIGGERS doesn't works for table | ||||
Description | In docs I have found such definition: SHOW TRIGGERS [{FROM|OF} table_name] [{FROM|OF} db_name] but it works only when we specified both table and db, when db_name is missing, kernel returns error: 0x51504. Database "t1" is not found. for query: SHOW TRIGGERS OF t1 Also here seems only one SHOW command that allow specify source database. | ||||
Tags | No tags attached. | ||||
-- show triggers for current database SHOW TRIGGERS -- Show triggers for specified database SHOW TRIGGERS FROM db1 -- Show triggers for particular table/view SHOW TRIGGERS FROM t1 FROM db1 |
|
http://dev.mysql.com/doc/refman/5.6/en/show-triggers.html mySQL 5.6 can do only SHOW TRIGGERS [{FROM | IN} db_name] |
|
| SHOW COLUMNS {FROM|OF} table_name [{FROM|OF} db_name] | SHOW LINKS [{FROM|OF} table_name] [{FROM|OF} db_name] | SHOW TRIGGERS [{FROM|OF} table_name] [{FROM|OF} db_name] Well, it seems we have follow to mistake of mySQL in show columns ... And did it even worse for triggers links. VALID so far as SHOW TRIGGERS SHOW TRIGGERS FROM db SHOW TRIGGERS FROM T FROM db do not works now SHOW TRIGGERS FROM T and there is no easy nice way resolve this. So far we will not touch this ... in future we need deprecate this FROM FROM syntax of mySQL, and switch to SHOW TRIGGERS FROM db.tbl or even to SHOW TRIGGERS FROM schema.db.tbl |
|
Date Modified | Username | Field | Change |
---|---|---|---|
2012-09-12 15:13 | Igor Nikitin | New Issue | |
2012-09-13 05:47 | Ivan Smahin | Note Added: 0006511 | |
2012-09-13 06:33 | Ruslan Zasukhin | Note Added: 0006512 | |
2012-09-13 07:12 | Ruslan Zasukhin | Note Added: 0006513 | |
2013-12-22 15:21 | Ruslan Zasukhin | Target Version | => 6.0 |
2014-01-15 12:32 | Ivan Smahin | Target Version | 6.0 => 5.5.3 |
2014-01-21 12:31 | Ivan Smahin | Status | new => resolved |
2014-01-21 12:31 | Ivan Smahin | Fixed in Version | => 5.5.3 |
2014-01-21 12:31 | Ivan Smahin | Resolution | open => fixed |
2014-01-21 12:31 | Ivan Smahin | Assigned To | => Ivan Smahin |
2014-01-29 19:20 | Ruslan Zasukhin | View Status | private => public |