On 2001 May 14, Peter John Walsh <pete...@compenv.ie> wrote:
I've noticed some strange behaviour while using the 'BETWEEN' operator.
Basically,
This returns nothing:
SELECT * FROM Dogs WHERE Date_Scanned BETWEEN '2001/01/01' AND '2003/01/01'
This works fine:
SELECT * FROM Dogs WHERE '2001/01/01' <= Date_Scanned AND '2003/01/01' >=
Date_Scanned
I've tested it from various clients, and that made no difference. I'm
running server version
3.22.25-log. Apologies if I've wasted anyones time with this trivial issue!
Hi, Peter. Thanks for the report. Unfortunately, it's not useful.
First, no test case. Second, an old version of MySQL. If you can
make a repeatable case that breaks 3.22.32 (or preferably 3.23.38),
post it here.
Thanks,
Tim
3 messages in com.mysql.lists.bugsRe: Possible bug with 'BETWEEN' operator
