summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_regexp.test
diff options
context:
space:
mode:
authorunknown <monty@donna.mysql.fi>2001-04-11 20:19:52 +0300
committerunknown <monty@donna.mysql.fi>2001-04-11 20:19:52 +0300
commit9bf58f4fac22a61190b26a13b7ef6f5ec2b85ff2 (patch)
tree0c2df4ea1281838e375d4087e0cd217f5de5140d /mysql-test/t/func_regexp.test
parent494a3a0fc74ef5ea5547e54603808b11221ec4c1 (diff)
downloadmariadb-git-9bf58f4fac22a61190b26a13b7ef6f5ec2b85ff2.tar.gz
Fixed bug in REGEXP for Linux Alpha
Docs/manual.texi: Updated MyODBC section libmysql/conf_to_src.c: Fixed wrong typecast mysql-test/r/func_regexp.result: Added test case for REGEXP bug mysql-test/t/func_regexp.test: Added test case for REGEXP bug regex/engine.c: Fixed wrong type regex/regexec.c: Fixed wrong type sql/records.cc: Fixed test of READ lock sql/slave.cc: Cleanup
Diffstat (limited to 'mysql-test/t/func_regexp.test')
-rw-r--r--mysql-test/t/func_regexp.test18
1 files changed, 18 insertions, 0 deletions
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;