'ViewCommand' object has no attribute 'auto_commit'

[d3xter]

Describe the bug

When changing the SELECT query of a View, no rows are displayed and "Total rows 0 of x" is shown at the bottom.

To Reproduce

Steps to reproduce the behavior:

1. Create a simple View
2. Right Click on the View -> View/Edit Data -> All Rows
3. Change the query, e. g. add a "WHERE 1 = 1" at the end

Expected behavior

Rows are shown

Error message

2024-04-17 00:00:17,593: ERROR pgadmin: 'ViewCommand' object has no attribute 'auto_commit'
Traceback (most recent call last):
File "/usr/pgadmin4/venv/lib64/python3.12/site-packages/flask/app.py", line 1484, in full_dispatch_request
rv = self.dispatch_request()
^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib64/python3.12/site-packages/flask/app.py", line 1469, in dispatch_request
return self.ensure_sync(self.view_functions[rule.endpoint])(**view_args)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/venv/lib64/python3.12/site-packages/flask_login/utils.py", line 290, in decorated_view
return current_app.ensure_sync(func)(*args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/web/pgadmin/tools/sqleditor/init.py", line 887, in start_query_tool
return StartRunningQuery(blueprint, current_app.logger).execute(
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/web/pgadmin/tools/sqleditor/utils/start_running_query.py", line 93, in execute
self.__execute_query(
File "/usr/pgadmin4/web/pgadmin/tools/sqleditor/utils/start_running_query.py", line 140, in __execute_query
if StartRunningQuery.is_begin_required_for_sql_query(trans_obj,
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/pgadmin4/web/pgadmin/tools/sqleditor/utils/start_running_query.py", line 177, in is_begin_required_for_sql_query
return (not trans_obj.auto_commit and
^^^^^^^^^^^^^^^^^^^^^
AttributeError: 'ViewCommand' object has no attribute 'auto_commit'

Screenshots

Original query:

After changing the query:

Desktop (please complete the following information):

• OS: Fedora 39
• Version: 8.5
• Mode: Desktop
• Package type: RPM

[mtovmassian]

I got the same error while executing a request for creating a table from a select query. Example: create table foo as select * from bar; .
But this error appears only when the request is executed from a View/Edit Data tab converted to a Query Tool tab.
When executed directly in a Query Tool tab everything works as expected.

[anilsahoo20]

Tested and verified on snapshot build: https://www.postgresql.org/ftp/pgadmin/pgadmin4/snapshots/2024-04-26/
Environment: macOs Ventura 13.5.1
Package: arm64