Bug #9392 Triggers: crash if BDB

• Submitted: 24 Mar 2005 19:52
• Modified: 14 Aug 2005 19:47
• Reporter: Peter Gulutzan
• Status: Duplicate
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.4-beta-debug-max
• OS: Linux (SUSE 9.2)
• Assigned to: Assigned Account
• CPU Architecture: Any

[24 Mar 2005 19:52] Peter Gulutzan

Description:
On a server built with pentium-debug-max, I can create BDB tables and triggers.
When I insert and update on such tables, crash.

How to repeat:
mysql> create table b22 (s1 varchar(5), s2 char(5), s3 binary(5),s4 varbinary(5),primary key(s1,s2)) engine=bdb;
Query OK, 0 rows affected (0.03 sec)

mysql> create trigger b22_bi before insert on b22 for each row set new.s1 = concat(new.s1,new.s1);
Query OK, 0 rows affected (0.01 sec)

mysql> insert into b22 values ('c','c','c','c');
Query OK, 1 row affected (0.01 sec)

mysql> create trigger b22_bu before update on b22 for each row set new.s1 = concat(new.s1,new.s1);
Query OK, 0 rows affected (0.02 sec)

mysql> update b22 set s3 = 'f';
ERROR 2013 (HY000): Lost connection to MySQL server during query

[24 Mar 2005 23:19] MySQL Verification Team

Thank you for the bug report.

[7 May 2005 10:40] David Axmark

Moved to P2 on Monty orders

[14 Aug 2005 19:47] Dmitry Lenev

Hi!

I was able to repeat this crash using MySQL version 5.0.6, but I was not able to repeat it using latest 5.0 snapshot.
Investigation showed that this bug has the same source as bug #10015 and thus was fixed in 5.0.7.

I marking this bug as duplicate.