Bug #19866 Query returns strange result
Submitted: 17 May 2006 4:46 Modified: 17 Jun 2006 5:05
Reporter: Derek Chung Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Query Browser Severity:S2 (Serious)
Version:v1.1.20 OS:Windows (Windows XP)
Assigned to: CPU Architecture:Any

[17 May 2006 4:46] Derek Chung
Description:
I have a table, one of the row is MD5 password which in Byte(16) format. The binary query result shown in Field Viewer changes everytime I re-query the table once. 

I need to manipulate the byte for basic uesr administration. When I try to insert a new record using HEX (eg 0x123213213), the same problem occur. The byte returned changes everytime I create a new query

How to repeat:
just query again and a different result will be shown
[17 May 2006 4:51] Derek Chung
sorry it should be varchar(16) instead of byte(16)
[17 May 2006 5:05] Valeriy Kravchuk
Thank you for a problem report. Please, try to repeat your query with mysql command line client. Will it give the same "varying" results?

What MySQL server version do you use? Anyway, please, send the CREATE TABLE statement, some INSERT(s) and reall query that allows to reproduce the behaviour you described.
[17 Jun 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".