Re: Bug with UNION and constant columns

> mysql> ( SELECT '' ) UNION ( SELECT 'aaaaaaaaaaaa' );
> +--+
> |  |
> +--+
> |  |
> +--+
> 1 row in set (0.00 sec)
> 
> mysql> ( SELECT '******' ) UNION ( SELECT '|||||||||||');
> +--------+
> | ****** |
> +--------+
> | ****** |
> | |||||| |
> +--------+
>2 rows in set (0.00 sec)
> 
> (there are more '|' then '*')
> 
> Bug exists in 4.0.20.
> 
> Does not occur in 4.1.1.

HI!

Thank you for writting to us.

As you well noted, this bug is fixed in 4.1.

This bug will not be fixed in 4.0 as the change would break a
stability of the production release. Beside that, methods, classes and
functions used to solve the issue in 4.1 are not available in 4.0.

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus



-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]