Changeset: 26384485bebc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/26384485bebc
Modified Files:
monetdb5/modules/atoms/Tests/endswith.test
monetdb5/modules/atoms/Tests/startswith.test
Branch: txtsim-imp
Log Message:
Tests for startswith/endswith
diffs (102 lines):
diff --git a/monetdb5/modules/atoms/Tests/endswith.test
b/monetdb5/modules/atoms/Tests/endswith.test
--- a/monetdb5/modules/atoms/Tests/endswith.test
+++ b/monetdb5/modules/atoms/Tests/endswith.test
@@ -42,3 +42,47 @@ query T
select endswith('Thomas Müller', 'müller', false)
----
False
+
+statement ok
+create table foo(x string)
+
+statement ok
+create table bar(x string)
+
+statement ok
+insert into foo values
('johnleft'),('janeright'),('robertright'),('timup'),('lexleft'),('joeleft')
+
+statement ok
+insert into bar values ('left'),('right'),('up'),('down')
+
+query T
+select endswith(x, 'left') from foo
+----
+True
+False
+False
+False
+True
+True
+
+query TT rowsort
+select * from foo,bar where [foo.x] endswith [bar.x, false]
+----
+janeright
+right
+joeleft
+left
+johnleft
+left
+lexleft
+left
+robertright
+right
+timup
+up
+
+statement ok
+drop table foo
+
+statement ok
+drop table bar
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
@@ -42,3 +42,47 @@ query T
select startswith('Müller Thomas', 'müller', false)
----
False
+
+statement ok
+create table foo(x string)
+
+statement ok
+create table bar(x string)
+
+statement ok
+insert into foo values
('leftjohn'),('rightjane'),('rightrobert'),('uptim'),('leftlex'),('leftjoe')
+
+statement ok
+insert into bar values ('left'),('right'),('up'),('down')
+
+query T
+select startswith(x, 'left') from foo
+----
+True
+False
+False
+False
+True
+True
+
+query TT rowsort
+select * from foo,bar where [foo.x] startswith [bar.x, false]
+----
+leftjoe
+left
+leftjohn
+left
+leftlex
+left
+rightjane
+right
+rightrobert
+right
+uptim
+up
+
+statement ok
+drop table foo
+
+statement ok
+drop table bar
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
