Changeset: 78e38e367cd7 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/78e38e367cd7
Added Files:
monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
Modified Files:
monetdb5/modules/atoms/Tests/All
monetdb5/modules/atoms/Tests/contains.test
monetdb5/modules/atoms/Tests/endswith.test
monetdb5/modules/atoms/Tests/startswith.test
Branch: sw_ew_c_sorting
Log Message:
Split join tests.
diffs (251 lines):
diff --git a/monetdb5/modules/atoms/Tests/All b/monetdb5/modules/atoms/Tests/All
--- a/monetdb5/modules/atoms/Tests/All
+++ b/monetdb5/modules/atoms/Tests/All
@@ -38,5 +38,6 @@ startswith
endswith
contains
HAVE_ICONV?asciify
+starts_ends_contains_joins
ts_and_tstz_to_str_bug
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
@@ -57,14 +57,8 @@ 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
----
@@ -75,24 +69,5 @@ 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
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
@@ -47,14 +47,8 @@ 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
----
@@ -65,24 +59,5 @@ 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/starts_ends_contains_joins.test
b/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
@@ -0,0 +1,101 @@
+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 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
+
+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 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
+
+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 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
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
@@ -47,14 +47,8 @@ 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
----
@@ -65,29 +59,10 @@ 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
-
query T
-select ['Camón Romasan'] startsWith ['camu', true];
+select ['Camón Romasan'] startswith ['camu', true];
----
False
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
