Heikki Tuuri writes:
> Jon,
>
> ----- Original Message -----
> From: ""Jon Frisby"" <[EMAIL PROTECTED]>
> Newsgroups: mailing.database.mysql
> Sent: Saturday, June 22, 2002 12:51 AM
> Subject: Nasty LIMIT/multi-table DELETE bug?
>
>
> > I just discovered a very scary behavior. We're using MySQL 4.0.1 on
> Linux,
> > both tables are InnoDB, AUTO_COMMIT is on (default) and these queries are
> > being issues from the MySQL interactive console.
> >
> > If I do a query of the form:
> >
> > SELECT
> > transaction_report.*,
> > confirmed
> > FROM
> > transaction_report,
> > user
> > WHERE
> > user_id = user.id AND
> > DATE_FORMAT(when_reported, '%Y-%m-%d') = '2002-06-21' AND
> > transaction_report.partner_id = 1 AND
> > confirmed != 1
> > LIMIT
> > 50;
> >
This bug was fixed meanwhile ...
Now, with multi-table delete you get a syntax error with LIMIT. This
has been done so as LIMIT is ambiguous in delete with more then one
table involved.
--
Regards,
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Sinisa Milivojevic <[EMAIL PROTECTED]>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer
/_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus
<___/ www.mysql.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
