Unexplained query results on int keys
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)
Subject
Written By
Posted
Unexplained query results on int keys
February 02, 2005 09:51AM
February 05, 2005 05:01AM
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.