Duplicates for primary keys and UNIQUEs

[federico-razzoli]

mysql> CREATE TABLE t (a INT, b INT NOT NULL, PRIMARY KEY (a), UNIQUE (b)) ENGINE WARP;
Query OK, 0 rows affected (0.05 sec)

mysql> INSERT INTO t VALUES (1, 1);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO t VALUES (1, 1);
Query OK, 1 row affected (0.02 sec)

mysql> INSERT INTO t VALUES (1, 1);
Query OK, 1 row affected (0.05 sec)

mysql> SELECT * FROM t;
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 1 |
| 1 | 1 |
+---+---+
3 rows in set (0.02 sec)

I'm not sure if this is supposed to happen or not. If it is, please consider this bug a feature request to:

• disallow UNIQUE indexes
• issue a warning for tables with a PK

[federico-razzoli]

Duplicated by #17 , sorry for the noise.