diff options
| author | Alexander Smirnov <alex@ydb.tech> | 2025-03-02 11:21:41 +0000 |
|---|---|---|
| committer | Alexander Smirnov <alex@ydb.tech> | 2025-03-02 11:21:41 +0000 |
| commit | 8322fb9ff849dc37fa752d5aba04ef9e7ba2a7c9 (patch) | |
| tree | 0d722004f839a80a1c4a02aa4dd2704daae5adec /yt/yql/tests | |
| parent | 22b98a26c01070ae980dc5477323d8d4152aabbc (diff) | |
| parent | 6678165e016ba474f1b8dd6d49af92b0d46350b9 (diff) | |
| download | ydb-8322fb9ff849dc37fa752d5aba04ef9e7ba2a7c9.tar.gz | |
Merge branch 'rightlib' into merge-libs-250302-1120
Diffstat (limited to 'yt/yql/tests')
4 files changed, 69 insertions, 0 deletions
diff --git a/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt b/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt new file mode 100644 index 0000000000..93fc12aa26 --- /dev/null +++ b/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt @@ -0,0 +1,3 @@ +{"_yql_column_0"="\xE0\xCC\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFE";"key2"=3;"key1"=3;}; +{"_yql_column_0"="\xE0\xCD\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFE";"key2"=2;"key1"=2;}; +{"_yql_column_0"="\xE0\xCE\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFE";"key2"=1;"key1"=1;}; diff --git a/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt.attr b/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt.attr new file mode 100644 index 0000000000..21b8210d8e --- /dev/null +++ b/yt/yql/tests/sql/suites/order_by/input_sorted_desc.txt.attr @@ -0,0 +1,61 @@ +{ + "_yql_row_spec" = { + "Constraints" = { + "Sorted" = [ + [ + [ + "key1"; + ]; + %false; + ]; + [ + [ + "key2"; + ]; + %true; + ]; + ]; + }; + "SortDirections" = [ + 0; + 1; + ]; + "SortMembers" = [ + "key1"; + "key2"; + ]; + "SortedBy" = [ + "_yql_column_0"; + "key2"; + ]; + "SortedByTypes" = [ + [ + "DataType"; + "String"; + ]; + [ + "DataType"; + "Int32"; + ]; + ]; + "Type" = [ + "StructType"; + [ + [ + "key1"; + [ + "DataType"; + "Int32"; + ]; + ]; + [ + "key2"; + [ + "DataType"; + "Int32"; + ]; + ]; + ]; + ]; + }; +} diff --git a/yt/yql/tests/sql/suites/order_by/yql-19598.cfg b/yt/yql/tests/sql/suites/order_by/yql-19598.cfg new file mode 100644 index 0000000000..b7ad0584fe --- /dev/null +++ b/yt/yql/tests/sql/suites/order_by/yql-19598.cfg @@ -0,0 +1 @@ +in Input input_sorted_desc.txt diff --git a/yt/yql/tests/sql/suites/order_by/yql-19598.sql b/yt/yql/tests/sql/suites/order_by/yql-19598.sql new file mode 100644 index 0000000000..cab0eded47 --- /dev/null +++ b/yt/yql/tests/sql/suites/order_by/yql-19598.sql @@ -0,0 +1,4 @@ +/* postgres can not */ +USE plato; + +SELECT * FROM Input WHERE key2 = 2 ASSUME ORDER BY key2; |