V2025.3 Query Output

已回答

When I have a single editor file containing multiple SELECT statements (separated by semicolons or blank lines) and execute the entire script, DataGrip only displays the result set for the last executed statement. Previous result sets are immediately overwritten or not displayed, effectively losing the output of the preceding queries.

This behavior occurs when the standard DataGrip default is active (i.e., "Open results in new tab" is unchecked), and prevents users from simultaneously viewing the results of a multi-statement script.

  1. Ensure the setting "Open results in new tab" (under Database | Query Execution | Output and Results) is unchecked (the default "fresh mindset" behavior).
  2. Open a new SQL file or console.
  3. Enter the following two distinct queries in a single file (below)
  4. Execute the entire script
  5. The Services tool window should display two separate result tabs (one for table_a and one for table_b), allowing the user to view the output of all statements run in the script.

```

select top 1 * from table_a;

select top 1 * from table_b;

```

The Services tool window only displays one result tab containing the output of select top 1 * from table_b. The output for the first query is not displayed.

Executing a multi-statement script should automatically open one query results tab for each SELECT statement.

Checking "Open results in new tab" is not a sufficient work-around as it does not overwrite the output of a previously run query.

 

3

Hi Johnwdunn20,

I've just filed a new bug in our tracker: DBE-24835. We're working on it, sorry for the inconvenience. In the meantime, you can follow DBE-24835 for updates (here's how).

1

Dear DataGrip Team,

I would like to express my concern regarding the recent changes in how result sets are displayed when executing multi-statement SQL scripts. Previously, it was highly convenient to view and compare the output of multiple SELECT statements simultaneously, as each query result was displayed in its own tab.

Currently, with the default "Open results in new tab" setting unchecked, executing a script that includes multiple SELECT statements only retains the result for the last executed statement, resulting in the loss of previous outputs.

Restoring the ability to view outputs from all queries in separate tabs would greatly enhance user experience, allowing for easier comparison of results.

Thank you for your attention to this matter. I look forward to your prompt resolution.

1

请先登录再写评论。