| Bug #27514 | restart MySQL after sql query | ||
|---|---|---|---|
| Submitted: | 29 Mar 2007 12:02 | Modified: | 29 Mar 2007 12:13 |
| Reporter: | Martin Korous | ||
| Status: | Duplicate | ||
| Category: | Server: Types | Severity: | S3 (Non-critical) |
| Version: | 5.0.36 - 5.0.37 | OS: | |
| Assigned to: | Target Version: | ||
[29 Mar 2007 12: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
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;