Skip to content

Execute SQL SELECT returning 0 rows shows stale data #1431

@tlhackque

Description

@tlhackque

Details for the issue

This is a usability issue - I consider it a bug.

What did you do?

  1. In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display.
  2. Modify the SELECT such that no rows are returned and execute that

What did you expect to see?

The results pane should be empty.
The status pane should say "no rows selected"

What did you see instead?

The results of the first select remain on the screen.
The status pane says 'query executed successfully: ...'

But it doesn't say "0 rows returned" and the results pane shows the data from the first SELECT.

This is very confusing - I'm seeing stale data from a previous command.
As I experiment with various queries, the stale data can be from several commands back.

There should be positive indication that the query returned no data, and the old results should be removed from the display.

Useful extra information

The info below often helps, please fill it out if you're able to. :)

What operating system are you using?

  • [ x] Windows: ( _version:_10 pro ___ )
  • Linux: ( distro: ___ )
  • Mac OS: ( version: ___ )
  • Other: ___

What is your DB4S version?

  • 3.10.1
  • 3.10.0
  • 3.9.1
  • [ x] Other: 3.10.99 (Jun 15)

Did you also

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugConfirmed bugs or reports that are very likely to be bugs.

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions