summaryrefslogtreecommitdiff
path: root/mysql-test/t/myisam.test
diff options
context:
space:
mode:
authorunknown <serg@serg.mylan>2004-08-30 16:12:53 +0200
committerunknown <serg@serg.mylan>2004-08-30 16:12:53 +0200
commit3833d05cc54c3f598ca0c6f8cbecf1abf40f3e3e (patch)
tree2b89c53b35971692a295d551d515400f65255c72 /mysql-test/t/myisam.test
parentf1b815bd52eb590fc753e4c728871ae14d2d63ed (diff)
downloadmariadb-git-3833d05cc54c3f598ca0c6f8cbecf1abf40f3e3e.tar.gz
space-stripping in _mi_prefix_search: BUG#5284
Diffstat (limited to 'mysql-test/t/myisam.test')
-rw-r--r--mysql-test/t/myisam.test12
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/t/myisam.test b/mysql-test/t/myisam.test
index e6d47b5c570..f9081e8769b 100644
--- a/mysql-test/t/myisam.test
+++ b/mysql-test/t/myisam.test
@@ -423,6 +423,18 @@ select * from t1 where a='807780' and b='477' and c='165';
drop table t1;
#
+# space-stripping in _mi_prefix_search: BUG#5284
+#
+DROP TABLE IF EXISTS t1;
+CREATE TABLE t1 (a varchar(150) NOT NULL, KEY (a));
+INSERT t1 VALUES ("can \tcan");
+INSERT t1 VALUES ("can can");
+INSERT t1 VALUES ("can");
+SELECT * FROM t1;
+CHECK TABLE t1;
+DROP TABLE t1;
+
+#
# Verify blob handling
#
create table t1 (a blob);