Changeset: b836db37f420 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/b836db37f420
Modified Files:
monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
monetdb5/modules/kernel/Tests/All
monetdb5/modules/kernel/Tests/batstr_endswith.test
monetdb5/modules/kernel/Tests/batstr_startswith.test
Branch: sw_ew_c_sorting
Log Message:
Re arrange testing for startswith, endswith
diffs (120 lines):
diff --git a/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
b/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
--- a/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
+++ b/monetdb5/modules/atoms/Tests/starts_ends_contains_joins.test
@@ -99,3 +99,62 @@ drop table foo
statement ok
drop table bar
+
+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')
+
+query TT
+select * from baz,bazbaz where [baz.x] startswith [bazbaz.x, true];
+----
+john doe
+john
+jane doe
+jane
+robert doe
+robert
+
+statement ok
+drop table baz
+
+statement ok
+drop table bazbaz
+
+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 ('doe'),('doe'),('doe')
+
+query T
+select baz.x from baz,bazbaz where [baz.x] endswith [bazbaz.x, true];
+----
+john doe
+john doe
+john doe
+jane doe
+jane doe
+jane doe
+robert doe
+robert doe
+robert doe
+
+statement ok
+drop table baz
+
+statement ok
+drop table bazbaz
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
@@ -5,7 +5,6 @@ math
select
HAVE_ICONV?batstr_asciify
-batstr_reverse
batstr_startswith
batstr_endswith
batstr_contains
diff --git a/monetdb5/modules/kernel/Tests/batstr_endswith.test
b/monetdb5/modules/kernel/Tests/batstr_endswith.test
--- a/monetdb5/modules/kernel/Tests/batstr_endswith.test
+++ b/monetdb5/modules/kernel/Tests/batstr_endswith.test
@@ -72,19 +72,6 @@ john doe
jane doe
robert doe
-query T rowsort
-select baz.x from baz,bazbaz where [baz.x] endswith [bazbaz.x, true];
-----
-jane doe
-jane doe
-jane doe
-john doe
-john doe
-john doe
-robert doe
-robert doe
-robert doe
-
statement ok
drop table baz
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
@@ -72,16 +72,6 @@ query T
select * from baz where [baz.x] startswith ['doe', true];
----
-query TT
-select * from baz,bazbaz where [baz.x] startswith [bazbaz.x, true];
-----
-john doe
-john
-jane doe
-jane
-robert doe
-robert
-
statement ok
drop table baz
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
