2025-11-11 14:38:24,199 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 14:38:24,199 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-11 14:38:24,199 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 14:38:24,199 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-11 14:38:24,202 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-11 14:38:24,202 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,203 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 983a0a1f-8a20-47ec-9e88-27c348e25e24, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,204 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 983a0a1f-8a20-47ec-9e88-27c348e25e24, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table75825_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-11 14:38:24,205 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 983a0a1f-8a20-47ec-9e88-27c348e25e24, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,495 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,496 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,497 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 22b25f9d-85a1-4938-aa49-0232b2955564, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,497 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 22b25f9d-85a1-4938-aa49-0232b2955564, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table75825_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,498 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 22b25f9d-85a1-4938-aa49-0232b2955564, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,536 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,537 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,537 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 5a6de272-d959-4c83-a02c-3c9d16a67790, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,538 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 5a6de272-d959-4c83-a02c-3c9d16a67790, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table75825_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,538 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 5a6de272-d959-4c83-a02c-3c9d16a67790, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,564 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,564 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,565 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 96832624-48ff-4aab-a44e-e57e65e96a36, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,565 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 96832624-48ff-4aab-a44e-e57e65e96a36, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table75825_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,566 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 96832624-48ff-4aab-a44e-e57e65e96a36, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,594 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,594 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,595 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, c0f4e193-d3e0-42a1-9bd0-648b03c07622, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,595 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, c0f4e193-d3e0-42a1-9bd0-648b03c07622, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table75825_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,596 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, c0f4e193-d3e0-42a1-9bd0-648b03c07622, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,707 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,708 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,708 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, d524efd8-7544-4faf-9f96-ee9c507b1176, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,709 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, d524efd8-7544-4faf-9f96-ee9c507b1176, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table75825_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,709 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, d524efd8-7544-4faf-9f96-ee9c507b1176, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,768 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,768 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,769 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, a5e5806d-8554-4a86-b173-83969e63fe08, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,770 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, a5e5806d-8554-4a86-b173-83969e63fe08, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table75825_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,770 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, a5e5806d-8554-4a86-b173-83969e63fe08, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,849 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,850 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,850 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 9405ecb5-4d57-4f32-9824-f99011d16561, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,851 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 9405ecb5-4d57-4f32-9824-f99011d16561, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table75825_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,852 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 9405ecb5-4d57-4f32-9824-f99011d16561, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:24,928 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,929 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:24,929 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 8a7c2657-6d0c-498f-916a-488d2e994b8d, ghrun-3ynj4chmly.auto.internal:24021): creating call state
2025-11-11 14:38:24,930 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 8a7c2657-6d0c-498f-916a-488d2e994b8d, ghrun-3ynj4chmly.auto.internal:24021): request = { session_id: "ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table75825_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-11 14:38:24,931 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 8a7c2657-6d0c-498f-916a-488d2e994b8d, ghrun-3ynj4chmly.auto.internal:24021): response = { <_MultiThreadedRendezvous object> }
2025-11-11 14:38:25,010 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=M2U4MGI2YzEtNmZmNmUxOGQtODhlY2Q5NzMtN2Y1Y2Y1MmU=
2025-11-11 14:38:25,012 - INFO - ya.test - pytest_runtest_teardown: Test teardown
