Bug #12278 Triggers: packet error if select from information_schema
Submitted: 29 Jul 2005 20:48 Modified: 15 Aug 2005 17:29
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.11-beta-debug OS:Linux (SUSE 9.2)
Assigned to: Dmitry Lenev CPU Architecture:Any

[29 Jul 2005 20:48] Peter Gulutzan 
Description:
I create a before-insert trigger, which accesses information_schema.
I insert, twice.
I see "Packets out of order".

How to repeat:
mysql> delimiter //

mysql> create table tj (s1 int, s2 char(5))//
Query OK, 0 rows affected (0.00 sec)

mysql> create trigger tj_bi before insert on tj for each row set @a = ( select count(*) from information_schema.triggers)//
Query OK, 0 rows affected (0.01 sec)

mysql> insert into tj values (0,'a')//
Query OK, 1 row affected, 68 warnings (0.38 sec)

mysql> insert into tj values (0,'a')//
Query OK, 0 rows affected, 28265 warnings (0.01 sec)

Packets out of order (Found: 2, expected 1)
[9 Aug 2005 9:11] Dmitry Lenev 
This bug is fixed in version 5.0.12 by the same patch as bug #10055.
[15 Aug 2005 17:29] Mike Hillyer 
Added reference to this bug to 10055 changelog entry.