Re: UNION fails on MyIsam tables when index on second column from same table

Sergei Golubchik <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
Hi!

On Feb 14, Jeremy March wrote:
> Hi!
> Problem: UNION queries fail on MyIsam tables when both selects are from
> the same table and there is an index on the column selected from the
> second select.
> 
> This works fine with innodb tables thanks to your recent bug fix:)
> 
> This was tested with mysql-4.1.2, latest changes pulled today.

I entered it as

http://bugs.mysql.com/bug.php?id=2809
 
Regards,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, Senior Software Developer
/_/  /_/\_, /___/\___\_\___/  Osnabrueck, Germany
       <___/  www.mysql.com

-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.