MySQL Forums
Forum List  »  General

Unexplained query results on int keys
Posted by: Paul Plesman
Date: February 02, 2005 09:51AM

I have come across a situation where keys defined as "int unsigned" show up with odd values in query results but still resolve. See statement below.
Has anyone seen this before? The indent before the number 8 actually shows up this way. What happened to the number? I have truncated the table and reloaded with proper data and used isamcheck -r. Both to no avail.
Explanations welcome.

mysql> select * from supanswer where id=38888;
+-------+--------------+------------+--------+
| id | number | questionid | answer |
+-------+--------------+------------+--------+
|8 | 100-047-9630 | 10 | 1
+-------+--------------+------------+--------+
1 row in set (0.00 sec)

Options: ReplyQuote


Subject
Written By
Posted
Unexplained query results on int keys
February 02, 2005 09:51AM


Sorry, you can't reply to this topic. It has been closed.

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.