这是什么错误
OR: Exception in
ASGI application
+ Exception Group Traceback
(most recent call l
ast
):
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_utils.py", line 76, in collapse_excgroups
| yield
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 186, in __call__
|
async with anyio.create_t
ask_group
() as t
ask_group:
| ^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/anyio/_backends/_
asyncio.py", line 763, in __aexit__
| raise B
aseExceptionGroup
(
| ExceptionGroup: unhandled errors in a T
askGroup
(1 sub-exception
)
+-+---------------- 1 ----------------
| Traceback
(most recent call l
ast
):
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/uvicorn/protocols/http/httptools_impl.py", line 409, in run_
asgi
| result = await app
( # type: ignore[func-returns-value]
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
| return await self.app
(scope, receive, send
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/applications.py", line 1054, in __call__
| await super
().__call__
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/applications.py", line 113, in __call__
| await self.middleware_stack
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
| raise exc
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
| await self.app
(scope, receive, _send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 85, in __call__
| await self.app
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 185, in __call__
| with collapse_excgroups
():
| ^^^^^^^^^^^^^^^^^^^^
| File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/contextlib.py", line 158, in __exit__
| self.gen.throw
(value
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_utils.py", line 82, in collapse_excgroups
| raise exc
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 187, in __call__
| response = await self.dispatch_func
(request, call_next
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/middlewares/request_logger_middleware.py", line 17, in dispatch
| response = await call_next
(request
)
| ^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 163, in call_next
| raise app_exc
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 149, in coro
| await self.app
(scope, receive_or_disconnect, send_no_error
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
| await wrap_app_handling_exceptions
(self.app, conn
)(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
| raise exc
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
| await app
(scope, receive, sender
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 715, in __call__
| await self.middleware_stack
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 735, in app
| await route.handle
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
| await self.app
(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
| await wrap_app_handling_exceptions
(app, request
)(scope, receive, send
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
| raise exc
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
| await app
(scope, receive, sender
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
| response = await f
(request
)
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/routing.py", line 301, in app
| raw_response = await run_endpoint_function
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/routing.py", line 212, in run_endpoint_function
| return await dependant.call
(**values
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/api/v1/ai.py", line 67, in query_ai_analysis_data_table
| ai_analysis_data = await ai.analysis_report_time
(db, ai_analysis_data
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/services/ai.py", line 362, in analysis_report_time
| cursor_num = await db.execute
(stmt_num
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/ext/
asyncio/session.py", line 461, in execute
| result = await greenlet_spawn
(
| ^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 190, in greenlet_spawn
| result = context.switch
(*args, **kwargs
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
| return self._execute_internal
(
| ^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
| result: Result[Any] = compile_state_cls.orm_execute_statement
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
| result = conn.execute
(
| ^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/engine/b
ase.py", line 1418, in execute
| return meth
(
| ^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
| return connection._execute_clauseelement
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/engine/b
ase.py", line 1632, in _execute_clauseelement
| compiled_sql, extracted_params, cache_hit = elem._compile_w_cache
(
| ^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 703, in _compile_w_cache
| compiled_sql = self._compiler
(
| ^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 316, in _compiler
| return dialect.statement_compiler
(dialect, self, **kw
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 1429, in __init__
| Compiled.__init__
(self, dialect, statement, **kwargs
)
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 870, in __init__
| self.string = self.process
(self.statement, **compile_kwargs
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 915, in process
| return obj._compiler_dispatch
(self, **kwargs
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
| return meth
(self, **kw
) # type: ignore # noqa: E501
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4824, in visit_select
| text = self._compose_select_body
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4973, in _compose_select_body
| f._compiler_dispatch
(
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
| return meth
(self, **kw
) # type: ignore # noqa: E501
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/b
ase.py", line 1607, in visit_
join
| self.process
(
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 915, in process
| return obj._compiler_dispatch
(self, **kwargs
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
| return meth
(self, **kw
) # type: ignore # noqa: E501
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4309, in visit_lateral
| return "LATERAL %s" % self.visit_ali
as(lateral_, **kw
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4262, in visit_ali
as
| inner = ali
as.element._compiler_dispatch
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
| return meth
(self, **kw
) # type: ignore # noqa: E501
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4305, in visit_
subquery
| return self.visit_ali
as(subquery, **kw
)
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4234, in visit_ali
as
| inner = ali
as.element._compiler_dispatch
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
| return meth
(self, **kw
) # type: ignore # noqa: E501
| ^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4734, in visit_select
|
froms = self._setup_select_stack
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4904, in _setup_select_stack
|
froms = compile_state._get_display_
froms
(
| ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/selectable.py", line 4793, in _get_display_
froms
| raise exc.InvalidRequestError
(
| sqlalchemy.exc.InvalidRequestError: Select statement '<sqlalchemy.sql.selectable.Select object at 0x1394546e0>' returned no
FROM clauses due to auto-correlation; specify correlate
(<tables>
) to control correlation manually.
+------------------------------------
During handling of the above exception, a
nother exception occurred:
Traceback
(most recent call l
ast
):
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/uvicorn/protocols/http/httptools_impl.py", line 409, in run_
asgi
result = await app
( # type: ignore[func-returns-value]
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/uvicorn/middleware/proxy_headers.py", line 60, in __call__
return await self.app
(scope, receive, send
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/applications.py", line 1054, in __call__
await super
().__call__
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/applications.py", line 113, in __call__
await self.middleware_stack
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 187, in __call__
raise exc
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/errors.py", line 165, in __call__
await self.app
(scope, receive, _send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/cors.py", line 85, in __call__
await self.app
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 185, in __call__
with collapse_excgroups
():
^^^^^^^^^^^^^^^^^^^^
File "/Library/Frameworks/Python.framework/Versions/3.12/lib/python3.12/contextlib.py", line 158, in __exit__
self.gen.throw
(value
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_utils.py", line 82, in collapse_excgroups
raise exc
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 187, in __call__
response = await self.dispatch_func
(request, call_next
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/middlewares/request_logger_middleware.py", line 17, in dispatch
response = await call_next
(request
)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 163, in call_next
raise app_exc
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/b
ase.py", line 149, in coro
await self.app
(scope, receive_or_disconnect, send_no_error
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/middleware/exceptions.py", line 62, in __call__
await wrap_app_handling_exceptions
(self.app, conn
)(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app
(scope, receive, sender
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 715, in __call__
await self.middleware_stack
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 735, in app
await route.handle
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 288, in handle
await self.app
(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 76, in app
await wrap_app_handling_exceptions
(app, request
)(scope, receive, send
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 53, in wrapped_app
raise exc
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/_exception_handler.py", line 42, in wrapped_app
await app
(scope, receive, sender
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/starlette/routing.py", line 73, in app
response = await f
(request
)
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/routing.py", line 301, in app
raw_response = await run_endpoint_function
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/f
astapi/routing.py", line 212, in run_endpoint_function
return await dependant.call
(**values
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/api/v1/ai.py", line 67, in query_ai_analysis_data_table
ai_analysis_data = await ai.analysis_report_time
(db, ai_analysis_data
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/06.renwu/00.fix_bug/test-automation-platform-backend/src/app/services/ai.py", line 362, in analysis_report_time
cursor_num = await db.execute
(stmt_num
)
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/ext/
asyncio/session.py", line 461, in execute
result = await greenlet_spawn
(
^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/util/_concurrency_py3k.py", line 190, in greenlet_spawn
result = context.switch
(*args, **kwargs
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2362, in execute
return self._execute_internal
(
^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/session.py", line 2247, in _execute_internal
result: Result[Any] = compile_state_cls.orm_execute_statement
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/orm/context.py", line 305, in orm_execute_statement
result = conn.execute
(
^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/engine/b
ase.py", line 1418, in execute
return meth
(
^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 515, in _execute_on_connection
return connection._execute_clauseelement
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/engine/b
ase.py", line 1632, in _execute_clauseelement
compiled_sql, extracted_params, cache_hit = elem._compile_w_cache
(
^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 703, in _compile_w_cache
compiled_sql = self._compiler
(
^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/elements.py", line 316, in _compiler
return dialect.statement_compiler
(dialect, self, **kw
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 1429, in __init__
Compiled.__init__
(self, dialect, statement, **kwargs
)
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 870, in __init__
self.string = self.process
(self.statement, **compile_kwargs
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 915, in process
return obj._compiler_dispatch
(self, **kwargs
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
return meth
(self, **kw
) # type: ignore # noqa: E501
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4824, in visit_select
text = self._compose_select_body
(
^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4973, in _compose_select_body
f._compiler_dispatch
(
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
return meth
(self, **kw
) # type: ignore # noqa: E501
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/dialects/mysql/b
ase.py", line 1607, in visit_
join
self.process
(
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 915, in process
return obj._compiler_dispatch
(self, **kwargs
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
return meth
(self, **kw
) # type: ignore # noqa: E501
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4309, in visit_lateral
return "LATERAL %s" % self.visit_ali
as(lateral_, **kw
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4262, in visit_ali
as
inner = ali
as.element._compiler_dispatch
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
return meth
(self, **kw
) # type: ignore # noqa: E501
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4305, in visit_
subquery
return self.visit_ali
as(subquery, **kw
)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4234, in visit_ali
as
inner = ali
as.element._compiler_dispatch
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/visitors.py", line 141, in _compiler_dispatch
return meth
(self, **kw
) # type: ignore # noqa: E501
^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4734, in visit_select
froms = self._setup_select_stack
(
^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/compiler.py", line 4904, in _setup_select_stack
froms = compile_state._get_display_
froms
(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/qxz5mik/platform_work/04.code/test-automation-platform-backend/.venv/lib/python3.12/site-packages/sqlalchemy/sql/selectable.py", line 4793, in _get_display_
froms
raise exc.InvalidRequestError
(
sqlalchemy.exc.InvalidRequestError: Select statement '<sqlalchemy.sql.selectable.Select object at 0x1394546e0>' returned no
FROM clauses due to auto-correlation; specify correlate
(<tables>
) to control correlation manually.
本文探讨了不同数据库系统中FROM子句使用子查询的支持情况。T-SQL和Sybase提供了较好的支持，而PL/SQL（Oracle）、MySQL则存在限制。文章还提到了子查询的相关执行原理。
扫一扫
376
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
