Changeset: 4373cdb78131 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4373cdb78131
Removed Files:
monetdb5/modules/atoms/Tests/ends_with_join.test
monetdb5/modules/atoms/Tests/starts_with_join.test
Branch: sw_ew_c_sorting
Log Message:
delete old files
diffs (210 lines):
diff --git a/monetdb5/modules/atoms/Tests/ends_with_join.test
b/monetdb5/modules/atoms/Tests/ends_with_join.test
deleted file mode 100644
--- a/monetdb5/modules/atoms/Tests/ends_with_join.test
+++ /dev/null
@@ -1,101 +0,0 @@
-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/starts_with_join.test
b/monetdb5/modules/atoms/Tests/starts_with_join.test
deleted file mode 100644
--- a/monetdb5/modules/atoms/Tests/starts_with_join.test
+++ /dev/null
@@ -1,99 +0,0 @@
-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
