Hi!
On Aug 29, Johnny Withers wrote:
> I'm not sure if this is a bug or if this is the way MERGE TABLES works
> in MySQL.
>
> It seems that if I have an INDEX in a field (id for instance), and I try
> to
> SELECT using a WHERE id=NUMBER, it will fail, even though that NUMBER is
> a
> valid id. ID is an int unsigned field with a key on it. However, when I
> drop
> the key, everything works as expected..
>
> Is this a bug?
>
> (also if I tried to ORDER BY id, while indexed, that didn't work either)
>
Both look like a bug.
Could you create a repeatable test case ?
Regards,
Sergei
--
MySQL Development Team
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany
<___/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php