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
Hi,
On Thu, Mar 20, 2003 at 06:38:04AM -0800, Mike Lemke wrote:
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.
This is as documented in
In the last episode (Mar 20), Fred van Engen said:
See msg 135092 for sample script if you want to see a physical example.
Which message is 135092? I'm reading a mailing list, not a newsgroup.
The mailing list software at mysql.com does number each message, and
even though the archive
On Thu, Mar 20, 2003 at 10:32:07AM -0600, Dan Nelson wrote:
In the last episode (Mar 20), Fred van Engen said:
See msg 135092 for sample script if you want to see a physical example.
Which message is 135092? I'm reading a mailing list, not a newsgroup.
The mailing list software at
It is a mySQL UNION problem referenced in a couple of places on the web.
Basically, the topmost query must not select NULL, and must select character
placeholders for the largest possible piece of data that may be present in each
column, and also select zero for number columns. What is