Pete Harlan writes:
> On Wed, Oct 17, 2001 at 02:51:50PM +0300, Sinisa Milivojevic wrote:
> > SQL_CALC_FOUND_ROWS has sense (and will have any effect) only when
> > used with LIMIT clause.
>
> So could it be a syntax error to use it otherwise? Or could the name
> be SQL_CALC_FOUND_ROWS_FOR_LIMIT or somesuch, to make the lack of
> orthogonality obvious?
>
> The name of the function as it stands encourages one to think of other
> uses for it besides when there's a LIMIT.
>
> (There are other ways to find the number of rows a regular SELECT
> found, but someone might think this looks like a convenient way.)
>
> The fewer things that one can misunderstand without memorizing the
> manual, the fewer questions we'll get on this list.
>
> --Pete
>
If there is no LIMIT, then this option is simply disregarded.
It could be made to turn out the error, though ...
--
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
