| Bug #28055 | Falcon wrong comparison of columns of data type date in join | ||
|---|---|---|---|
| Submitted: | 23 Apr 2007 23:03 | ||
| Reporter: | Hakan Küçükyılmaz | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Falcon storage engine | Severity: | S3 (Non-critical) |
| Version: | 6.0.0-alpha | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[23 Apr 2007 23:03]
Hakan Küçükyılmaz
Test case is falcon_bug_28055.test.
Description: Wrong comparison of columns of data type date in join. How to repeat: Simplyfied testcase derived from innodb.test: SET storage_engine= Falcon; create table t1(a date); create table t2(a date, key(a)); insert into t1 values('2005-10-01'); insert into t2 values('2005-10-01'); select * from t1 where t1.a between t1.a and t1.a; a 2005-10-01 select * from t1, t2 where t2.a = t1.a; a a <empty> <---- Where is the record ?