2025-11-11 15:36:22,940 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 15:36:22,940 - INFO - ya.test - pytest_runtest_setup: test_json_query
2025-11-11 15:36:22,940 - INFO - ya.test - pytest_runtest_setup: ####################################################################################################
2025-11-11 15:36:22,940 - INFO - ya.test - pytest_runtest_setup: Test setup
2025-11-11 15:36:22,968 - INFO - ya.test - pytest_runtest_call: Test call (class_name: test_select.py::TestSelect, test_name: test_json_query)
2025-11-11 15:36:22,968 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:22,969 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 3f5c24d1-502f-4f5f-8162-f56de44b87d2, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:22,969 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 3f5c24d1-502f-4f5f-8162-f56de44b87d2, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "\n            CREATE TABLE `/Root/select/table38936_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 15:36:22,970 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 3f5c24d1-502f-4f5f-8162-f56de44b87d2, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:23,970 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:23,970 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:23,971 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, c1c9576d-0d0d-43b2-ab46-09a66a33a9d7, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:23,971 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, c1c9576d-0d0d-43b2-ab46-09a66a33a9d7, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table38936_js` (id, vjs) VALUES (11, @@{\"vals\": [{\"vs\": \"a\", \"vn\": 1}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:23,981 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, c1c9576d-0d0d-43b2-ab46-09a66a33a9d7, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,172 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,172 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,173 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 92337e84-021e-4af7-873d-1de76158e7f2, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,173 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 92337e84-021e-4af7-873d-1de76158e7f2, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table38936_js` (id, vjs) VALUES (22, @@{\"vals\": [{\"vs\": \"b\", \"vn\": 2}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,174 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 92337e84-021e-4af7-873d-1de76158e7f2, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,255 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,255 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,255 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, e8370a13-b826-4862-8745-6a9153aaf346, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,256 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, e8370a13-b826-4862-8745-6a9153aaf346, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "INSERT INTO `/Root/select/table38936_js` (id, vjs) VALUES (33, @@{\"vals\": [{\"vs\": \"c\", \"vn\": 3}]}@@);" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,257 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, e8370a13-b826-4862-8745-6a9153aaf346, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,312 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,312 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,313 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b56047ee-8d6e-4ddd-956c-e9caf71a47f7, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,313 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b56047ee-8d6e-4ddd-956c-e9caf71a47f7, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[*].vs\") AS e FROM `/Root/select/table38936_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,314 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b56047ee-8d6e-4ddd-956c-e9caf71a47f7, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,452 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,453 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,453 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, fe196168-a50e-457f-81e9-3ad2757b9d03, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,453 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, fe196168-a50e-457f-81e9-3ad2757b9d03, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_EXISTS(vjs, \"$.vals[1].vs\") AS e FROM `/Root/select/table38936_js`;" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,454 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, fe196168-a50e-457f-81e9-3ad2757b9d03, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,595 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,595 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,596 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 613d7701-faf4-467b-8a81-372106476549, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,596 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 613d7701-faf4-467b-8a81-372106476549, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT id FROM `/Root/select/table38936_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vn\" RETURNING Int32) = 2;" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,597 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 613d7701-faf4-467b-8a81-372106476549, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,748 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,749 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,749 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, b1ceaf8d-346e-4c0a-84ce-1511b298e489, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,749 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, b1ceaf8d-346e-4c0a-84ce-1511b298e489, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT * FROM `/Root/select/table38936_js` WHERE JSON_VALUE(vjs, \"$.vals[0].vs\") LIKE \"%x%\";" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,750 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, b1ceaf8d-346e-4c0a-84ce-1511b298e489, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:24,994 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,994 - DEBUG - ydb.query.pool - acquire: Acquired active session from queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:24,995 - DEBUG - ydb.connection - _prepare_call: RpcState(ExecuteQuery, 264488f1-a469-4b02-bb34-5c7213355037, ghrun-3ynj4chmly.auto.internal:14803): creating call state
2025-11-11 15:36:24,995 - DEBUG - ydb.connection - _log_request: RpcState(ExecuteQuery, 264488f1-a469-4b02-bb34-5c7213355037, ghrun-3ynj4chmly.auto.internal:14803): request = { session_id: "ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==" exec_mode: EXEC_MODE_EXECUTE query_content { syntax: SYNTAX_YQL_V1 text: "SELECT JSON_QUERY(vjs, \"$.vals\") AS json FROM `/Root/select/table38936_js` WHERE id = 11;" } stats_mode: STATS_MODE_NONE }
2025-11-11 15:36:24,996 - DEBUG - ydb.connection - _log_response: RpcState(ExecuteQuery, 264488f1-a469-4b02-bb34-5c7213355037, ghrun-3ynj4chmly.auto.internal:14803): response = { <_MultiThreadedRendezvous object> }
2025-11-11 15:36:25,156 - DEBUG - ydb.query.pool - release: Session returned to queue: ydb://session/3?node_id=1&id=MjU5NzI3NTEtNWJiYTJhOC04YjVjNGY5Ny0zNTM5Y2E1Nw==
2025-11-11 15:36:25,157 - INFO - ya.test - pytest_runtest_teardown: Test teardown
