Hi everybody,

I just upgraded from 4.0.15 to 4.1.1 on my Windows NT station in order to be able to use subqueries (and for the sheer fun of it I have to admit :-)

But I almost immediately stumbled on a BUG problem! Now the simple requests below don't work anymore at all !

I have a table CDR with columns say DATE BLOCK COUNTRY MINUTES (Date) (Varchar(15)) (Varchar(15)) (Float) 2004-01-10 44011 GBRF xx 2004-01-12 44013 GBRF xx 2004-02-15 49016 DEUF xx 2004-02-17 49061 DEUF xx

These are phone calls to certain block numbers in different countries (here UK and Germany fixed phones)

The request SELECT block FROM cdr WHERE Date between '2004-01-01' AND '2004-04-01' and country = 'GBRF' returns > 1000 rows

Now if I add "group by block" at the end it returns... empty set !

But if I reduce the date interval to, say '2004-01-01' to '2004-01-13' if returns... 245 rows !!!

If I remove the "group by block" again it returns > 1000 rows

So it looks like when I ask *simultaneously* for a "group by block" and an end_date that goes beyond '2004-03-11' (found by dichotomy) MySQL 4.1.1 returns an empty set. How can this be ?

The query uses an index that's made of ( COUNTRY, DATE, (another field) )

Since the empty set is returned instantly I suspect that this has something to do with the index not being correctly migrated from 4.0.15 to 4.1.1. Does anyone here have a clue about that ?

Please help if you can and don't hesitate to ask for any more info should you need them. If this really is a MySQL 4.1.1 bug then it's critical (wrong results) and I'll have to downgrade to old 4.0.15 ASAP which I expect to be a real pain.

Thank you all in advance!

Christian