Sebastian Mendel a écrit :
Hi,
Rekrutacja schrieb:
i've tested latest pma (phpMyAdmin-trunk-20080424-022001), and it seems it has DisableIS set to true as default, but when i log in and click any of the tables from database, i can see this on the server:
SELECT TRIGGER_SCHEMA, TRIGGER_NAME, EVENT_MANIPULATION, ACTION_TIMING, ACTION_STATEMENT, EVENT_OBJECT_SCHEMA, EVENT_OBJECT_TABLE FROM information_schema.TRIGGERS WHERE EVENT_OBJECT_SCHEMA= 'test99_db' and EVENT_OBJECT_TABLE = 'phpbb2_bookmarks'
and is taking very long time, same as without DisableIS.
does DisableIS is not yet fully implemented or is it a bug?
- not fully implemented
- IMHO sooner, later or already SHOW will mapped to I_S
- the above statement should include TRIGGER_SCHEMA in WHERE
Marc?
was there any reason not including TRIGGER_SCHEMA in WHERE?
I'll check about this.