diff options
author | aozeritsky <[email protected]> | 2023-10-04 14:11:27 +0300 |
---|---|---|
committer | aozeritsky <[email protected]> | 2023-10-04 15:06:22 +0300 |
commit | 4ec4afb5d8ecbe817c5329f578618f5eadd489db (patch) | |
tree | 87c96c8426a04000adbc10fdb24a7ab354475c6c | |
parent | 60173424b8ab0a53c93491cd103a06dd5b415f60 (diff) |
Improve tests (don't canonize costs)
-rw-r--r-- | ydb/library/yql/sql/pg/optimizer_ut.cpp | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/ydb/library/yql/sql/pg/optimizer_ut.cpp b/ydb/library/yql/sql/pg/optimizer_ut.cpp index 5fecfcd8d89..3b77bd00b92 100644 --- a/ydb/library/yql/sql/pg/optimizer_ut.cpp +++ b/ydb/library/yql/sql/pg/optimizer_ut.cpp @@ -31,11 +31,9 @@ Y_UNIT_TEST(PgJoinSearch2Rels) { auto optimizer = std::unique_ptr<IOptimizer>(MakePgOptimizer(input, log)); auto res = optimizer->JoinSearch(); - auto resStr = res.ToString(); + auto resStr = res.ToString(false); Cerr << resStr; - TString expected = R"__(Rows: 500000000.00 -TotalCost: 10000001260000260.00 -{ + TString expected = R"__({ Inner Join Loop Strategy Rels: [1,2] @@ -51,6 +49,8 @@ TotalCost: 10000001260000260.00 } )__"; UNIT_ASSERT_STRINGS_EQUAL(expected, resStr); + UNIT_ASSERT(res.TotalCost > 0); + UNIT_ASSERT(res.Rows > 0); } Y_UNIT_TEST(PgJoinSearch2RelsLeft) { @@ -77,11 +77,9 @@ Y_UNIT_TEST(PgJoinSearch2RelsLeft) { auto optimizer = std::unique_ptr<IOptimizer>(MakePgOptimizer(input, log)); auto res = optimizer->JoinSearch(); - auto resStr = res.ToString(); + auto resStr = res.ToString(false); Cerr << resStr; - TString expected = R"__(Rows: 500000000.00 -TotalCost: 1650702509.00 -{ + TString expected = R"__({ Left Join Loop Strategy Rels: [1,2] @@ -97,6 +95,8 @@ TotalCost: 1650702509.00 } )__"; UNIT_ASSERT_STRINGS_EQUAL(expected, resStr); + UNIT_ASSERT(res.TotalCost > 0); + UNIT_ASSERT(res.Rows > 0); } Y_UNIT_TEST(PgJoinSearch2RelsRight) { @@ -123,11 +123,9 @@ Y_UNIT_TEST(PgJoinSearch2RelsRight) { auto optimizer = std::unique_ptr<IOptimizer>(MakePgOptimizer(input, log)); auto res = optimizer->JoinSearch(); - auto resStr = res.ToString(); + auto resStr = res.ToString(false); Cerr << resStr; - TString expected = R"__(Rows: 500000000.00 -TotalCost: 1260000259.00 -{ + TString expected = R"__({ Left Join Loop Strategy Rels: [1,2] @@ -143,6 +141,8 @@ TotalCost: 1260000259.00 } )__"; UNIT_ASSERT_STRINGS_EQUAL(expected, resStr); + UNIT_ASSERT(res.TotalCost > 0); + UNIT_ASSERT(res.Rows > 0); } Y_UNIT_TEST(PgJoinSearch3Rels) { @@ -161,11 +161,9 @@ Y_UNIT_TEST(PgJoinSearch3Rels) { auto optimizer = std::unique_ptr<IOptimizer>(MakePgOptimizer(input, log)); auto res = optimizer->JoinSearch(); - auto resStr = res.ToString(); + auto resStr = res.ToString(false); Cerr << resStr; - TString expected = R"__(Rows: 25000000000.00 -TotalCost: 25100000272571156.00 -{ + TString expected = R"__({ Inner Join Hash Strategy Rels: [1,2,3] @@ -191,6 +189,8 @@ TotalCost: 25100000272571156.00 } )__"; UNIT_ASSERT_STRINGS_EQUAL(expected, resStr); + UNIT_ASSERT(res.TotalCost > 0); + UNIT_ASSERT(res.Rows > 0); } } // Y_UNIT_TEST_SUITE(PgOptimizer) |