summaryrefslogtreecommitdiff
path: root/mysql-test/t/mysqltest.test
diff options
context:
space:
mode:
authorsasha@asksasha.com <>2006-01-30 20:58:17 -0700
committersasha@asksasha.com <>2006-01-30 20:58:17 -0700
commit144490850a8baad7e4afc0c1bff920edc008aa88 (patch)
treea43903bfd18ddb15a24702478bd33e71a051f932 /mysql-test/t/mysqltest.test
parent86a15e5e86f5365b3e217ad0bdbaa56685d6a6d2 (diff)
parentfdefc7e03df7750ba732380f5c13fe46d52516a2 (diff)
downloadmariadb-git-144490850a8baad7e4afc0c1bff920edc008aa88.tar.gz
Merge spachev@bk-internal.mysql.com:/home/bk/mysql-5.1-new
into asksasha.com:/reiser-data/mysql-dev/mysql-5.1-new
Diffstat (limited to 'mysql-test/t/mysqltest.test')
-rw-r--r--mysql-test/t/mysqltest.test27
1 files changed, 27 insertions, 0 deletions
diff --git a/mysql-test/t/mysqltest.test b/mysql-test/t/mysqltest.test
index 55f08c28719..f928f0d3e6f 100644
--- a/mysql-test/t/mysqltest.test
+++ b/mysql-test/t/mysqltest.test
@@ -1061,3 +1061,30 @@ drop table t1;
drop table t1;
+# test for replace_regex
+--replace_regex /at/b/
+select "at" as col1, "c" as col2;
+
+--replace_regex /at/b/i
+select "at" as col1, "AT" as col2, "c" as col3;
+
+--replace_regex /a/b/ /ct/d/
+select "a" as col1, "ct" as col2;
+
+--replace_regex /(strawberry)/raspberry and \1/ /blueberry/blackberry/ /potato/tomato/;
+select "strawberry","blueberry","potato";
+
+--error 1
+--exec echo "--replace_regex a" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "--replace_regex a;" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "replace_regex a;" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "replace_regex a ;" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "replace_regex a b; echo OK;" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "--replace_regex /a b c" | $MYSQL_TEST 2>&1
+--error 1
+--exec echo "replace_regex /a /b c ;" | $MYSQL_TEST 2>&1