diff options
| author | Andrey Neporada <aneporada@ydb.tech> | 2024-10-17 10:57:22 +0300 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2024-10-17 10:57:22 +0300 |
| commit | 91a3c8781d8d607508ffc737ac2eae309829ebfa (patch) | |
| tree | 6ab793b7cc4728c40c8eab4b5ba536fc8b7a3aad | |
| parent | a68afa8387bb1606f2888a3e7e9ab26f88f59020 (diff) | |
| download | ydb-91a3c8781d8d607508ffc737ac2eae309829ebfa.tar.gz | |
Stabilize table order in test (#10539)
4 files changed, 39 insertions, 4 deletions
diff --git a/ydb/library/yql/tests/sql/suites/join/do_not_suppres_equijoin_input_sorts.cfg b/ydb/library/yql/tests/sql/suites/join/do_not_suppres_equijoin_input_sorts.cfg index 7b177bff27..89a1fdcc94 100644 --- a/ydb/library/yql/tests/sql/suites/join/do_not_suppres_equijoin_input_sorts.cfg +++ b/ydb/library/yql/tests/sql/suites/join/do_not_suppres_equijoin_input_sorts.cfg @@ -1,3 +1,3 @@ in Input1 sorted_by_kv1_opt.txt -in Input2 sorted_by_kv1.txt +in Input2 sorted_by_kv1_1.txt providers yt diff --git a/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt b/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt new file mode 100644 index 0000000000..7d1d077ae0 --- /dev/null +++ b/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt @@ -0,0 +1,10 @@ +{"k1"="aaa";"v1"="v11";"u1"="u11"}; +{"k1"="bbb";"v1"="v12";"u1"="u12"}; +{"k1"="ccc";"v1"="v13";"u1"="u13"}; +{"k1"="ddd";"v1"="v14";"u1"="u14"}; +{"k1"="eee";"v1"="v15";"u1"="u15"}; +{"k1"="fff";"v1"="v16";"u1"="u16"}; +{"k1"="ggg";"v1"="v17";"u1"="u17"}; +{"k1"="hhh";"v1"="v18";"u1"="u18"}; +{"k1"="iii";"v1"="v19";"u1"="u19"}; +{"k1"="jjj";"v1"="v20";"u1"="u20"}; diff --git a/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt.attr b/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt.attr new file mode 100644 index 0000000000..4185224ec0 --- /dev/null +++ b/ydb/library/yql/tests/sql/suites/join/sorted_by_kv1_1.txt.attr @@ -0,0 +1,25 @@ +{ + "schema" = < + "strict" = %true; + "unique_keys" = %false + > + [ + { + "name" = "k1"; + "required" = %true; + "sort_order" = "ascending"; + "type" = "string" + }; + { + "name" = "v1"; + "required" = %true; + "sort_order" = "ascending"; + "type" = "string" + }; + { + "name" = "u1"; + "required" = %true; + "type" = "string" + } + ]; +} diff --git a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json index 943e2a3074..7cd88850c2 100644 --- a/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json +++ b/ydb/library/yql/tests/sql/yt_native_file/part14/canondata/result.json @@ -1756,9 +1756,9 @@ ], "test.test[join-do_not_suppres_equijoin_input_sorts--Debug]": [ { - "checksum": "39a7da36195278939749cfd0c802df2d", - "size": 4192, - "uri": "https://{canondata_backend}/212715/554ca8a35165199bfbc0a64aabd14c9754eff60c/resource.tar.gz#test.test_join-do_not_suppres_equijoin_input_sorts--Debug_/opt.yql" + "checksum": "705cc48e359738da82085e2ce49d6eb2", + "size": 4213, + "uri": "https://{canondata_backend}/1880306/fc65cec48f2afac2a67325b7ac55e41ecfa39dc8/resource.tar.gz#test.test_join-do_not_suppres_equijoin_input_sorts--Debug_/opt.yql" } ], "test.test[join-do_not_suppres_equijoin_input_sorts--Plan]": [ |