output truncated with ELT when using DISTINCT

Jani Tolonen <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <16377.44642.173442.907389@rhols221>
Hi Patrick,

Patrick Proniewski writes:
> Hello,
> 
> when using both DISTINCT and ELT in a query, I experience problems : 
> some strings returned by ELT are truncated.
> 
> tested on :
> 	MySQL 4.0.17 + Linux_thread on FreeBSD 4.8
> 	MySQL 3.23.38 on Linux
> 	MySQL 4.0.16 on MacOS X 10.3.2
<cut>

Thanks for the bug report!

> Is there a clean work around ?

Seems to work in 4.1, but 4.0 fails. I will enter this into
the bugs database, it should be fixed by the next release.

Regards,

- Jani

For technical support contracts, visit https://order.mysql.com/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Jani Tolonen <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Helsinki, Finland
       <___/   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.