WOW!
This is a really bad bug...
mysql> SHOW INDEX FROM LITERAL;
+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment |
+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
| LITERAL | 0 | PRIMARY | 1 | ID | A | 14331755 | NULL | NULL | | BTREE | |
| LITERAL | 0 | VALUE | 1 | VALUE | A | 14331755 | NULL | NULL | | BTREE | |
+---------+------------+----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+
Notice the unique index on VALUE ?
Now take a look at this:
mysql> SELECT *, MD5(LITERAL.VALUE) AS MD5_VALUE FROM LITERAL WHERE ID=567344 OR ID=14076840;
+----------+-------+----------------------------------+
| ID | VALUE | MD5_VALUE |
+----------+-------+----------------------------------+
| 567344 | Law | 81588d326cebe6416d3904db93603af1 |
| 14076840 | Law | 81588d326cebe6416d3904db93603af1 |
+----------+-------+----------------------------------+
2 rows in set (0.00 sec)
Seems like a fatal bug to me!
Kevin
--
Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat.
Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html
If you're interested in RSS, Weblogs, Social Networking, etc... then you should work for Rojo! If you recommend someone and we hire them you'll get a free iPod!
Kevin A. Burton, Location - San Francisco, CA
AIM/YIM - sfburtonator, Web - http://peerfear.org/
GPG fingerprint: 5FB2 F3E2 760E 70A8 6174 D393 E84D 8D04 99F1 4412
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]