Hi,
wkwing@stripped wrote:
> How-To-Repeat:
<cut>
> create table tmp(a integer);
> insert into tmp values (1);
>
> Bug 1: returns 1 row only
> select 'a' as b from tmp union 'cde' as b from tmp;
This query should return Syntax error because of missing select after UNION
> Bug 2: returns shortest string only
> select 'a' as b from tmp union all 'cde' as b from tmp;
Same here.
> b
> ----
> a
> c
About Stgring truncation: this is known diffrence with SQL-99. MySQL is more
strict in applying rule that columns from first query in determine the column
types for the rest of the queries.
We have scheduled this SQL-99 conformance for MySQL 5.0
Enetered in bugs database as http://bugs.mysql.com/bug.php?id=96
Best regards
--
MySQL Conference and Expo 2003 http://www.mysql.com/events/uc2003/index.html
For technical support contracts, visit https://order.mysql.com/?ref=msal
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <salle@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria
<___/ www.mysql.com
