diff options
author | shumkovnd <shumkovnd@yandex-team.com> | 2023-10-18 22:34:25 +0300 |
---|---|---|
committer | shumkovnd <shumkovnd@yandex-team.com> | 2023-10-18 22:51:27 +0300 |
commit | 4f75a6c99c9d9615b5663caa4632a10dce70a7f0 (patch) | |
tree | 5c27175e46ad1f43942aab9e39223a8d1eff42bd | |
parent | d0676dc5114e84c61a896bba4baac71f0e60be69 (diff) | |
download | ydb-4f75a6c99c9d9615b5663caa4632a10dce70a7f0.tar.gz |
KIKIMR-16538: Add SelectNoAsciiValue test
-rw-r--r-- | ydb/core/kqp/ut/yql/kqp_yql_ut.cpp | 29 |
1 files changed, 29 insertions, 0 deletions
diff --git a/ydb/core/kqp/ut/yql/kqp_yql_ut.cpp b/ydb/core/kqp/ut/yql/kqp_yql_ut.cpp index f2f398838f9..761561c1c22 100644 --- a/ydb/core/kqp/ut/yql/kqp_yql_ut.cpp +++ b/ydb/core/kqp/ut/yql/kqp_yql_ut.cpp @@ -293,6 +293,35 @@ Y_UNIT_TEST_SUITE(KqpYql) { ])", FormatResultSetYson(result.GetResultSet(0))); } + Y_UNIT_TEST(SelectNoAsciiValue) { + auto kikimr = DefaultKikimrRunner(); + TScriptingClient client(kikimr.GetDriver()); + + auto result = client.ExecuteYqlScript(R"( + --!syntax_v1 + CREATE TABLE ascii_test + ( + id String, + PRIMARY KEY (id) + ); + )").GetValueSync(); + UNIT_ASSERT_VALUES_EQUAL_C(result.GetStatus(), EStatus::SUCCESS, result.GetIssues().ToString()); + + auto insertResult = client.ExecuteYqlScript(R"( + --!syntax_v1 + INSERT INTO ascii_test (id) VALUES + ('\xBF'); + )").GetValueSync(); + UNIT_ASSERT_VALUES_EQUAL_C(insertResult.GetStatus(), EStatus::SUCCESS, insertResult.GetIssues().ToString()); + + auto selectResult = client.ExecuteYqlScript(R"( + --!syntax_v1 + SELECT * FROM ascii_test WHERE id='\xBF'; + )").GetValueSync(); + + UNIT_ASSERT_VALUES_EQUAL_C(selectResult.GetStatus(), EStatus::SUCCESS, selectResult.GetIssues().ToString()); + } + Y_UNIT_TEST(ColumnTypeMismatch) { TKikimrRunner kikimr; auto db = kikimr.GetTableClient(); |