2025-11-11 13:03:37,612 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 13:03:37,612 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-11 13:03:37,612 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 13:03:37,612 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-11 13:03:37,613 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-11 13:03:37,614 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:37,614 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 8208163b-3851-491e-b647-191cfcb58f1a, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:37,615 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 8208163b-3851-491e-b647-191cfcb58f1a, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table31490_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 13:03:37,616 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 8208163b-3851-491e-b647-191cfcb58f1a, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:37,935 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:37,937 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:37,938 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, c99cea79-1286-4f11-baf5-f1cd277590b1, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:37,939 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, c99cea79-1286-4f11-baf5-f1cd277590b1, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table31490_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:37,940 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, c99cea79-1286-4f11-baf5-f1cd277590b1, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:37,988 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:37,988 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:37,988 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, d63e0e2b-7f40-4976-94f6-0ce1accf54ea, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:37,989 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, d63e0e2b-7f40-4976-94f6-0ce1accf54ea, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table31490_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:37,990 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, d63e0e2b-7f40-4976-94f6-0ce1accf54ea, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,014 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,015 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,015 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, a5eb67f5-8af2-4ba0-b251-163725a23125, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,016 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, a5eb67f5-8af2-4ba0-b251-163725a23125, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table31490_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,016 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, a5eb67f5-8af2-4ba0-b251-163725a23125, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,044 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,045 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,046 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, f50403b4-5654-44dd-a21f-3fdae708a714, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,050 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, f50403b4-5654-44dd-a21f-3fdae708a714, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table31490_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,050 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, f50403b4-5654-44dd-a21f-3fdae708a714, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,126 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,127 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,127 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, e1c38eb7-4b79-4652-8257-56b24a3affc9, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,127 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, e1c38eb7-4b79-4652-8257-56b24a3affc9, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table31490_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,128 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, e1c38eb7-4b79-4652-8257-56b24a3affc9, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,194 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,196 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,197 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 67c5aecd-43d9-4364-917c-f6f1634b610e, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,198 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 67c5aecd-43d9-4364-917c-f6f1634b610e, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table31490_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,199 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 67c5aecd-43d9-4364-917c-f6f1634b610e, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,312 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,313 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,313 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 9245bf0a-06c9-4060-a397-4a3a4c4a605a, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,314 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 9245bf0a-06c9-4060-a397-4a3a4c4a605a, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table31490_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,315 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 9245bf0a-06c9-4060-a397-4a3a4c4a605a, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,390 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,390 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,392 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 77b7efce-70ed-4035-85a9-8d69c2b06e0b, ghrun-3ynj4chmly.auto.internal:5978): creating call state
2025-11-11 13:03:38,393 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 77b7efce-70ed-4035-85a9-8d69c2b06e0b, ghrun-3ynj4chmly.auto.internal:5978): request = { session_id: "ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table31490_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-11 13:03:38,394 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 77b7efce-70ed-4035-85a9-8d69c2b06e0b, ghrun-3ynj4chmly.auto.internal:5978): response = { <_MultiThreadedRendezvous object> }
2025-11-11 13:03:38,480 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=YzNjMDU5YTYtMTU1ZTAxOWMtZGMxNzg4N2QtN2NiYjMxNDA=
2025-11-11 13:03:38,485 - INFO - ya.test - pytest_runtest_teardown: Test teardown
