Changeset: 6d5a48d485da for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/6d5a48d485da
Added Files:
sql/test/Tests/more_like_tests.test
Modified Files:
sql/test/Tests/All
Branch: Jun2023
Log Message:
Add test for regex bug
diffs (39 lines):
diff --git a/sql/test/Tests/All b/sql/test/Tests/All
--- a/sql/test/Tests/All
+++ b/sql/test/Tests/All
@@ -56,6 +56,7 @@ default
HAVE_GEOM?keys
like_tests
+more_like_tests
news
timezone
diff --git a/sql/test/Tests/more_like_tests.test
b/sql/test/Tests/more_like_tests.test
new file mode 100644
--- /dev/null
+++ b/sql/test/Tests/more_like_tests.test
@@ -0,0 +1,23 @@
+statement ok
+START TRANSACTION
+
+statement ok
+CREATE TABLE liketable (
+ str varchar(32)
+)
+
+statement ok
+INSERT INTO liketable VALUES ('PENDING_CLIENT1_IT_S_34_5643_O'),
('PENDING_CLIENT1_IT_S_34_15643_O')
+
+query T rowsort
+SELECT * FROM liketable WHERE str LIKE 'PENDING^_CLIENT1^_IT^_%^_5643^_O'
ESCAPE '^';
+----
+PENDING_CLIENT1_IT_S_34_5643_O
+
+query T rowsort
+SELECT * FROM liketable WHERE str LIKE 'PENDING^_CLIENT1^_IT^_%5643^_O' ESCAPE
'^';
+----
+PENDING_CLIENT1_IT_S_34_15643_O
+PENDING_CLIENT1_IT_S_34_5643_O
+
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
