2025-11-01 20:00:52,382 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-01 20:00:52,395 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-01 20:00:52,395 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-01 20:00:52,401 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-01 20:00:52,405 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-01 20:00:52,406 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:52,412 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 28c381db-5a1b-42a2-be7d-e86f3b77e5c8, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:52,413 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 28c381db-5a1b-42a2-be7d-e86f3b77e5c8, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table85404_js` (\n                id Uint64 NOT NULL,\n                vjs Json,\n                PRIMARY KEY(id),\n            )\n            WITH (\n                STORE = COLUMN\n            )\n            " } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:52,418 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 28c381db-5a1b-42a2-be7d-e86f3b77e5c8, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,084 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,177 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,177 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, e262e016-8a8e-47db-aa44-3890496f18da, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,178 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, e262e016-8a8e-47db-aa44-3890496f18da, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table85404_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,180 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, e262e016-8a8e-47db-aa44-3890496f18da, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,256 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,256 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,257 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 0c844d82-2081-4cb6-9c67-4cba9d471d5a, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,262 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 0c844d82-2081-4cb6-9c67-4cba9d471d5a, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table85404_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,263 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 0c844d82-2081-4cb6-9c67-4cba9d471d5a, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,298 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,299 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,347 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, fa8012ec-7c1f-4824-a623-64920a368c22, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,348 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, fa8012ec-7c1f-4824-a623-64920a368c22, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table85404_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,349 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, fa8012ec-7c1f-4824-a623-64920a368c22, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,419 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,459 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,460 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, a258ddfa-51b4-4499-b473-5234b166dcd5, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,460 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, a258ddfa-51b4-4499-b473-5234b166dcd5, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table85404_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,466 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, a258ddfa-51b4-4499-b473-5234b166dcd5, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,554 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,554 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,555 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, d7f137b8-ae97-4340-808d-57261bf6b26b, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,556 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, d7f137b8-ae97-4340-808d-57261bf6b26b, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table85404_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,597 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, d7f137b8-ae97-4340-808d-57261bf6b26b, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,677 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,677 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,678 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 32ee1745-1f5d-4b95-a981-7103d48c024d, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,687 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 32ee1745-1f5d-4b95-a981-7103d48c024d, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table85404_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,696 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 32ee1745-1f5d-4b95-a981-7103d48c024d, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,808 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,852 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:53,852 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 599ef0c5-5b2f-4971-b8a0-411bc72e8e58, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:53,853 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 599ef0c5-5b2f-4971-b8a0-411bc72e8e58, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table85404_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:53,855 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 599ef0c5-5b2f-4971-b8a0-411bc72e8e58, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:53,988 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:54,027 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:54,028 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b3ef7fe8-4cb9-4548-8df7-052a8a488dfe, ghrun-mjpjznvske.auto.internal:64826): creating call state
2025-11-01 20:00:54,028 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b3ef7fe8-4cb9-4548-8df7-052a8a488dfe, ghrun-mjpjznvske.auto.internal:64826): request = { session_id: "ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table85404_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-01 20:00:54,029 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b3ef7fe8-4cb9-4548-8df7-052a8a488dfe, ghrun-mjpjznvske.auto.internal:64826): response = { <_MultiThreadedRendezvous object> }
2025-11-01 20:00:54,172 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWUxMmQzZWYtYTE3ZmEyMGEtYWZhNDQxNzgtZmE2ZjMyM2I=
2025-11-01 20:00:54,217 - INFO - ya.test - pytest_runtest_teardown: Test teardown
