diff options
| author | Sergei Golubchik <sergii@pisem.net> | 2013-02-28 21:48:47 +0100 |
|---|---|---|
| committer | Sergei Golubchik <sergii@pisem.net> | 2013-02-28 21:48:47 +0100 |
| commit | c4341d50950224bb4e976fd1aac23dddc7d78f71 (patch) | |
| tree | 9fa2f700cbe0283ffaf3d7da57238fb4f7e96e25 /mysql-test/r/heap.result | |
| parent | 0d55ebc05ea303a9aea44d953abbc335c12c9330 (diff) | |
| parent | 5dec570d7c1e2a39b67503a90d2d7905ac4dbb44 (diff) | |
| download | mariadb-git-c4341d50950224bb4e976fd1aac23dddc7d78f71.tar.gz | |
5.2 -> 5.3
Diffstat (limited to 'mysql-test/r/heap.result')
| -rw-r--r-- | mysql-test/r/heap.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index 124aecf5c3c..2aa7b9a3d62 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -738,3 +738,23 @@ SELECT c2 FROM t1; c2 0 DROP TABLE t1; +CREATE TABLE t1 ( +id int(11) NOT NULL AUTO_INCREMENT, +color enum('GREEN', 'WHITE') DEFAULT NULL, +ts int, +PRIMARY KEY (id), +KEY color (color) USING HASH +) ENGINE=MEMORY DEFAULT CHARSET=utf8; +INSERT INTO t1 VALUES("1","GREEN",1); +INSERT INTO t1 VALUES("2","GREEN",1); +INSERT INTO t1 VALUES("3","GREEN",1); +INSERT INTO t1 VALUES("4","GREEN",1); +INSERT INTO t1 VALUES("5","GREEN",1); +INSERT INTO t1 VALUES("6","GREEN",1); +DELETE FROM t1 WHERE id = 1; +INSERT INTO t1 VALUES("7","GREEN", 2); +DELETE FROM t1 WHERE ts = 1 AND color = 'GREEN'; +SELECT * from t1; +id color ts +7 GREEN 2 +DROP TABLE t1; |