> >Description:
> "SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but
> fails in 3.23.32
>
Well, that shouldn't really come as a surprise. The manual
specifically says (Section "Functions for use in SELECT and
WHERE clauses):
----
Note: There must be no whitespace between a function name
and the parenthesis following it. This helps the MySQL
parser distinguish between function calls and references to
tables or columns that happen to have the same name as a
function. Spaces around arguments are permitted, though.
----
You may be running your 3.22 version in ANSI mode, this
would explain the seemingly strange behaviour. Or it may
be, that the behaviour changed between 3.22 and 3.23, to
allow for dramatic increase in the number of functions
that were added.
/ Carsten
--
Carsten H. Pedersen
keeper and maintainer of the bitbybit.dk MySQL FAQ
http://www.bitbybit.dk/mysqlfaq
---------------------------------------------------------------------
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
