Changeset: 35dfb9a4a503 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/35dfb9a4a503
Modified Files:
monetdb5/modules/atoms/Tests/contains.test
Branch: txtsim-imp
Log Message:
Tests for contains
diffs (51 lines):
diff --git a/monetdb5/modules/atoms/Tests/contains.test
b/monetdb5/modules/atoms/Tests/contains.test
--- a/monetdb5/modules/atoms/Tests/contains.test
+++ b/monetdb5/modules/atoms/Tests/contains.test
@@ -52,3 +52,47 @@ query T
select contains('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
('johnleft'),('janeright'),('robertright'),('timup'),('lexleft'),('joeleft')
+
+statement ok
+insert into bar values ('left'),('right'),('up'),('down')
+
+query T
+select contains(x, 'left') from foo
+----
+True
+False
+False
+False
+True
+True
+
+query TT rowsort
+select * from foo,bar where [foo.x] contains [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
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
