Hi Faculties,
I have recently done a migration of my DB from MySQL 5.0.20 to
MySQL 5.0.45 on a windows machine. Now many of my stored procedures
are giving me exceptions, that were executing fine on the earlier
version. The error that I get on 5.0.45 is "Incorrect usage of UNION
and INTO". Is it a bug? Please advise.


Thanks in advance
Jackal

jackal_on_work@yahoo.com < jackal_on_work@yahoo.com> wrote
in <1195048563.871380.245990@k35g2000prh.googlegroups .com>:
> I have recently done a migration of my DB from MySQL
> 5.0.20 to
> MySQL 5.0.45 on a windows machine. Now many of my stored
> procedures are giving me exceptions, that were executing
> fine on the earlier version. The error that I get on
> 5.0.45 is "Incorrect usage of UNION and INTO".

Have you tried reading changelogs? Why not?

Here's a free hint: it's in 5.0.41.

> Is it a bug? Please advise.

It's a bugfix. By the way, reading the relevant part of
MySQL reference manual would've helped as well.

--
....also, I submit that we all must honourably commit seppuku
right now rather than serve the Dark Side by producing the
HTML 5 spec.

Hi,
I am still unable to figure out the workaround to this issue. Is
there any suggested one?

Thanks in advance
Jackal

On Nov 14, 8:32 pm, Pavel Lepin <p.le...@ctncorp.com> wrote:
> jackal_on_w...@yahoo.com < jackal_on_w...@yahoo.com> wrote
> in <1195048563.871380.245...@k35g2000prh.googlegroups .com>:
>
> > I have recently done a migration of my DB from MySQL
> > 5.0.20 to
> > MySQL 5.0.45 on a windows machine. Now many of my stored
> > procedures are giving me exceptions, that were executing
> > fine on the earlier version. The error that I get on
> > 5.0.45 is "Incorrect usage of UNION and INTO".
>
> Have you tried reading changelogs? Why not?
>
> Here's a free hint: it's in 5.0.41.
>
> > Is it a bug? Please advise.
>
> It's a bugfix. By the way, reading the relevant part of
> MySQL reference manual would've helped as well.
>
> --
> ...also, I submit that we all must honourably commit seppuku
> right now rather than serve the Dark Side by producing the
> HTML 5 spec.

On 27 Nov, 09:53, jackal_on_w...@yahoo.com wrote:
> Hi,
> I am still unable to figure out the workaround to this issue. Is
> there any suggested one?
>
> Thanks in advance
> Jackal

Please do not top post.

This is not an issue that needs a workaround. All you need to do is to
code your UNION according to the syntax published in the manual. (As
Pavel pointed out: "By the way, reading the relevant part of MySQL
reference manual would've helped as well.")