Bug #28815 apparent memory corruption in "show warnings" output

Submitted: 31 May 2007 18:48 Modified: 31 May 2007 19:11
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.19 OS:Any
Assigned to: CPU Architecture:Any

[31 May 2007 18:48] Shane Bester
Description:
When running a select with some unions, and a subselect, there are warnings reported.

The look strangely corrupted:

<big select statement>

Empty set, 613 warnings (0.02 sec)

mysql> show warnings;
+---------+------+----------------------------------------------------------------------
| Level   | Code | Message
+---------+------+----------------------------------------------------------------------
| Warning | 1292 | Incorrect datetime value: '?' for column 'col101' at row 1
| Warning | 1292 | Incorrect date value: '?' for column 'col27' at row 1
| Warning | 1292 | Incorrect datetime value: '?' for column 'col15' at row 1
<d$`¶▲???-d?↑?s☻♥?▬??Uq3????=.v?}9↓?6H☼W?}┬??c?^?.?6.?♥}?‼?.?‼▲?↓i??2?▲???I.?FPlQ?~?♦??'
<d$`¶▲???-d?↑?s☻♥?▬??Uq3????=.v?}9↓?6H☼W?}┬??c?^?.?6.?♥}?‼?.?‼▲?↓i??2?▲???I.?FPlQ?~?♦??'
<d$`¶▲???-d?↑?s☻♥?▬??Uq3????=.v?}9↓?6H☼W?}┬??c?^?.?6.?♥}?‼?.?‼▲?↓i??2?▲???I.?FPlQ?~?♦??'

<cut>

| Warning | 1292 | Incorrect datetime value: 'A♥??WL???l?4?????9??BK?♀|???▲?D??♀z▲_?<6?3o????↑(H??l↕O
| Warning | 1292 | Incorrect datetime value: 'A♥??WL???l?4?????9??BK?♀|???▲?D??♀z▲_?<6?3o????↑(H??l↕O
| Warning | 1292 | Incorrect datetime value: 'A♥??WL???l?4?????9??BK?♀|???▲?D??♀z▲_?<6?3o????↑(H??l↕O
| Warning | 1292 | Incorrect datetime value: 'A♥??WL???l?4?????9??BK?♀|???▲?D??♀z▲_?<6?3o????↑(H??l↕O
+---------+------+-----------------------------------------------------------------------------------
64 rows in set (0.00 sec)

How to repeat:
will upload a testcase later
[31 May 2007 19:11] Shane Bester
hm, there was garbage in the one column, caused the mangled output.

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

Page generated in 0.038 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.