>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
