Bug #28028 Falcon AND fails if index exists

• Submitted: 23 Apr 2007 17:25
• Reporter: Hakan Küçükyılmaz
• Status: Closed
• Category: MySQL Server: Falcon storage engine
• Severity: S3 (Non-critical)
• OS: Any
• CPU Architecture: Any

[23 Apr 2007 17:25] Hakan Küçükyılmaz

Description:
If two columns are in the same key, then
a search of the two columns together (ANDed)
results in fewer rows than expected.

This was inspired by update.test.

How to repeat:
mysql> create table t2 (
    -> place_id int (10) unsigned,
    -> ts timestamp,
    -> primary key (place_id, ts))
    -> engine = jstar;
Query OK, 0 rows affected (0.01 sec)

mysql> insert into t2 values (1,20000928174434);
Query OK, 1 row affected (0.00 sec)

mysql> select *
    -> from t2
    -> where place_id = 1
    -> and ts>='2000-09-28 00:00:00';
Empty set (0.02 sec)

mysql> select *
    -> from t2
    -> where place_id = 1
    -> and ts >= 20000928000000;
Empty set (0.00 sec)

[23 Apr 2007 17:50] Hakan Küçükyılmaz

Test case is falcon_bug_28028.test.