>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

Reply via email to