Different behaviour between 3.22.32 and 3.23.32

[Andrew Benham]

>Description:
"SELECT MAX (record_id) FROM record;" iworks in 3.22.32 but fails in 3.23.32


In v3.22.32, both the following SQL commands work:

mysql> SELECT MAX (record_id) FROM record;
+-+
| MAX (record_id) |
+-+
| 3010001 |
+-+
1 row in set (0.03 sec)

mysql> SELECT MAX(record_id) FROM record;
++
| MAX(record_id) |
++
|3010001 |
++
1 row in set (0.02 sec)



But in v3.23.32 only one works:

mysql> SELECT MAX (record_id) FROM record;
ERROR 1064: You have an error in your SQL syntax near '(record_id) FROM 
record' at line 1
mysql> SELECT MAX(record_id) FROM record;
++
| MAX(record_id) |
++
|5040003 |
++
1 row in set (0.00 sec)


>How-To-Repeat:
As above
>Fix:
Check all scripts and modify where required :-(

>Submitter-Id:  adsb
>Originator:Andrew Benham
>Organization:  Nortel Networks Plc
  -- 
  Andrew Benham   [EMAIL PROTECTED]
  Nortel Networks Plc, London Road, Harlow, Essex CM17 9NA, United Kingdom
  Tel: +44 1279 402372Fax: +44 1279 405746
  
  I speak for myself, my views are not necessarily the views
  of Nortel Networks or any other corporation.
>
>MySQL support: none
>Synopsis:  Change in SQL syntax happened
>Severity:  serious
>Priority:  medium
>Category:  mysql
>Class: sw-bug
>Release:   mysql-3.23.32 (Official MySQL binary)

>Environment:

System: HP-UX wharh05g B.10.20 A 9000/785 2016207775 two-user license


Some paths:  /usr/bin/perl /usr/bin/make /opt/corp/unsupported/bin/gmake 
/opt/corp/unsupported/gcc-2.8.1/bin/gcc /usr/bin/cc
GCC: Reading specs from 
/opt/corp/unsupported/gcc-2.8.1/lib/gcc-lib/hppa1.1-hp-hpux10.20/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc'  CFLAGS='-DHPUX -I/opt/dce/include -fomit-frame-pointer -O6 
-fpic'  CXX='gcc'  CXXFLAGS='-DHPUX -I/opt/dce/include -felide-constructors 
-fno-exceptions -fno-rtti -O6 '  LDFLAGS=''
LIBC: 
-r-xr-xr-x   1 binbin1863680 Oct  8  1999 /lib/libc.1
-r--r--r--   1 binbin2456372 Oct  8  1999 /lib/libc.a
lrwxr-xr-x   1 root   sys 15 Mar 21  2000 /lib/libc.sl -> 
/usr/lib/libc.1
-r-xr-xr-x   1 binbin1863680 Oct  8  1999 /usr/lib/libc.1
-r--r--r--   1 binbin2456372 Oct  8  1999 /usr/lib/libc.a
lrwxr-xr-x   1 root   sys 15 Mar 21  2000 /usr/lib/libc.sl -> 
/usr/lib/libc.1
Configure command: ./configure  --prefix=/usr/local/mysql '--with-comment=Official 
MySQL binary' --with-extra-charsets=complex --with-pthread 
--with-named-thread-libs=-ldce --disable-shared
Perl: This is perl, version 5.004

-
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

wait_timeout?

[Andrew Benham]

Patrick Meyer wrote:

> I am slowly gaining connections to the database that just sleep.  I know
> these can arise from not closing the database.  I am accessing it via MyODBC
> from Active Server Pages.  However, I set wait_timeout to 3600... I have
> some that have been there for days... just sleeping.  Why doesn't MySQL
> disconnect them from the timeout?  Maybe I just don't understand
> wait_timeout.

I'm glad it's not just me. I have 2 v3.22.32 servers running under
HP-UX 10.20
Both servers are being used by FCGI processes on the web with persistant
connections to the database servers.

One MySQL server heeds the 'wait_timeout' value, the other ignores it
and keeps threads running for 'ever'.

Any ideas please ?

-- 
Andrew Benham   [EMAIL PROTECTED]
Nortel Networks Plc, London Road, Harlow, Essex CM17 9NA, United Kingdom
Tel: +44 1279 402372Fax: +44 1279 405746

I speak for myself, my views are not necessarily the views
of Nortel Networks or any other corporation.

-
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