aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authoraneporada <aneporada@ydb.tech>2023-10-24 15:42:49 +0300
committeraneporada <aneporada@ydb.tech>2023-10-24 16:08:14 +0300
commit3106db4aaf3646abdd720fd74b2faf136b7e72e5 (patch)
tree584a5871993ffad3cb0f91d330cdf8d51ca489ec
parent56b44951ba7d9389c34c4076da85661ac9d2be8d (diff)
downloadydb-3106db4aaf3646abdd720fd74b2faf136b7e72e5.tar.gz
Add missing ORDER BY to obtain a stable test result
-rw-r--r--ydb/core/kqp/ut/scan/kqp_scan_ut.cpp8
1 files changed, 5 insertions, 3 deletions
diff --git a/ydb/core/kqp/ut/scan/kqp_scan_ut.cpp b/ydb/core/kqp/ut/scan/kqp_scan_ut.cpp
index 63ddaeb15b9..b03a784e7b4 100644
--- a/ydb/core/kqp/ut/scan/kqp_scan_ut.cpp
+++ b/ydb/core/kqp/ut/scan/kqp_scan_ut.cpp
@@ -1444,9 +1444,11 @@ Y_UNIT_TEST_SUITE(KqpScan) {
auto db = kikimr.GetTableClient();
auto it = db.StreamExecuteScanQuery(R"(
- (SELECT Key FROM `/Root/KeyValue` ORDER BY Key LIMIT 1)
- UNION ALL
- (SELECT Key FROM `/Root/EightShard` ORDER BY Key LIMIT 1);
+ SELECT Key FROM (
+ (SELECT Key FROM `/Root/KeyValue` ORDER BY Key LIMIT 1)
+ UNION ALL
+ (SELECT Key FROM `/Root/EightShard` ORDER BY Key LIMIT 1)
+ ) ORDER BY Key;
)").GetValueSync();
auto res = StreamResultToYson(it);
UNIT_ASSERT_C(it.IsSuccess(), it.GetIssues().ToString());