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
