[Phpmyadmin-devel] [Phpmyadmin-cvs] DisableIS in phpMyAdmin-trunk-20080424-022001 doesn't work

[Sebastian Mendel]

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?

1. not fully implemented
2. IMHO sooner, later or already SHOW will mapped to I_S
3. the above statement should include TRIGGER_SCHEMA in WHERE

Marc?

was there any reason not including TRIGGER_SCHEMA in WHERE?


-- 
Sebastian Mendel