Bug with UNION and constant columns

------=_NextPart_000_0010_01C4441D.494BEEF0
Content-Type: text/plain;
charset="windows-1255"
Content-Transfer-Encoding: quoted-printable

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.
------=_NextPart_000_0010_01C4441D.494BEEF0--
Amir Abiri [ Do, 27 Mai 2004 19:03 ] [ ID #83200 ]

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 <sinisa [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs [at] m.gmane.org
Sinisa Milivojevic [ Do, 27 Mai 2004 18:24 ] [ ID #83201 ]
Datenbanken » gmane.comp.db.mysql.bugs » Bug with UNION and constant columns

Vorheriges Thema: JConnector 3.0.11 broken
Nächstes Thema: REPAIR/CHECK/BACKUP/RESTORE TABLE handling of compressed tables