>Description: if a column is defined as float(3,1) and your sql query uses where in that particular column and the value has decimals on it then you got empty set. >How-To-Repeat: ($:~) mysql stuff Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 35 to server version: 3.23.32 Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql> select max(tiesaailma) from tiesaa; +-----------------+ | max(tiesaailma) | +-----------------+ | 5.3 | +-----------------+ 1 row in set (3.92 sec) mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=5.3; Empty set (1.13 sec) mysql> select tiesaailma,tiesaacity from tiesaa where tiesaailma=3; +------------+-----------------------------------+ | tiesaailma | tiesaacity | +------------+-----------------------------------+ | 3.0 | Tie 8; Pattijoki | | 3.0 | Tie 8; Närpiö, Bäckliden | | 3.0 | Tie 8; Närpiö, Bäckliden | | 3.0 | Tie 8; Pattijoki | | 3.0 | Tie 2; Pori, Kähkönen | | 3.0 | Tie 8; Kristiinankaup, Lapväärtti | | 3.0 | Tie 83; Ylitornio, Raanujärvi | +------------+-----------------------------------+ 7 rows in set (1.12 sec) mysql> >Fix: not known. >Submitter-Id: <submitter ID> >Originator: Jani Ollikainen >Organization: ----------------------------------------- bestis [EMAIL PROTECTED] Jani Ollikainen http://come.to/bestis ----------------------------------------- > >MySQL support: none >Synopsis: some implementations of getting data with max() don't work. >Severity: non-critical >Priority: low >Category: mysql >Class: sw-bug >Release: mysql-3.23.32 (Source distribution) >Server: /usr/bin/mysqladmin Ver 8.14 Distrib 3.23.32, for redhat-linux-gnu on i386 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.32 Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 3 min 21 sec Threads: 1 Questions: 60 Slow queries: 0 Opens: 23 Flush tables: 1 Open tables: 17 Queries per second avg: 0.299 >Environment: System: Linux ls.sicom.fi 2.4.0 #5 Mon Jan 22 16:10:56 EET 2001 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.96/specs gcc version 2.96 20000731 (Red Hat Linux 7.0) Compilation info: CC='gcc' CFLAGS='-O2 -march=i386 -mcpu=i686' CXX='c++' CXXFLAGS='-O2 -march=i386 -mcpu=i686' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 9 May 18 1999 /lib/libc.so.5 -> libc.so.6 lrwxrwxrwx 1 root root 11 Dec 9 12:45 /lib/libc.so.6 -> libc-2.2.so -rwxr-xr-x 1 root root 5072386 Jan 11 01:37 /lib/libc-2.2.so -rw-r--r-- 1 root root 24498288 Jan 11 01:35 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 11 01:35 /usr/lib/libc.so Configure command: ./configure i386-redhat-linux --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --without-debug --without-readline --enable-shared --with-extra-charsets=complex --without-bench --localstatedir=/var/lib/mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --with-mysqld-user=mysql --with-extra-charsets=all --------------------------------------------------------------------- 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