re: Re: Select with order by clause on a MySQL BDB table returning incorrect

Sridhar, Wednesday, September 25, 2002, 6:11:30 PM, you wrote: SP Currently i get around this issue by analyzing the BDB tables, but this SP seems to be a temporary solution. The issue is intermittent, keeps SP surfacing SP again after a certain no of days. Did not find any related bugs with

re: Select with order by clause on a MySQL BDB table returning incorrect

Sridhar, Wednesday, September 25, 2002, 12:23:29 AM, you wrote: SP One of our MySQL db's containing BDB tables is exhibiting a strange SP behavior. SP A query consisting of an ORDER BY clause is returning wrong result set. SP The SP same query when used without an ORDER BY clause returns the

Re: Select with order by clause on a MySQL BDB table returning incorrect

[EMAIL PROTECTED] wrote: Sridhar, Wednesday, September 25, 2002, 12:23:29 AM, you wrote: SP One of our MySQL db's containing BDB tables is exhibiting a strange SP behavior. SP A query consisting of an ORDER BY clause is returning wrong result set. SP The SP same query when used without

Select with order by clause on a MySQL BDB table returning incorrect

Dear List, One of our MySQL db's containing BDB tables is exhibiting a strange behavior. A query consisting of an ORDER BY clause is returning wrong result set. The same query when used without an ORDER BY clause returns the correct result set. Environment: Sun Solaris 2.7, MySQL 3.23.51, Table