Hi,

> I thought that FB optimizer cleans these type of things,

You thought right. There should be no difference using "1=1 and" or not
using it. I for myself use this kind of things a lot and *never* got a bad
behavior as you're seeing -- but I only work with FB 1.5 and 2.1 thoug
(never tested it on 2.0)

Firebird sould (and do) use the date field index and ignore the 1=1 part
(OR... it checks the 1=1 for each record brought by the indexed search which
will not slow down your query anyway)


Regards,
Anderson Farias