| 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: | |
| 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: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;