List Box writes:
>
> MySQL is not giving expected results in queries:
>
> The table has a decimal field, 'tolong', with a 13 char size and 8
> decimal places.
>
> I know from browsing that the table contains many records with
> 'tolong' values less than -120, as low as -124.
>
> The query
> select * from Tiger_main
> where tolong < -120;
>
> results in no records being retrieved.
> The same query, with reference value -119.8 yeilds no
> records returned.
> The same query, with reference value -119.7 returns a large number
> of records, including several which should have been returned by
> the prior queries, with tolong values less than -120.
>
> The table is fairly large, with over 5 million records and 500 MBytes,
> and the tolong field is individually indexed.
>
> The server is MySQL 3.23.22-beta-log.
>
> Can anybody provide any insight into what the problem might be?
>
> David Keeney
>
>
> Can anybody shed any light on why MySQL
>
Hi!
Please try your query on 3.23.37, built by us, if possible.
If a problem repeats, please send us a repeatable test case.
Regards,
Sinisa
__ _ _ ___ == MySQL AB
/*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
/*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
/*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
/*/^^^\*\^^^
/*/ \*\Developers Team
-
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