Changeset: d281ac9bb7c9 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/d281ac9bb7c9
Added Files:
monetdb5/modules/atoms/Tests/endswith_join.test
monetdb5/modules/atoms/Tests/startswith_join.test
Modified Files:
monetdb5/modules/atoms/Tests/All
Branch: sw_ew_c_sorting
Log Message:
inline files with other tests
diffs (224 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,8 +38,8 @@ startswith
endswith
contains
HAVE_ICONV?asciify
-starts_with_join
-ends_with_join
+startswith_join
+endswith_join
contains_join
ts_and_tstz_to_str_bug
diff --git a/monetdb5/modules/atoms/Tests/endswith_join.test
b/monetdb5/modules/atoms/Tests/endswith_join.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/atoms/Tests/endswith_join.test
@@ -0,0 +1,101 @@
+statement ok
+CREATE TABLE foo(f string)
+
+statement ok
+CREATE TABLE bar(b string)
+
+-- TRIGGERS NESTED LOOP JOIN
+statement ok
+INSERT INTO foo VALUES
('JOHNLEFT'),('TRASH1'),('TRASH2'),(NULL),(NULL),('TRASH3'),('TRASH4'),('JANERIGHT'),('robertright'),('timup'),(NULL),('lexleft'),('JOELEFT'),(NULL),('TRASH5'),('TRASH6'),('TRASH7'),('TRASH8'),('TRASH9'),('TRASH10')
+
+statement ok
+INSERT INTO bar VALUES ('left'),('right'),('up')
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] endswith [bar.b, false]
+----
+lexleft
+left
+robertright
+right
+timup
+up
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] endswith [bar.b, true]
+----
+JANERIGHT
+right
+JOELEFT
+left
+JOHNLEFT
+left
+lexleft
+left
+robertright
+right
+timup
+up
+
+statement ok
+TRUNCATE TABLE foo
+
+statement ok
+TRUNCATE TABLE bar
+
+-- TRIGGERS SORT BASED JOIN
+statement ok
+INSERT INTO foo VALUES ('Καλή'),('srauschenFrühling'),('Monokel Das
grüne'),('Χρονιά Καλή'),('bom dia, Olá'),('Risør'),('Wenn der Ölhahn
versiegt'),('Punch-Out!! WITH LYRICS'),('Super Mario Bros. 3 WITH
LYRICS'),('καταλαβαίνω Δεν'),('boa tarde, Adeus')
+
+statement ok
+INSERT INTO bar VALUES
('Δεν'),('Frühling'),(NULL),('Καλή'),('kαλή'),(NULL),('olá'),('Das
grüne'),('WITH LYRICS'),('adeus'),('früh'),('sør')
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] endswith [bar.b, false]
+----
+Monokel Das grüne
+Das grüne
+Punch-Out!! WITH LYRICS
+WITH LYRICS
+Risør
+sør
+Super Mario Bros. 3 WITH LYRICS
+WITH LYRICS
+srauschenFrühling
+Frühling
+Καλή
+Καλή
+Χρονιά Καλή
+Καλή
+καταλαβαίνω Δεν
+Δεν
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] endswith [bar.b, true]
+----
+Monokel Das grüne
+Das grüne
+Punch-Out!! WITH LYRICS
+WITH LYRICS
+Risør
+sør
+Super Mario Bros. 3 WITH LYRICS
+WITH LYRICS
+boa tarde, Adeus
+adeus
+bom dia, Olá
+olá
+srauschenFrühling
+Frühling
+Καλή
+Καλή
+Χρονιά Καλή
+Καλή
+καταλαβαίνω Δεν
+Δεν
+
+statement ok
+DROP TABLE foo
+
+statement ok
+DROP TABLE bar
diff --git a/monetdb5/modules/atoms/Tests/startswith_join.test
b/monetdb5/modules/atoms/Tests/startswith_join.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/atoms/Tests/startswith_join.test
@@ -0,0 +1,99 @@
+statement ok
+CREATE TABLE foo(f string)
+
+statement ok
+CREATE TABLE bar(b string)
+
+-- TRIGGERS NESTED LOOP JOIN
+statement ok
+INSERT INTO foo VALUES
('LEFTJOHN'),('TRASH1'),('TRASH2'),(NULL),(NULL),('TRASH3'),('TRASH4'),('RIGHTJANE'),('rightrobert'),('uptim'),(NULL),('leftlex'),('LEFTJOE'),(NULL),('TRASH5'),('TRASH6'),('TRASH7'),('TRASH8'),('TRASH9'),('TRASH10')
+
+statement ok
+INSERT INTO bar VALUES ('left'),('right'),('up')
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] startswith [bar.b, false]
+----
+leftlex
+left
+rightrobert
+right
+uptim
+up
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] startswith [bar.b, true]
+----
+LEFTJOE
+left
+LEFTJOHN
+left
+RIGHTJANE
+right
+leftlex
+left
+rightrobert
+right
+uptim
+up
+
+statement ok
+TRUNCATE TABLE foo
+
+statement ok
+TRUNCATE TABLE bar
+
+-- TRIGGERS SORT BASED JOIN
+statement ok
+INSERT INTO foo VALUES ('Καλή'),('Frühlingsrauschen'),('Das grüne
Monokel'),('Καλή Χρονιά'),('Olá, bom dia'),('Risør'),('Wenn der Ölhahn
versiegt'),('Punch-Out!! WITH LYRICS'),('Super Mario Bros. 3 WITH
LYRICS'),('Δεν καταλαβαίνω'),('Adeus, boa tarde')
+
+statement ok
+INSERT INTO bar VALUES
('Δεν'),('Frühling'),(NULL),('Καλή'),('kαλή'),(NULL),('Olá'),('Das
grüne'),('Punch-Out!!'),('Adeus'),('früh')
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] startswith [bar.b]
+----
+Adeus, boa tarde
+Adeus
+Das grüne Monokel
+Das grüne
+Frühlingsrauschen
+Frühling
+Olá, bom dia
+Olá
+Punch-Out!! WITH LYRICS
+Punch-Out!!
+Δεν καταλαβαίνω
+Δεν
+Καλή
+Καλή
+Καλή Χρονιά
+Καλή
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] startswith [bar.b, true]
+----
+Adeus, boa tarde
+Adeus
+Das grüne Monokel
+Das grüne
+Frühlingsrauschen
+Frühling
+Frühlingsrauschen
+früh
+Olá, bom dia
+Olá
+Punch-Out!! WITH LYRICS
+Punch-Out!!
+Δεν καταλαβαίνω
+Δεν
+Καλή
+Καλή
+Καλή Χρονιά
+Καλή
+
+statement ok
+drop table foo
+
+statement ok
+drop table bar
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
