Changeset: c15a38715345 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/c15a38715345
Added Files:
monetdb5/modules/mal/Tests/ng_c.test
monetdb5/modules/mal/Tests/ng_ew.test
monetdb5/modules/mal/Tests/ng_sw.test
Modified Files:
monetdb5/modules/mal/Tests/All
Branch: strimps_v3
Log Message:
Initial testing of ngrams sw, ew and c
diffs (truncated from 683 to 300 lines):
diff --git a/monetdb5/modules/mal/Tests/All b/monetdb5/modules/mal/Tests/All
--- a/monetdb5/modules/mal/Tests/All
+++ b/monetdb5/modules/mal/Tests/All
@@ -50,3 +50,7 @@ orderidx00
orderidx01
orderidx02
orderidx04
+
+ng_sw
+ng_ew
+ng_c
diff --git a/monetdb5/modules/mal/Tests/ng_c.test
b/monetdb5/modules/mal/Tests/ng_c.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/mal/Tests/ng_c.test
@@ -0,0 +1,109 @@
+query I nosort
+select c(NULL, '')
+----
+NULL
+
+query I nosort
+select c('', NULL)
+----
+NULL
+
+query I nosort
+select c('', '')
+----
+1
+
+query I nosort
+select c('johndoe', '')
+----
+1
+
+query I nosort
+select c('', 'johndoe')
+----
+0
+
+query I nosort
+select c('johndoe', 'john')
+----
+1
+
+query I nosort
+SELECT c('one two three', 'three')
+----
+1
+
+query I nosort
+SELECT c('one two three', 'THREE')
+----
+0
+
+query I nosort
+SELECT c('Müller Thomas', 'müller')
+----
+0
+
+query I nosort
+SELECT c('müller Thomas', 'müller')
+----
+1
+
+statement ok
+CREATE TABLE foo(f string)
+
+statement ok
+CREATE TABLE bar(b string)
+
+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] c [bar.b]
+----
+leftlex
+left
+rightrobert
+right
+uptim
+up
+
+statement ok
+TRUNCATE TABLE foo
+
+statement ok
+TRUNCATE TABLE bar
+
+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] c [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!!
+Δεν καταλαβαίνω
+Δεν
+Καλή
+Καλή
+Καλή Χρονιά
+Καλή
+
+statement ok
+DROP TABLE foo
+
+statement ok
+DROP TABLE bar
diff --git a/monetdb5/modules/mal/Tests/ng_ew.test
b/monetdb5/modules/mal/Tests/ng_ew.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/mal/Tests/ng_ew.test
@@ -0,0 +1,125 @@
+query I nosort
+SELECT e(NULL, '')
+----
+NULL
+
+query I nosort
+SELECT e('', NULL)
+----
+NULL
+
+query I nosort
+SELECT e('', '')
+----
+1
+
+query I nosort
+SELECT e('johndoe', '')
+----
+1
+
+query I nosort
+SELECT e('', 'johndoe')
+----
+0
+
+query I nosort
+SELECT e('johndoe', 'doe')
+----
+1
+
+query I nosort
+SELECT e('one two three', 'three')
+----
+1
+
+query I nosort
+SELECT e('Thomas Müller', 'müller')
+----
+0
+
+# Ⱥ and ⱥ are not the same length in UTF-8 encoding
+query I nosort
+SELECT e('XXXȺ', 'ⱥ')
+----
+0
+
+query I nosort
+SELECT e('xxxⱥ', 'Ⱥ')
+----
+0
+
+query I nosort
+SELECT e('XXXⱥ', 'ⱥ')
+----
+1
+
+statement ok
+CREATE TABLE foo(f string)
+
+statement ok
+CREATE TABLE bar(b string)
+
+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] e [bar.b, false]
+----
+lexleft
+left
+robertright
+right
+timup
+up
+
+query TT rowsort
+SELECT * FROM foo,bar WHERE [foo.f] e [bar.b, true]
+----
+lexleft
+left
+robertright
+right
+timup
+up
+
+statement ok
+TRUNCATE TABLE foo
+
+statement ok
+TRUNCATE TABLE bar
+
+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] e [bar.b]
+----
+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
+Καλή
+Καλή
+Χρονιά Καλή
+Καλή
+καταλαβαίνω Δεν
+Δεν
+
+statement ok
+DROP TABLE foo
+
+statement ok
+DROP TABLE bar
diff --git a/monetdb5/modules/mal/Tests/ng_sw.test
b/monetdb5/modules/mal/Tests/ng_sw.test
new file mode 100644
--- /dev/null
+++ b/monetdb5/modules/mal/Tests/ng_sw.test
@@ -0,0 +1,423 @@
+query I nosort
+SELECT s(NULL, '')
+----
+NULL
+
+query I nosort
+SELECT s('', NULL)
+----
+NULL
+
+query I nosort
+SELECT s('', '')
+----
+1
+
+query I nosort
+SELECT s('johndoe', '')
+----
+1
+
+query I nosort
+SELECT s('', 'johndoe')
+----
+0
+
+query I nosort
+SELECT s('johndoe', 'john')
+----
+1
+
+query I nosort
+SELECT s('one two three', 'three')
+----
+0
+
+query I nosort
+SELECT s('Müller Thomas', 'Müller')
+----
+1
+
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
