List:General Discussion« Previous MessageNext Message »
From:Mike Lemke Date:March 20 2003 2:38pm
Subject:UNION operates incorrectly
View as plain text  
The topmost query in a series of queries, each connected by UNION ALL, dictates
the allocated space for data in each column for the resulting row set!  This is
very bad - and makes the UNION useless.

Is there some database option that will make a UNION behave properly in mySQL?

See msg 135092 for sample script if you want to see a physical example.



__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com
Thread
UNION operates incorrectlyMike Lemke20 Mar
  • Re: UNION operates incorrectlyFred van Engen20 Mar
    • Re: UNION operates incorrectlyDan Nelson20 Mar
      • Re: UNION operates incorrectlyFred van Engen20 Mar
    • Re: UNION operates incorrectlyMike Lemke20 Mar