summaryrefslogtreecommitdiffstats
path: root/systemtest/testcases_mandatory/test_select/test_rasql
diff options
context:
space:
mode:
Diffstat (limited to 'systemtest/testcases_mandatory/test_select/test_rasql')
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/array_constants.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_char.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_double.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_e.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_float.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_long.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_octet.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_short.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ulong.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ushort.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/basic_query_mechanism.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/binary_induction.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/binary_induction_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/cast.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/cast_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/comments_in_queries.rasql3
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_complex.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_struct.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_add.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_all.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_avg.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_count.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_max.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_min.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/condensers_some.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/extending_a_spatial_domain.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/from_clause.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_add.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_all.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_count.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_some.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_1c.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_x[0].rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induced_and_struct.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_+.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_-.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_abs.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_and.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arccos.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arcsin.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arctan.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_bit.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cos.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cosh.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_divide.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_egt.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_elt.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_exp.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_gt.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_is.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ln.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_log.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_lt.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_multiply.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ne.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_not.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_or.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_overlay.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sin.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sinh.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sqrt.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tan.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tanh.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_xor.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].lo.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/object_identifiers.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/oid.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/scaling_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/scaling_2.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/section.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/select_clause.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/shifting_a_spatial_domain.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].hi.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].lo.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_2.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk_1.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/trimming.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/unary_induction.rasql1
-rw-r--r--systemtest/testcases_mandatory/test_select/test_rasql/where_clause.rasql1
88 files changed, 90 insertions, 0 deletions
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/array_constants.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/array_constants.rasql
new file mode 100644
index 0000000..41df935
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/array_constants.rasql
@@ -0,0 +1 @@
+select < [-1:1,-2:2] 0, 1, 2, 3, 4; 1, 2, 3, 4, 5; 2, 3, 4, 5, 6 > from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_char.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_char.rasql
new file mode 100644
index 0000000..24610b2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_char.rasql
@@ -0,0 +1 @@
+select 24c from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_double.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_double.rasql
new file mode 100644
index 0000000..4f369c3
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_double.rasql
@@ -0,0 +1 @@
+select 24d from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_e.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_e.rasql
new file mode 100644
index 0000000..cd36a26
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_e.rasql
@@ -0,0 +1 @@
+select 4e-5D from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_float.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_float.rasql
new file mode 100644
index 0000000..2a58ac0
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_float.rasql
@@ -0,0 +1 @@
+select 24f from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_long.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_long.rasql
new file mode 100644
index 0000000..a2e15fe
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_long.rasql
@@ -0,0 +1 @@
+select 24l from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_octet.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_octet.rasql
new file mode 100644
index 0000000..d27954b
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_octet.rasql
@@ -0,0 +1 @@
+select 24o from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_short.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_short.rasql
new file mode 100644
index 0000000..af1807a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_short.rasql
@@ -0,0 +1 @@
+select 24s from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ulong.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ulong.rasql
new file mode 100644
index 0000000..44745ae
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ulong.rasql
@@ -0,0 +1 @@
+select 24ul from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ushort.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ushort.rasql
new file mode 100644
index 0000000..3a3ddf6
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/atomic_constants_ushort.rasql
@@ -0,0 +1 @@
+select 24us from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/basic_query_mechanism.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/basic_query_mechanism.rasql
new file mode 100644
index 0000000..09444df
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/basic_query_mechanism.rasql
@@ -0,0 +1 @@
+select test_grey[100:150,40:80] / 2 from test_grey where some_cells( test_grey[120:160, 55:75] > 250 ) \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction.rasql
new file mode 100644
index 0000000..44f9d87
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction.rasql
@@ -0,0 +1 @@
+select test_grey - test_grey2 from test_grey, test_grey2
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction_1.rasql
new file mode 100644
index 0000000..0528b7e
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/binary_induction_1.rasql
@@ -0,0 +1 @@
+select test_rgb2.1 - test_rgb2.2 from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/cast.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/cast.rasql
new file mode 100644
index 0000000..26591a2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/cast.rasql
@@ -0,0 +1 @@
+select (float) avg_cells( test_grey ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/cast_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/cast_1.rasql
new file mode 100644
index 0000000..d1195d9
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/cast_1.rasql
@@ -0,0 +1 @@
+select (long) test_rgb2 from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/comments_in_queries.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/comments_in_queries.rasql
new file mode 100644
index 0000000..9c6e152
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/comments_in_queries.rasql
@@ -0,0 +1,3 @@
+select test_grey -- this comment text is ignored by rasdaman
+from test_grey -- for comments spanning several lines,
+ -- every line needs a separate '--' starter \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_complex.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_complex.rasql
new file mode 100644
index 0000000..f172234
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_complex.rasql
@@ -0,0 +1 @@
+select complex( 0.35, 16.0 ) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_struct.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_struct.rasql
new file mode 100644
index 0000000..a22359e
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/composite_constants_struct.rasql
@@ -0,0 +1 @@
+select struct{ struct{ 1l, 2l, 3l }, true } from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_add.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_add.rasql
new file mode 100644
index 0000000..2479cdd
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_add.rasql
@@ -0,0 +1 @@
+select add_cells( test_grey ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_all.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_all.rasql
new file mode 100644
index 0000000..ffcd306
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_all.rasql
@@ -0,0 +1 @@
+select test_grey from test_grey where all_cells( test_grey > 20 ) \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_avg.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_avg.rasql
new file mode 100644
index 0000000..4a6d536
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_avg.rasql
@@ -0,0 +1 @@
+select avg_cells( test_grey ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_count.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_count.rasql
new file mode 100644
index 0000000..c27d9ce
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_count.rasql
@@ -0,0 +1 @@
+select count_cells( test_grey >-1) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_max.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_max.rasql
new file mode 100644
index 0000000..53062d3
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_max.rasql
@@ -0,0 +1 @@
+select max_cells( test_grey ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_min.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_min.rasql
new file mode 100644
index 0000000..189eda7
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_min.rasql
@@ -0,0 +1 @@
+select min_cells( test_grey ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/condensers_some.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_some.rasql
new file mode 100644
index 0000000..145b737
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/condensers_some.rasql
@@ -0,0 +1 @@
+select test_grey from test_grey where some_cells( test_grey[120:160, 55:75] > 250 ) \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/extending_a_spatial_domain.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/extending_a_spatial_domain.rasql
new file mode 100644
index 0000000..7232dee
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/extending_a_spatial_domain.rasql
@@ -0,0 +1 @@
+select extend( test_grey, [-1000:1000,-500:500] ) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/from_clause.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/from_clause.rasql
new file mode 100644
index 0000000..6a2b2c9
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/from_clause.rasql
@@ -0,0 +1 @@
+select a - b from test_grey as a, test_grey2 as b \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_add.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_add.rasql
new file mode 100644
index 0000000..a0a1c6b
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_add.rasql
@@ -0,0 +1 @@
+select condense + over x in sdom(a) using a[x] from test_grey as a \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_all.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_all.rasql
new file mode 100644
index 0000000..300cb33
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_all.rasql
@@ -0,0 +1 @@
+select condense and over x in sdom(a) using a[x] from test_grey as a \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_count.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_count.rasql
new file mode 100644
index 0000000..6084c52
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_count.rasql
@@ -0,0 +1 @@
+select condense + over x in sdom(a) where (bool)((bool)a[x]+1) using 1 from test_grey as a
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_some.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_some.rasql
new file mode 100644
index 0000000..0cbe5be
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_condenser_some.rasql
@@ -0,0 +1 @@
+select condense or over x in sdom(a) using a[x] from test_grey as a \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_1c.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_1c.rasql
new file mode 100644
index 0000000..b249bf4
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_1c.rasql
@@ -0,0 +1 @@
+select marray x in [ 1:100, -50:200 ] values 1c from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable.rasql
new file mode 100644
index 0000000..2de5ac2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable.rasql
@@ -0,0 +1 @@
+select marray x in [1:5], y in [1:10] values a[ x[0], y[0] ] from test_grey as a \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable_1.rasql
new file mode 100644
index 0000000..b293cb6
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_variable_1.rasql
@@ -0,0 +1 @@
+select marray xy in [1:5, 1:10] values a[ xy[0], xy[1] ] from test_grey as a \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_x[0].rasql b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_x[0].rasql
new file mode 100644
index 0000000..3fcfd0a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/general_array_constructor_x[0].rasql
@@ -0,0 +1 @@
+select marray x in [ 0:255, 0:511 ] values x[0] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induced_and_struct.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induced_and_struct.rasql
new file mode 100644
index 0000000..67d8273
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induced_and_struct.rasql
@@ -0,0 +1 @@
+select test_rgb + 5 from test_rgb \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_+.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_+.rasql
new file mode 100644
index 0000000..6da532e
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_+.rasql
@@ -0,0 +1 @@
+select test_grey + test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_-.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_-.rasql
new file mode 100644
index 0000000..8950f75
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_-.rasql
@@ -0,0 +1 @@
+select test_grey - test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_abs.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_abs.rasql
new file mode 100644
index 0000000..dd47296
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_abs.rasql
@@ -0,0 +1 @@
+select abs(test_grey) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_and.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_and.rasql
new file mode 100644
index 0000000..1b505e0
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_and.rasql
@@ -0,0 +1 @@
+select test_grey and test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arccos.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arccos.rasql
new file mode 100644
index 0000000..4351457
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arccos.rasql
@@ -0,0 +1 @@
+select arccos(0.5) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arcsin.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arcsin.rasql
new file mode 100644
index 0000000..b83af87
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arcsin.rasql
@@ -0,0 +1 @@
+select arcsin(0.5) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arctan.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arctan.rasql
new file mode 100644
index 0000000..fb985b2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_arctan.rasql
@@ -0,0 +1 @@
+select arctan(1) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_bit.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_bit.rasql
new file mode 100644
index 0000000..51033cb
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_bit.rasql
@@ -0,0 +1 @@
+select bit(test_grey,1) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cos.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cos.rasql
new file mode 100644
index 0000000..3b254a0
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cos.rasql
@@ -0,0 +1 @@
+select cos(60) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cosh.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cosh.rasql
new file mode 100644
index 0000000..4c541a4
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_cosh.rasql
@@ -0,0 +1 @@
+select cosh(0) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_divide.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_divide.rasql
new file mode 100644
index 0000000..27cdc30
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_divide.rasql
@@ -0,0 +1 @@
+select test_grey / test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_egt.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_egt.rasql
new file mode 100644
index 0000000..c4c1501
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_egt.rasql
@@ -0,0 +1 @@
+select test_grey >= test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_elt.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_elt.rasql
new file mode 100644
index 0000000..83c819e
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_elt.rasql
@@ -0,0 +1 @@
+select test_grey <= test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_exp.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_exp.rasql
new file mode 100644
index 0000000..fc7c5d2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_exp.rasql
@@ -0,0 +1 @@
+select exp(0) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_gt.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_gt.rasql
new file mode 100644
index 0000000..c8486b9
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_gt.rasql
@@ -0,0 +1 @@
+select test_grey > test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_is.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_is.rasql
new file mode 100644
index 0000000..46b058a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_is.rasql
@@ -0,0 +1 @@
+select test_grey is test_grey2 from test_grey, test_grey2
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ln.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ln.rasql
new file mode 100644
index 0000000..67fa973
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ln.rasql
@@ -0,0 +1 @@
+select ln(1) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_log.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_log.rasql
new file mode 100644
index 0000000..97d4bde
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_log.rasql
@@ -0,0 +1 @@
+select log(1) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_lt.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_lt.rasql
new file mode 100644
index 0000000..d0a14b1
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_lt.rasql
@@ -0,0 +1 @@
+select test_grey < test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_multiply.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_multiply.rasql
new file mode 100644
index 0000000..7e6c433
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_multiply.rasql
@@ -0,0 +1 @@
+select test_grey * test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ne.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ne.rasql
new file mode 100644
index 0000000..b0cb667
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_ne.rasql
@@ -0,0 +1 @@
+select test_grey != test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_not.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_not.rasql
new file mode 100644
index 0000000..00f7e5c
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_not.rasql
@@ -0,0 +1 @@
+select not(test_grey) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_or.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_or.rasql
new file mode 100644
index 0000000..7a49ae2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_or.rasql
@@ -0,0 +1 @@
+select test_grey or test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_overlay.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_overlay.rasql
new file mode 100644
index 0000000..22ebd69
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_overlay.rasql
@@ -0,0 +1 @@
+select test_grey overlay test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sin.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sin.rasql
new file mode 100644
index 0000000..2ed9725
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sin.rasql
@@ -0,0 +1 @@
+select sin(test_grey) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sinh.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sinh.rasql
new file mode 100644
index 0000000..665859a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sinh.rasql
@@ -0,0 +1 @@
+select sinh(0) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sqrt.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sqrt.rasql
new file mode 100644
index 0000000..7aa527d
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_sqrt.rasql
@@ -0,0 +1 @@
+select sqrt(test_grey) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tan.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tan.rasql
new file mode 100644
index 0000000..9f7c9fe
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tan.rasql
@@ -0,0 +1 @@
+select tan(0) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tanh.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tanh.rasql
new file mode 100644
index 0000000..a3a6c30
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_tanh.rasql
@@ -0,0 +1 @@
+select tanh(0) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_xor.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_xor.rasql
new file mode 100644
index 0000000..3467311
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/induction_all_operations_xor.rasql
@@ -0,0 +1 @@
+select test_grey xor test_grey2 from test_grey, test_grey2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals.rasql
new file mode 100644
index 0000000..dfe7286
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals.rasql
@@ -0,0 +1 @@
+select [ -17 : 245, 42 : 227 ] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].lo.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].lo.rasql
new file mode 100644
index 0000000..1672101
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].lo.rasql
@@ -0,0 +1 @@
+select [ -17 : 245, 42 : 227 ][ 1 ].lo from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].rasql b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].rasql
new file mode 100644
index 0000000..950d152
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/multidimensional_intervals_[1].rasql
@@ -0,0 +1 @@
+select [ -17 : 245, 42 : 227 ][ 1 ] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/object_identifiers.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/object_identifiers.rasql
new file mode 100644
index 0000000..6320759
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/object_identifiers.rasql
@@ -0,0 +1 @@
+select test_grey from test_grey where oid( test_grey ) > 10 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/oid.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/oid.rasql
new file mode 100644
index 0000000..9a57416
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/oid.rasql
@@ -0,0 +1 @@
+select oid(test_grey)/oid(test_grey) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/scaling_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/scaling_1.rasql
new file mode 100644
index 0000000..eba50a4
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/scaling_1.rasql
@@ -0,0 +1 @@
+select scale( test_grey, [ 4, 3 ] ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/scaling_2.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/scaling_2.rasql
new file mode 100644
index 0000000..d1a8539
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/scaling_2.rasql
@@ -0,0 +1 @@
+select scale( test_grey, 0.5 ) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/section.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/section.rasql
new file mode 100644
index 0000000..3905de9
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/section.rasql
@@ -0,0 +1 @@
+select test_grey[ 100, 150 ] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/select_clause.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/select_clause.rasql
new file mode 100644
index 0000000..809b715
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/select_clause.rasql
@@ -0,0 +1 @@
+select test_grey/2 from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/shifting_a_spatial_domain.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/shifting_a_spatial_domain.rasql
new file mode 100644
index 0000000..915660b
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/shifting_a_spatial_domain.rasql
@@ -0,0 +1 @@
+select shift( test_grey[ 0:10, 0:20 ], [ 3, 4 ] ) from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain.rasql
new file mode 100644
index 0000000..390cf35
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain.rasql
@@ -0,0 +1 @@
+select sdom(test_grey) from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].hi.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].hi.rasql
new file mode 100644
index 0000000..570afac
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].hi.rasql
@@ -0,0 +1 @@
+select sdom(test_grey)[0].hi from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].lo.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].lo.rasql
new file mode 100644
index 0000000..b66a4dc
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].lo.rasql
@@ -0,0 +1 @@
+select sdom(test_grey)[0].lo from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].rasql b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].rasql
new file mode 100644
index 0000000..f331e6a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/spatial_domain_[0].rasql
@@ -0,0 +1 @@
+select sdom(test_grey)[0] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection.rasql
new file mode 100644
index 0000000..c088501
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection.rasql
@@ -0,0 +1 @@
+select test_rgb2.2 from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_1.rasql
new file mode 100644
index 0000000..e15991a
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_1.rasql
@@ -0,0 +1 @@
+select test_rgb2.1 from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_2.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_2.rasql
new file mode 100644
index 0000000..942ddc2
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/struct_component_selection_2.rasql
@@ -0,0 +1 @@
+select test_rgb2 / 2c from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk.rasql
new file mode 100644
index 0000000..6de80e4
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk.rasql
@@ -0,0 +1 @@
+select test_grey[ 50:*, *:200 ] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk_1.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk_1.rasql
new file mode 100644
index 0000000..014e7fe
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/the_array_bound_asterisk_1.rasql
@@ -0,0 +1 @@
+select test_grey[ *:*, 10:150 ] from test_grey
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/trimming.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/trimming.rasql
new file mode 100644
index 0000000..87e4edc
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/trimming.rasql
@@ -0,0 +1 @@
+select test_grey[ 120:160, 55:75 ] from test_grey \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/unary_induction.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/unary_induction.rasql
new file mode 100644
index 0000000..d3903d5
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/unary_induction.rasql
@@ -0,0 +1 @@
+select test_rgb2.1 * 2c from test_rgb2 \ No newline at end of file
diff --git a/systemtest/testcases_mandatory/test_select/test_rasql/where_clause.rasql b/systemtest/testcases_mandatory/test_select/test_rasql/where_clause.rasql
new file mode 100644
index 0000000..5372b50
--- /dev/null
+++ b/systemtest/testcases_mandatory/test_select/test_rasql/where_clause.rasql
@@ -0,0 +1 @@
+select test_grey - test_grey2 from test_grey, test_grey2 where some_cells( test_grey - test_grey2 > 50 )