diff options
author | unknown <monty@donna.mysql.fi> | 2001-04-11 20:19:52 +0300 |
---|---|---|
committer | unknown <monty@donna.mysql.fi> | 2001-04-11 20:19:52 +0300 |
commit | 9bf58f4fac22a61190b26a13b7ef6f5ec2b85ff2 (patch) | |
tree | 0c2df4ea1281838e375d4087e0cd217f5de5140d /mysql-test/t/func_regexp.test | |
parent | 494a3a0fc74ef5ea5547e54603808b11221ec4c1 (diff) | |
download | mariadb-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.test | 18 |
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; |