YQL-19206 Move contrib/ydb/library/yql/tests/sql/suites -> yql/essentials/tests/sql/suites

commit_hash:d0ef1f92b09c94db7c2408f946d2a4c62b603f00

1 files changed, 18 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/blocks/decimal_multiplicative_ops.sql b/yql/essentials/tests/sql/suites/blocks/decimal_multiplicative_ops.sql
new file mode 100644
index 0000000000..4d3166b6a5
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/blocks/decimal_multiplicative_ops.sql
@@ -0,0 +1,18 @@
+USE plato;
+
+SELECT
+    cs_ext_list_price,  cs_ext_tax,
+    cs_ext_list_price * cs_ext_tax, cs_ext_list_price * Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) * cs_ext_tax,
+                                    cs_ext_list_price * decimal("13.37", 7, 2), decimal("42.0", 7, 2) * cs_ext_tax,
+
+    cs_ext_list_price / cs_ext_tax, cs_ext_list_price / Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) / cs_ext_tax,
+                                    cs_ext_list_price / decimal("13.37", 7, 2), decimal("42.0", 7, 2) / cs_ext_tax,
+    
+    cs_ext_list_price % cs_ext_tax, cs_ext_list_price % Just(decimal("13.37", 7, 2)), Just(decimal("42.0", 7, 2)) % cs_ext_tax,
+                                    cs_ext_list_price % decimal("13.37", 7, 2), decimal("42.0", 7, 2) % cs_ext_tax,
+
+    cs_ext_list_price * Just(13), cs_ext_list_price * 13,
+    cs_ext_list_price / Just(13), cs_ext_list_price / 13,
+    cs_ext_list_price % Just(13), cs_ext_list_price % 13,
+FROM Input;
+