Changeset: 619c4a6d52ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=619c4a6d52ba
Added Files:
sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.sql
sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.err
sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.out
Modified Files:
sql/test/BugTracker-2020/Tests/All
Branch: Jun2020
Log Message:
Added test and output for bug 6864
diffs (101 lines):
diff --git a/sql/test/BugTracker-2020/Tests/All
b/sql/test/BugTracker-2020/Tests/All
--- a/sql/test/BugTracker-2020/Tests/All
+++ b/sql/test/BugTracker-2020/Tests/All
@@ -8,3 +8,4 @@ cume-dist-wrong-results.Bug-6827
window-order-by-extract.Bug-6828
ntile-wrong-results.Bug-6829
HAVE_PYMONETDB?global_table_propagation.Bug-6846
+ilike-matches.Bug-6864
diff --git a/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.sql
b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.sql
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.sql
@@ -0,0 +1,23 @@
+start transaction;
+
+create table tab1 (col1 string);
+insert into tab1 values ('Guatemala'), ('Guatemala-Mobile'),
+('Guatemala-Mobile Comcel'), ('Guatemala-Mobile Movistar'), ('Guatemala-Mobile
PCS'),
+('Guatemala-Telgua'), ('Guatemala-Telefonica');
+
+SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%';
+ -- Guatemala
+ -- Guatemala-Mobile
+ -- Guatemala-Mobile Comcel
+ -- Guatemala-Mobile Movistar
+ -- Guatemala-Mobile PCS
+ -- Guatemala-Telgua
+ -- Guatemala-Telefonica
+
+SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%com%';
+ -- Guatemala-Mobile Comcel
+
+SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%mo%com%';
+ -- Guatemala-Mobile Comcel
+
+rollback;
diff --git a/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.err
b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.err
@@ -0,0 +1,12 @@
+stderr of test 'ilike-matches.Bug-6864` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 11:35:35 >
+# 11:35:35 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-185617" "--port=30444"
+# 11:35:35 >
+
+
+# 11:35:35 >
+# 11:35:35 > "Done."
+# 11:35:35 >
+
diff --git a/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.out
b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2020/Tests/ilike-matches.Bug-6864.stable.out
@@ -0,0 +1,43 @@
+stdout of test 'ilike-matches.Bug-6864` in directory
'sql/test/BugTracker-2020` itself:
+
+
+# 11:35:35 >
+# 11:35:35 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e"
"--host=/var/tmp/mtest-185617" "--port=30444"
+# 11:35:35 >
+
+#start transaction;
+#create table tab1 (col1 string);
+#insert into tab1 values ('Guatemala'), ('Guatemala-Mobile'),
+#('Guatemala-Mobile Comcel'), ('Guatemala-Mobile Movistar'),
('Guatemala-Mobile PCS'),
+#('Guatemala-Telgua'), ('Guatemala-Telefonica');
+[ 7 ]
+#SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%';
+% sys.tab1 # table_name
+% col1 # name
+% clob # type
+% 25 # length
+[ "Guatemala" ]
+[ "Guatemala-Mobile" ]
+[ "Guatemala-Mobile Comcel" ]
+[ "Guatemala-Mobile Movistar" ]
+[ "Guatemala-Mobile PCS" ]
+[ "Guatemala-Telgua" ]
+[ "Guatemala-Telefonica" ]
+#SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%com%';
+% sys.tab1 # table_name
+% col1 # name
+% clob # type
+% 23 # length
+[ "Guatemala-Mobile Comcel" ]
+#SELECT DISTINCT col1 FROM tab1 WHERE col1 ILIKE '%guate%mo%com%';
+% sys.tab1 # table_name
+% col1 # name
+% clob # type
+% 23 # length
+[ "Guatemala-Mobile Comcel" ]
+#rollback;
+
+# 11:35:35 >
+# 11:35:35 > "Done."
+# 11:35:35 >
+
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
