Michael Widenius wrote:
>
> Hi!
>
> >>>>> "Antony" == Antony T Curtis <antony@stripped> writes:
>
> Antony> Allows grammar such as
>
> Antony> SELECT tote_seq_no INTO @seq
> Antony> FROM toteq WHERE tote_no=@tote AND zone=@zone AND status="O"
> Antony> ORDER BY tote_seq_no
> Antony> LIMIT 1;
>
> Thanks for the patch, but I wouldn't like to accept this in this form.
>
> The right way to do this would be to do:
>
> SET @SEQ= SELECT tote_seq_no INTO @seq FROM toteq WHERE tote_no=@tote AND zone=@zone
> AND status="O" ORDER BY tote_seq_no LIMIT 1;
>
> This is more natural, especially in 4.1 when we have sub selects.
>
> Do you want to change this or should I do it?
>
> Regards,
> Monty
The reason for the grammar as I wrote it is for grammar compatibility
with IBM DB2 7.1
Except that DB2 uses ':' as the character to identify variables instead
of '@' but I can accept that difference ;)
For the things that I am doing, I would like to have same and/or similar
grammar between DB2 and MySQL.
(It means that I may not be using DB2 to it's full abilities, but that
doesn't concern me too much right now)
ANTONY T CURTIS
