Bug #27514 restart MySQL after sql query

Submitted: 29 Mar 2007 10:02 Modified: 29 Mar 2007 10:13
Reporter: Martin Korous Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Data Types Severity:S3 (Non-critical)
Version:5.0.36 - 5.0.37 OS:
Assigned to: 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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.051 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.