summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap.result
diff options
context:
space:
mode:
authorunknown <monty@hundin.mysql.fi>2002-03-12 11:52:41 +0200
committerunknown <monty@hundin.mysql.fi>2002-03-12 11:52:41 +0200
commit6e37987c512b4fb3b11f347b050eeabf30bfae04 (patch)
treecc5ddb707fd6b0aa9b53c89ae0d0fc731486fef9 /mysql-test/r/heap.result
parent016a6cd3857503cf6e4604e3168d3c860557a572 (diff)
downloadmariadb-git-6e37987c512b4fb3b11f347b050eeabf30bfae04.tar.gz
Fixed mysqldumpslow for new dump format.
Fix for HEAP tables with many rows deleted. Add '' arround database names in SHOW GRANT Docs/manual.texi: Fixed symlink examples. heap/hp_rfirst.c: Remove not needed patch. mysql-test/r/heap.result: Added test case for HEAP + many deletes mysql-test/t/heap.test: Added test case for HEAP + many deletes mysys/mf_loadpath.c: Resolve path's even if they don't end in '/' scripts/mysqldumpslow.sh: Fix for new dump format. sql/handler.cc: Fix for HEAP tables with many rows deleted. sql/sql_acl.cc: Add '' arround database names in SHOW GRANT
Diffstat (limited to 'mysql-test/r/heap.result')
-rw-r--r--mysql-test/r/heap.result6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result
index a7a69694b65..13f452e26d8 100644
--- a/mysql-test/r/heap.result
+++ b/mysql-test/r/heap.result
@@ -197,3 +197,9 @@ a b
INSERT INTO t1 VALUES (1,3);
Duplicate entry '3' for key 1
DROP TABLE t1;
+CREATE TABLE t1 (a int not null, primary key(a)) type=heap;
+INSERT into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11);
+DELETE from t1 where a < 100;
+SELECT * from t1;
+a
+DROP TABLE t1;