Changeset: 60baca11c7f8 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/60baca11c7f8
Modified Files:
monetdb5/modules/atoms/Tests/startswith.test
monetdb5/modules/kernel/Tests/batstr_startswith.test
Branch: txtsim
Log Message:
startsWith select and join tests
diffs (110 lines):
diff --git a/monetdb5/modules/atoms/Tests/startswith.test
b/monetdb5/modules/atoms/Tests/startswith.test
--- a/monetdb5/modules/atoms/Tests/startswith.test
+++ b/monetdb5/modules/atoms/Tests/startswith.test
@@ -4,47 +4,47 @@ create function startswith(x string, y s
statement ok
create function istartswith(x string, y string, i bool) returns bool external
name str."startsWith"
-query T rowsort
+query T
select startswith(NULL, '')
----
NULL
-query T rowsort
+query T
select startswith('', NULL)
----
NULL
-query T rowsort
+query T
select startswith('', '')
----
True
-query T rowsort
+query T
select startswith('johndoe', '')
----
True
-query T rowsort
+query T
select startswith('', 'johndoe')
----
False
-query T rowsort
+query T
select startswith('johndoe', 'john')
----
True
-query T rowsort
+query T
select istartswith('one two three', 'three', true)
----
False
-query T rowsort
+query T
select istartswith('Müller Thomas', 'müller', true)
----
True
-query T rowsort
+query T
select istartswith('Müller Thomas', 'müller', false)
----
False
diff --git a/monetdb5/modules/kernel/Tests/batstr_startswith.test
b/monetdb5/modules/kernel/Tests/batstr_startswith.test
--- a/monetdb5/modules/kernel/Tests/batstr_startswith.test
+++ b/monetdb5/modules/kernel/Tests/batstr_startswith.test
@@ -48,3 +48,46 @@ drop function startswith
statement ok
drop function istartswith
+
+statement ok
+create table baz(x string)
+
+statement ok
+create table bazbaz(x string)
+
+statement ok
+insert into baz values ('john doe'),('jane doe'),('robert doe')
+
+statement ok
+insert into bazbaz values ('john'),('jane'),('robert')
+
+statement ok
+create filter function istartsWith(s1 string, s2 string, icase boolean)
external name str."startsWith";
+
+query T
+select * from baz where [baz.x] istartsWith ['john', true];
+----
+john doe
+
+query T
+select * from baz where [baz.x] istartsWith ['doe', true];
+----
+
+query TT
+select * from baz,bazbaz where [baz.x] istartsWith [bazbaz.x, true];
+----
+john doe
+john
+jane doe
+jane
+robert doe
+robert
+
+statement ok
+drop filter function istartsWith(string, string, bool)
+
+statement ok
+drop table baz
+
+statement ok
+drop table bazbaz
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
