Bug #27514 restart MySQL after sql query

• Submitted: 29 Mar 2007 10:02
• Modified: 29 Mar 2007 10:13
• Reporter: Martin Korous
• Status: Duplicate
• Category: MySQL Server: Data Types
• Severity: S3 (Non-critical)
• Version: 5.0.36 - 5.0.37
• CPU Architecture: Any

[29 Mar 2007 10:02] Martin Korous

Description:
mysql is restarting after sql query with repeat() and name of column
repeat() with number is OK: repeat('f',3)
if type of column is only int, query is OK

mysql> select repeat('f',pocet) from test;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 
Number of processes running now: 0
070329 11:45:59  mysqld restarted

tested on 2 machines with 5.0.36 and 5.0.37

How to repeat:
create table test (pocet tinyint(3) unsigned);

$pocet = 0;
for ($i = 0; $i < 50; $i++) {
insert into test values('$pocet')
 $pocet++;
        if ($pocet > 5) $pocet = 0;
}

select repeat('f',pocet) from test;

[29 Mar 2007 10:13] Giuseppe Maxia

An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of Bug#25197 and Bug#27073