2025-11-10 10:00:35,227 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-10 10:00:35,227 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-10 10:00:35,227 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-10 10:00:35,227 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-10 10:00:35,229 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-10 10:00:35,229 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,230 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, e4442070-6de8-46a5-a593-c2aa668adb74, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,230 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, e4442070-6de8-46a5-a593-c2aa668adb74, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table55581_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-10 10:00:35,231 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, e4442070-6de8-46a5-a593-c2aa668adb74, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,575 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,576 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,576 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 5b8c660c-5e42-4729-bfbf-5d7ef45bccd9, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,577 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 5b8c660c-5e42-4729-bfbf-5d7ef45bccd9, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table55581_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,578 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 5b8c660c-5e42-4729-bfbf-5d7ef45bccd9, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,643 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,643 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,644 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, da8a0c78-a91b-4640-aaf3-c52b232d3dad, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,645 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, da8a0c78-a91b-4640-aaf3-c52b232d3dad, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table55581_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,646 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, da8a0c78-a91b-4640-aaf3-c52b232d3dad, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,673 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,675 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,676 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 900236ab-194e-44db-9991-f067c8ada33f, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,677 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 900236ab-194e-44db-9991-f067c8ada33f, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table55581_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,679 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 900236ab-194e-44db-9991-f067c8ada33f, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,706 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,707 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,707 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, d8266342-e030-4df7-85a0-90c0056fe83e, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,708 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, d8266342-e030-4df7-85a0-90c0056fe83e, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table55581_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,709 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, d8266342-e030-4df7-85a0-90c0056fe83e, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,799 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,800 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,800 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 9033a8a6-5853-4228-9dc3-c3a892aced0c, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,801 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 9033a8a6-5853-4228-9dc3-c3a892aced0c, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table55581_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,802 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 9033a8a6-5853-4228-9dc3-c3a892aced0c, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,872 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,872 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,873 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 22723971-e2a2-4b7b-a862-4f1e48609a21, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,873 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 22723971-e2a2-4b7b-a862-4f1e48609a21, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table55581_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,874 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 22723971-e2a2-4b7b-a862-4f1e48609a21, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:35,962 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,963 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:35,963 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 91ace5e7-d691-440c-8231-9da8bfc0444b, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:35,964 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 91ace5e7-d691-440c-8231-9da8bfc0444b, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table55581_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:35,965 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 91ace5e7-d691-440c-8231-9da8bfc0444b, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:36,050 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:36,051 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:36,052 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 09424499-6122-4d8e-8722-36b491c31d6e, ghrun-kipqlopw2q.auto.internal:31931): creating call state
2025-11-10 10:00:36,052 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 09424499-6122-4d8e-8722-36b491c31d6e, ghrun-kipqlopw2q.auto.internal:31931): request = { session_id: "ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table55581_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-10 10:00:36,053 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 09424499-6122-4d8e-8722-36b491c31d6e, ghrun-kipqlopw2q.auto.internal:31931): response = { <_MultiThreadedRendezvous object> }
2025-11-10 10:00:36,142 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=ZWNlOGQzMjgtMzE5Njk2OTgtMmE0Mzg1ZWEtNGY4MGU3ZGU=
2025-11-10 10:00:36,143 - INFO - ya.test - pytest_runtest_teardown: Test teardown
