Re: Spurious SQL Results

Posted in 1996

Vic Goldberg — Thu, 21 Nov 1996 10:52:41 -0500 — source: Informix-list mailing list archive (1991-1998)

Carol Davies wrote: > We are getting spurious (unexpected, wrong) results from SQL statements > which disappear when the SQL is prepared. Doesn't exactly match the circumstances, but I've had similar problems with a damaged index. Do an oncheck, and check that your index pages are all good. Depending on the query, you might be hitting different query plans with the different methods of executing it. -- Victor Goldberg (607) 254-7441 Cornell Theory Center (607) 254-8888 (fax) 520 Rhodes Hall vic@tc.cornell.edu Ithaca, NY 14850