|
We are having a very strange issue where for certain
records, queries sent via JDBC return no results when the identical query via command
line or pgadmin return non-null (expected) results. Example below. We are
running 8.3.9. >> SELECT client_id FROM locations WHERE
external_id = '278'; >> >> Doing an EXPLAIN ANALYZE from psql gives: >> >> Seq Scan on locations (cost=0.00..17.01 rows=1
width=4) (actual >> time=0.189..0.197 rows=1 loops=1) >> Filter: ((external_id)::text = '278'::text)
Total runtime: 0.245 >> ms >> >> And doing the same thing from JDBC
stmt.executeQuery() gives: >> >> Seq Scan on locations (cost=0.00..17.93 rows=1
width=4) (actual >> time=0.206..0.206 rows=0 loops=1) >> Filter: ((external_id)::text = '278'::text)
Total runtime: 0.221 ms Note the 0 rows returned via JDBC. Has anyone ever heard of
anything like this before? Thanks, Tyler Hains IT Director ProfitPoint, Inc. |
