Bug #8772 Whan using MEMORY tables with HASH indexes can't insert multiply times in to me

• Submitted: 24 Feb 2005 10:31
• Modified: 24 Feb 2005 10:39
• Reporter: Serge Zabigaylo
• Status: Can't repeat
• Category: MySQL Server: Optimizer
• Severity: S2 (Serious)
• Version: 5.0.2-alpha
• OS: Linux (Linux)
• CPU Architecture: Any

[24 Feb 2005 10:31] Serge Zabigaylo

Description:

Whan using MEMORY tables with HASH indexes can't insert multiply times in to memory table.

With BTREE index all ok.

How to repeat:
Whan executing:

CREATE TEMPORARY TABLE t(cl0 INT,INDEX USING HASH (cl0)) ENGINE=MEMORY;

INSERT INTO t SELECT 1 cl0;
INSERT INTO t SELECT 2 cl0;

select cl0 from t  where cl0=2

^^^-------- Result is empty set --------------

CREATE TEMPORARY TABLE t(cl0 INT,INDEX USING BTREE (cl0)) ENGINE=MEMORY;

INSERT INTO t SELECT 1 cl0;
INSERT INTO t SELECT 2 cl0;

select cl0 from t  where cl0=2

^^^-------- Result is 2 --------------

[24 Feb 2005 10:39] MySQL Verification Team

Hi,

Thank you for the report, but I can't repeat it with 5.0.3-alpha-log

mysql> CREATE TEMPORARY TABLE t(cl0 INT,INDEX USING HASH (cl0)) ENGINE=MEMORY;
Query OK, 0 rows affected (0.08 sec)

mysql>
mysql> INSERT INTO t SELECT 1 cl0;
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql> INSERT INTO t SELECT 2 cl0;
Query OK, 1 row affected (0.00 sec)
Records: 1  Duplicates: 0  Warnings: 0

mysql>
mysql> select cl0 from t  where cl0=2;
+------+
| cl0  |
+------+
|    2 |
+------+
1 row in set (0.07 sec)