Changeset: aa1636af66f0 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/aa1636af66f0
Added Files:
monetdb5/modules/kernel/Tests/batstr_endswith.test
monetdb5/modules/kernel/Tests/batstr_reverse.test
monetdb5/modules/kernel/Tests/batstr_startswith.test
Removed Files:
monetdb5/modules/kernel/Tests/batendswith.test
monetdb5/modules/kernel/Tests/batstartswith.test
Modified Files:
monetdb5/modules/kernel/Tests/All
Branch: txtsim
Log Message:
More test on startswith, endswith and reverse.
diffs (290 lines):
diff --git a/monetdb5/modules/kernel/Tests/All
b/monetdb5/modules/kernel/Tests/All
--- a/monetdb5/modules/kernel/Tests/All
+++ b/monetdb5/modules/kernel/Tests/All
@@ -4,5 +4,7 @@ batstr
math
select
-batstartswith
-batendswith
+batstr_reverse
+
+batstr_startswith
+batstr_endswith
diff --git a/monetdb5/modules/kernel/Tests/batendswith.test
b/monetdb5/modules/kernel/Tests/batendswith.test
deleted file mode 100644
--- a/monetdb5/modules/kernel/Tests/batendswith.test
+++ /dev/null
@@ -1,50 +0,0 @@
-statement ok
-create function endswith(x string, y string) returns bool external name
str."endsWith"
-
-statement ok
-create function iendswith(x string, y string, i bool) returns bool external
name str."endsWith"
-
-statement ok
-create table foo(x string)
-
-statement ok
-insert into foo values ('johndoe'),('janedoe'),('robertdoe')
-
-query T rowsort
-select endswith(x, '') from foo
-----
-True
-True
-True
-
-query T rowsort
-select endswith('', x) from foo
-----
-False
-False
-False
-
-statement ok
-drop table foo
-
-statement ok
-create table bar(x string, y string)
-
-statement ok
-insert into bar values ('johndoe','doe'),('Müller Thomas', 'Thomas
Müller'),('Thomas Müller', 'Müller Thomas')
-
-query T rowsort
-select endswith(x, 'Müller') from bar
-----
-False
-False
-True
-
-statement ok
-drop table bar
-
-statement ok
-drop function endswith
-
-statement ok
-drop function iendswith
diff --git a/monetdb5/modules/kernel/Tests/batstartswith.test
b/monetdb5/modules/kernel/Tests/batstartswith.test
deleted file mode 100644
--- a/monetdb5/modules/kernel/Tests/batstartswith.test
+++ /dev/null
@@ -1,50 +0,0 @@
-statement ok
-create function startswith(x string, y string) returns bool external name
str."startsWith"
-
-statement ok
-create function istartswith(x string, y string, i bool) returns bool external
name str."startsWith"
-
-statement ok
-create table foo(x string)
-
-statement ok
-insert into foo values ('johndoe'),('janedoe'),('robertdoe')
-
-query T rowsort
-select startswith(x, '') from foo
-----
-True
-True
-True
-
-query T rowsort
-select startswith('', x) from foo
-----
-False
-False
-False
-
-statement ok
-drop table foo
-
-statement ok
-create table bar(x string, y string)
-
-statement ok
-insert into bar values ('johndoe','doe'),('Müller Thomas', 'Thomas
Müller'),('Thomas Müller', 'Müller Thomas')
-
-query T rowsort
-select startswith(x, 'Müller') from bar
-----
-False
-False
-True
-
-statement ok
-drop table bar
-
-statement ok
-drop function startswith
-
-statement ok
-drop function istartswith
diff --git a/monetdb5/modules/kernel/Tests/batstr_endswith.test
b/monetdb5/modules/kernel/Tests/batstr_endswith.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/kernel/Tests/batstr_endswith.test
@@ -0,0 +1,50 @@
+statement ok
+create function endswith(x string, y string) returns bool external name
str."endsWith"
+
+statement ok
+create function iendswith(x string, y string, i bool) returns bool external
name str."endsWith"
+
+statement ok
+create table foo(x string)
+
+statement ok
+insert into foo values ('johndoe'),('janedoe'),('robertdoe')
+
+query T rowsort
+select endswith(x, '') from foo
+----
+True
+True
+True
+
+query T rowsort
+select endswith('', x) from foo
+----
+False
+False
+False
+
+statement ok
+drop table foo
+
+statement ok
+create table bar(x string, y string)
+
+statement ok
+insert into bar values ('johndoe','doe'),('Müller Thomas', 'Thomas
Müller'),('Thomas Müller', 'Müller Thomas')
+
+query T rowsort
+select endswith(x, 'Müller') from bar
+----
+False
+False
+True
+
+statement ok
+drop table bar
+
+statement ok
+drop function endswith
+
+statement ok
+drop function iendswith
diff --git a/monetdb5/modules/kernel/Tests/batstr_reverse.test
b/monetdb5/modules/kernel/Tests/batstr_reverse.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/kernel/Tests/batstr_reverse.test
@@ -0,0 +1,52 @@
+statement ok
+create function reverse(x string) returns string external name str.reverse
+
+statement ok
+create table foo(x string)
+
+statement ok
+insert into foo values('johndoe'), ('janedoe')
+
+query T nosort
+select reverse(x) from foo
+----
+eodnhoj
+eodenaj
+
+statement ok
+drop table foo
+
+statement ok
+create table bar(x string)
+
+statement ok
+insert into bar values('johndoe'), (''), ('janedoe')
+
+query T nosort
+select reverse(x) from bar;
+----
+eodnhoj
+(empty)
+eodenaj
+
+statement ok
+drop table bar
+
+statement ok
+create table baz(x string)
+
+statement ok
+insert into baz values('johndoe'), (NULL), ('janedoe')
+
+query T nosort
+select reverse(x) from baz;
+----
+eodnhoj
+NULL
+eodenaj
+
+statement ok
+drop table baz
+
+statement ok
+drop function reverse
diff --git a/monetdb5/modules/kernel/Tests/batstr_startswith.test
b/monetdb5/modules/kernel/Tests/batstr_startswith.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/kernel/Tests/batstr_startswith.test
@@ -0,0 +1,50 @@
+statement ok
+create function startswith(x string, y string) returns bool external name
str."startsWith"
+
+statement ok
+create function istartswith(x string, y string, i bool) returns bool external
name str."startsWith"
+
+statement ok
+create table foo(x string)
+
+statement ok
+insert into foo values ('johndoe'),('janedoe'),('robertdoe')
+
+query T rowsort
+select startswith(x, '') from foo
+----
+True
+True
+True
+
+query T rowsort
+select startswith('', x) from foo
+----
+False
+False
+False
+
+statement ok
+drop table foo
+
+statement ok
+create table bar(x string, y string)
+
+statement ok
+insert into bar values ('johndoe','doe'),('Müller Thomas', 'Thomas
Müller'),('Thomas Müller', 'Müller Thomas')
+
+query T rowsort
+select startswith(x, 'Müller') from bar
+----
+False
+False
+True
+
+statement ok
+drop table bar
+
+statement ok
+drop function startswith
+
+statement ok
+drop function istartswith
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
