summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.fi>2001-04-11 20:23:31 +0300
committerunknown <monty@donna.mysql.fi>2001-04-11 20:23:31 +0300
commitc164b35345a8cb1c7fbece2a2dec59c33609850d (patch)
treeb1d74abd0e378af3e21cf8c6904dd45011ff7d3f /mysql-test
parent2adf9320a45a28415d08658015b66d31a590e0e9 (diff)
parent9bf58f4fac22a61190b26a13b7ef6f5ec2b85ff2 (diff)
downloadmariadb-git-c164b35345a8cb1c7fbece2a2dec59c33609850d.tar.gz
Merge work:/home/bk/mysql into donna.mysql.fi:/home/my/bk/mysql
sql/slave.cc: Auto merged BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/r/func_regexp.result10
-rw-r--r--mysql-test/t/func_regexp.test18
2 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/r/func_regexp.result b/mysql-test/r/func_regexp.result
index 05b324d0c9e..5927dba0974 100644
--- a/mysql-test/r/func_regexp.result
+++ b/mysql-test/r/func_regexp.result
@@ -13,3 +13,13 @@ NULL
NULL
NULL
NULL
+xxx
+this is a test of some long text to see what happens
+xxx
+this is a test of some long text to see what happens
+xxx
+this is a test of some long text to see what happens
+xxx
+this is a test of some long text to see what happens
+xxx
+this is some text: to test - out.reg exp (22/45)
diff --git a/mysql-test/t/func_regexp.test b/mysql-test/t/func_regexp.test
index 12341f1a661..7fbe4000cfc 100644
--- a/mysql-test/t/func_regexp.test
+++ b/mysql-test/t/func_regexp.test
@@ -2,6 +2,7 @@
# Some regexp tests
#
+drop table if exists t1;
create table t1 (s1 char(64),s2 char(64));
insert into t1 values('aaa','aaa');
@@ -24,3 +25,20 @@ insert into t1 values('ghi','ghi[');
select HIGH_PRIORITY s1 regexp s2 from t1;
drop table t1;
+
+#
+# This test a bug in regexp on Alpha
+#
+
+create table t1 (xxx char(128));
+insert into t1 (xxx) values('this is a test of some long text to see what happens');
+select * from t1 where xxx regexp('is a test of some long text to');
+select * from t1 where xxx regexp('is a test of some long text to ');
+select * from t1 where xxx regexp('is a test of some long text to s');
+select * from t1 where xxx regexp('is a test of some long text to se');
+drop table t1;
+
+create table t1 (xxx char(128));
+insert into t1 (xxx) values('this is some text: to test - out.reg exp (22/45)');
+select * from t1 where xxx REGEXP '^this is some text: to test - out\\.reg exp [[(][0-9]+[/\\][0-9]+[])][ ]*$';
+drop table t1;