RE: Index not functioning - update

2004-03-29 Thread Jack Coxen
PROTECTED] Sent: Monday, March 29, 2004 12:24 PM To: Jack Coxen Cc: '[EMAIL PROTECTED]'; MySQL List (E-mail) Subject: RE: Index not functioning - update just out of curiousity, have you tried the 4.1.1 version? there may (or may not) be something from 4.1.0 to 4.1.1 could be a total wa

RE: Index not functioning - update

2004-03-29 Thread dan
just out of curiousity, have you tried the 4.1.1 version? there may (or may not) be something from 4.1.0 to 4.1.1 could be a total waste of time, but you never know. Dan. On Mon, 29 Mar 2004, Jack Coxen wrote: > A quick update on this. > > I tried upgrading to the latest production MySQL - 4.0

RE: Index not functioning - update

2004-03-29 Thread Jack Coxen
A quick update on this. I tried upgrading to the latest production MySQL - 4.0.18 - with no change. So, if it's a bug, it's an unreported and uncorrected bug. Also, I tried the query against different size tables. If I try the query against ifInOctets_35, the index works. If I try it against i