Changeset: a1e7b356a7a9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/a1e7b356a7a9
Added Files:
sql/test/Tests/regexp.test
Modified Files:
sql/test/Tests/All
Branch: default
Log Message:
Adds tests for regexp_replace
diffs (77 lines):
diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -1,6 +1,7 @@
# Run these first so comment-dump doesn't encounter
# leftovers from other tests
HAVE_LIBPCRE?comment-dump
+HAVE_LIBPCRE?regexp
comment-on
comment-auth-1
USER=user_a&PASSWD=user_a?comment-auth-2
diff --git a/sql/test/Tests/regexp.test b/sql/test/Tests/regexp.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/regexp.test
@@ -0,0 +1,61 @@
+# for the regex options look into `man 3 pcreapi`
+
+# basic
+query T rowsort
+select regexp_replace('foobarbaz', 'b(..)', 'XY')
+----
+fooXYXY
+
+# regex options - capture groups
+query T rowsort
+select regexp_replace('foobarbaz', 'b(..)', 'X\\1Y')
+----
+fooXarYXazY
+
+# regex options - case sensitive
+query T rowsort
+select regexp_replace('fooBarBaz', 'b(..)', 'XY')
+----
+fooBarBaz
+
+# regex options - case insensitive
+query T rowsort
+select regexp_replace('fooBarBaz', 'b(..)', 'XY', 'i')
+----
+fooXYXY
+
+# regex options - no dotall
+query T rowsort
+select regexp_replace('foo\nbar', 'foo.+', 'XYZ')
+----
+foo@bar
+
+# regex options - dotall
+query T rowsort
+select regexp_replace('foo\nbar', 'foo.+', 'XYZ', 's')
+----
+XYZ
+
+# regex options - no multiline
+query T rowsort
+select regexp_replace('foo\nbar', '^(foo).*$', 'XYZ')
+----
+foo@bar
+
+# regex options - multiline
+query T rowsort
+select regexp_replace('foo\nbar', '^(foo).*$', 'XYZ', 'm')
+----
+XYZ@bar
+
+# regex option - not extended
+query T rowsort
+select regexp_replace('foo', 'f o o', 'XYZ')
+----
+foo
+
+# regex option - not extended
+query T rowsort
+select regexp_replace('foo', 'f o o', 'XYZ', 'x')
+----
+XYZ
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
