diff options
| author | Alexander Smirnov <alex@ydb.tech> | 2025-03-04 13:27:53 +0000 |
|---|---|---|
| committer | Alexander Smirnov <alex@ydb.tech> | 2025-03-04 13:27:53 +0000 |
| commit | ad0b83372abbcedc2887412cfdd967ea22b7148e (patch) | |
| tree | d24fee47ed2aef834af220ac137f5a0e26ed4678 /yt/yql/tests/sql/suites | |
| parent | 31ac77ec345d18126d79b7797bef365c9068d999 (diff) | |
| parent | 040bd4000eeec19eab31a023f72c3c06494ce92d (diff) | |
| download | ydb-ad0b83372abbcedc2887412cfdd967ea22b7148e.tar.gz | |
Merge pull request #15226 from ydb-platform/merge-libs-250302-1120
Diffstat (limited to 'yt/yql/tests/sql/suites')
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; |