Add interpreter tests

38 files changed, 74 insertions, 0 deletions

diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.in
new file mode 100644
index 0000000..4c01bba
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.in
@@ -0,0 +1 @@
+SELECT 2 + 2 AS two_plus_two
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.out
new file mode 100644
index 0000000..b834f59
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/1.out
@@ -0,0 +1,3 @@
+/uw: two_plus_two: 4
+/pjwstk: two_plus_two: 4
+/: two_plus_two: 4
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.in
new file mode 100644
index 0000000..eb1b0da
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.in
@@ -0,0 +1 @@
+SELECT min(name) AS min_name, to_string(first(1, name)) AS max_name ORDER BY name DESC
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.out
new file mode 100644
index 0000000..56c050c
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/10.out
@@ -0,0 +1,6 @@
+/uw: min_name: khaki13
+/uw: max_name: [violet07]
+/pjwstk: min_name: whatever01
+/pjwstk: max_name: [whatever02]
+/: min_name: pjwstk
+/: max_name: [uw]
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.in
new file mode 100644
index 0000000..3081ead
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.in
@@ -0,0 +1 @@
+SELECT epoch() AS epoch, land(timestamp > epoch()) AS afterY2K
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.out
new file mode 100644
index 0000000..72ac484
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/11.out
@@ -0,0 +1,6 @@
+/uw: epoch: 2000/01/01 00:00:00.000
+/uw: afterY2K: true
+/pjwstk: epoch: 2000/01/01 00:00:00.000
+/pjwstk: afterY2K: true
+/: epoch: 2000/01/01 00:00:00.000
+/: afterY2K: true
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.in
new file mode 100644
index 0000000..5340bed
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.in
@@ -0,0 +1 @@
+SELECT min(timestamp) + (max(timestamp) - epoch()) / 2 AS t2
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.out
new file mode 100644
index 0000000..f662146
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/12.out
@@ -0,0 +1,3 @@
+/uw: t2: 2019/04/16 05:31:30.000
+/pjwstk: t2: 2019/04/16 08:48:30.000
+/: t2: 2019/04/16 07:12:19.684
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.in
new file mode 100644
index 0000000..af367ff
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.in
@@ -0,0 +1 @@
+SELECT lor(unfold(some_names) + "xx" REGEXP "([a-z]*)atkax([a-z]*)") AS beatka
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.out
new file mode 100644
index 0000000..cc70937
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/13.out
@@ -0,0 +1 @@
+/uw: beatka: true
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.in
new file mode 100644
index 0000000..4a662ba
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.in
@@ -0,0 +1 @@
+SELECT (SELECT avg(cpu_usage) WHERE false) AS smth
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.out
new file mode 100644
index 0000000..1f9a626
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/14.out
@@ -0,0 +1,2 @@
+/uw: smth: NULL
+/pjwstk: smth: NULL
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.in
new file mode 100644
index 0000000..35e3b89
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.in
@@ -0,0 +1 @@
+SELECT avg(cpu_usage) AS cpu_usage WHERE (SELECT sum(cardinality)) > (SELECT to_integer((1 + 2 + 3 + 4) / 5))
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.out
new file mode 100644
index 0000000..4d9c0d7
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/15.out
@@ -0,0 +1,3 @@
+/uw: cpu_usage: 0.5
+/pjwstk: cpu_usage: NULL
+/: cpu_usage: NULL
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.in
new file mode 100644
index 0000000..0657efc
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.in
@@ -0,0 +1 @@
+SELECT ceil(to_double(min(num_cores)) / 1.41) AS sth
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.out
new file mode 100644
index 0000000..2e77b3d
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/16.out
@@ -0,0 +1,2 @@
+/uw: sth: 3.0
+/pjwstk: sth: 5.0
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.in
new file mode 100644
index 0000000..8eb556d
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.in
@@ -0,0 +1 @@
+SELECT floor(5.0 / 1.9) AS fl
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.out
new file mode 100644
index 0000000..062a8cc
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/17.out
@@ -0,0 +1,3 @@
+/uw: fl: 2.0
+/pjwstk: fl: 2.0
+/: fl: 2.0
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.in
new file mode 100644
index 0000000..6c9859a
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.in
@@ -0,0 +1 @@
+SELECT to_time("2013/07/05 12:54:32.098") + to_duration(6811) AS tim
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.out
new file mode 100644
index 0000000..db9ade3
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/18.out
@@ -0,0 +1,3 @@
+/uw: tim: 2013/07/05 12:54:38.909
+/pjwstk: tim: 2013/07/05 12:54:38.909
+/: tim: 2013/07/05 12:54:38.909
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.in
new file mode 100644
index 0000000..6ab2d74
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.in
@@ -0,0 +1 @@
+SELECT avg(cpu_usage * to_double(num_cores)) AS cpu_load, sum(num_cores) AS num_cores
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.out
new file mode 100644
index 0000000..4ff843d
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/19.out
@@ -0,0 +1,4 @@
+/uw: cpu_load: 2.7
+/uw: num_cores: 6
+/pjwstk: cpu_load: 2.95
+/pjwstk: num_cores: 20
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.in
new file mode 100644
index 0000000..d707ae3
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.in
@@ -0,0 +1 @@
+SELECT to_integer((to_double(3) - 5.6) / 11.0 + to_double(47 * (31 - 15))) AS math WHERE true
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.out
new file mode 100644
index 0000000..8e12aa1
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/2.out
@@ -0,0 +1,3 @@
+/uw: math: 751
+/pjwstk: math: 751
+/: math: 751
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.in
new file mode 100644
index 0000000..25203ce
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.in
@@ -0,0 +1 @@
+SELECT count(members) AS members_count
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.out
new file mode 100644
index 0000000..66d6424
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/3.out
@@ -0,0 +1,2 @@
+/uw: members_count: 3
+/pjwstk: members_count: 2
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.in
new file mode 100644
index 0000000..4a8347f
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.in
@@ -0,0 +1 @@
+SELECT first(99, name) AS new_contacts ORDER BY cpu_usage DESC NULLS LAST, num_cores ASC NULLS FIRST
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.out
new file mode 100644
index 0000000..b8e0300
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/4.out
@@ -0,0 +1,3 @@
+/uw: new_contacts: [khaki13, violet07, khaki31]
+/pjwstk: new_contacts: [whatever01, whatever02]
+/: new_contacts: [uw, pjwstk]
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.in
new file mode 100644
index 0000000..168bc5e
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.in
@@ -0,0 +1 @@
+SELECT count(num_cores - size(some_names)) AS sth
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.out
new file mode 100644
index 0000000..4145a74
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/5.out
@@ -0,0 +1 @@
+/uw: sth: 2
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.in
new file mode 100644
index 0000000..67dd68f
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.in
@@ -0,0 +1 @@
+SELECT min(sum(distinct(2 * level)) + 38 * size(contacts)) AS sth WHERE num_cores < 8
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.out
new file mode 100644
index 0000000..419e97d
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/6.out
@@ -0,0 +1,3 @@
+/uw: sth: 80
+/pjwstk: sth: 80
+/: sth: NULL
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.in
new file mode 100644
index 0000000..a338281
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.in
@@ -0,0 +1 @@
+SELECT first(1, name) + last(1,name) AS concat_name WHERE num_cores >= (SELECT min(num_cores) ORDER BY timestamp) ORDER BY creation ASC NULLS LAST
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.out
new file mode 100644
index 0000000..8da8318
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/7.out
@@ -0,0 +1,2 @@
+/uw: concat_name: [violet07, khaki31]
+/pjwstk: concat_name: [whatever01, whatever02]
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.in
new file mode 100644
index 0000000..d484389
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.in
@@ -0,0 +1 @@
+SELECT sum(cardinality) AS cardinality
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.out
new file mode 100644
index 0000000..fb762ad
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/8.out
@@ -0,0 +1,3 @@
+/uw: cardinality: 3
+/pjwstk: cardinality: 2
+/: cardinality: 5
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.in b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.in
new file mode 100644
index 0000000..7b87d6e
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.in
@@ -0,0 +1 @@
+SELECT land(cpu_usage < 0.5) AS cpu_ok
diff --git a/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.out b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.out
new file mode 100644
index 0000000..81a4ad9
--- /dev/null
+++ b/src/test/resources/pl/edu/mimuw/cloudatlas/interpreter/9.out
@@ -0,0 +1,2 @@
+/uw: cpu_ok: false
+/pjwstk: cpu_ok: true