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
---------------------------------------------------------------------
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
