2025-11-01 16:45:07,440 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-01 16:45:07,441 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-01 16:45:07,441 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-01 16:45:07,441 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-01 16:45:07,447 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-01 16:45:07,448 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:07,449 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 62712c98-5f27-4f9f-b016-8006d82b49d0, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:07,449 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 62712c98-5f27-4f9f-b016-8006d82b49d0, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table15608_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 16:45:07,450 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 62712c98-5f27-4f9f-b016-8006d82b49d0, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:07,939 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:07,939 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:07,940 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 3f09f8d3-e48a-4f8b-ab49-ca7a67216969, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:07,940 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 3f09f8d3-e48a-4f8b-ab49-ca7a67216969, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table15608_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:07,942 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 3f09f8d3-e48a-4f8b-ab49-ca7a67216969, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:07,994 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,021 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,022 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 8f3c570a-ffa2-48f8-a1b6-921ef2e1d122, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,022 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 8f3c570a-ffa2-48f8-a1b6-921ef2e1d122, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table15608_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,025 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 8f3c570a-ffa2-48f8-a1b6-921ef2e1d122, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,052 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,053 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,053 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 909b4108-ec80-4f35-8ef1-b515eb357b18, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,053 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 909b4108-ec80-4f35-8ef1-b515eb357b18, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table15608_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,054 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 909b4108-ec80-4f35-8ef1-b515eb357b18, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,092 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,093 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,094 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 989b828c-e78e-4052-b241-ec2b8913aecd, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,094 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 989b828c-e78e-4052-b241-ec2b8913aecd, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table15608_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,095 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 989b828c-e78e-4052-b241-ec2b8913aecd, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,192 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,193 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,193 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, f336e807-0e45-4584-978c-316c7df91fbc, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,193 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, f336e807-0e45-4584-978c-316c7df91fbc, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table15608_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,194 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, f336e807-0e45-4584-978c-316c7df91fbc, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,274 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,275 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,275 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 55db03d3-ddff-4ce8-88ee-564f5373f772, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,275 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 55db03d3-ddff-4ce8-88ee-564f5373f772, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table15608_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,276 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 55db03d3-ddff-4ce8-88ee-564f5373f772, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,366 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,367 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,368 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, cba3bd1d-6fe9-46c2-836b-5f26903804b6, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,373 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, cba3bd1d-6fe9-46c2-836b-5f26903804b6, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table15608_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,379 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, cba3bd1d-6fe9-46c2-836b-5f26903804b6, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,489 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,489 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,490 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b039102e-367b-42e7-a0ff-085f6333781a, ghrun-tvlw7frnpa.auto.internal:24650): creating call state
2025-11-01 16:45:08,490 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b039102e-367b-42e7-a0ff-085f6333781a, ghrun-tvlw7frnpa.auto.internal:24650): request = { session_id: "ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table15608_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-01 16:45:08,491 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b039102e-367b-42e7-a0ff-085f6333781a, ghrun-tvlw7frnpa.auto.internal:24650): response = { <_MultiThreadedRendezvous object> }
2025-11-01 16:45:08,587 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=NDdhYmMzNWYtMjhmOWI1NTMtY2QyZDNhZTYtNTQ0NDZjYjk=
2025-11-01 16:45:08,589 - INFO - ya.test - pytest_runtest_teardown: Test teardown
