Changeset: 61fda19f7918 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/61fda19f7918
Added Files:
monetdb5/modules/kernel/Tests/batendswith.test
Modified Files:
monetdb5/modules/kernel/Tests/All
monetdb5/modules/kernel/Tests/batstartswith.test
Branch: txtsim
Log Message:
More testing(more to come)
diffs (134 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
@@ -3,3 +3,6 @@ TriBool
batstr
math
select
+
+batstartswith
+batendswith
diff --git a/monetdb5/modules/kernel/Tests/batendswith.test
b/monetdb5/modules/kernel/Tests/batendswith.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/kernel/Tests/batendswith.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/batstartswith.test
b/monetdb5/modules/kernel/Tests/batstartswith.test
--- a/monetdb5/modules/kernel/Tests/batstartswith.test
+++ b/monetdb5/modules/kernel/Tests/batstartswith.test
@@ -1,31 +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 stringtest values ('johndoe'),('janedoe'),('robertdoe')
-
-statement ok
-create function startsWith(x string, y string) returns bool external name
str."startsWith"
+insert into foo values ('johndoe'),('janedoe'),('robertdoe')
query T rowsort
-select startsWith('', '')
+select startswith(x, '') from foo
----
-true
-
-query T rowsort
-select startsWith('johndoe', '')
+True
+True
+True
query T rowsort
-select startsWith('johndoe', 'john')
+select startswith('', x) from foo
+----
+False
+False
+False
-query T rowsort
-select startsWith(x, '')
+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)
+select startswith(x, 'Müller') from bar
+----
+False
+False
+True
statement ok
-drop function startsWith
+drop table bar
statement ok
-drop table stringtest
+drop function startswith
+
+statement ok
+drop function istartswith
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
