Optimizer - Bug: Ignoring Index

Hi,

I was wondering, whether it is a bug or normal behavior:

Having a table foo containing a date-field named "bar", and defined as 
an index, I run a select as:

explain select * from foo where bar between '2005-01-01' and '2005-01-31'

the index over bar is used. But since I don't know the maximum number of 
days I used subdate('2005-02-01', 1) for calculating the last day of the 
Month. But when using this inside my query as:

explain select * from foo where bar between '2005-01-01' and 
subdate('2005-02-01', 1)

maxdb performs a tablescan instead of using the index. This behavior 
started after upgrading from 7.3.??? to 7.5.21 - as far as I can remember.

From my point of view, there is no point in doing a tablescan, so I 
would call it a bug..

Thanks,

Dirk Zugenmaier

-------------------------------
 Universitätsklinikum Freiburg
 Klinikrechenzentrum, Abt. PDV
 Agnesenstr. 6-8
 79106 Freiburg
-------------------------------

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx