Title: Execute SQL SELECT returning 0 rows shows stale data · Issue #1431 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: Execute SQL SELECT returning 0 rows shows stale data · Issue #1431 · sqlitebrowser/sqlitebrowser
X Title: Execute SQL SELECT returning 0 rows shows stale data · Issue #1431 · sqlitebrowser/sqlitebrowser
Description: Details for the issue This is a usability issue - I consider it a bug. What did you do? In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display. Modify the SELECT such that no rows are returned and execute...
Open Graph Description: Details for the issue This is a usability issue - I consider it a bug. What did you do? In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display. Modify the SELECT su...
X Description: Details for the issue This is a usability issue - I consider it a bug. What did you do? In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display. Modify the SELECT su...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1431
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Execute SQL SELECT returning 0 rows shows stale data","articleBody":"Details for the issue\r\n--------------------\r\nThis is a usability issue - I consider it a bug.\r\n\r\n#### What did you do?\r\n1) In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display.\r\n2) Modify the SELECT such that no rows are returned and execute that\r\n\r\n#### What did you expect to see?\r\nThe results pane should be empty.\r\nThe status pane should say \"no rows selected\"\r\n\r\n#### What did you see instead?\r\nThe results of the first select remain on the screen.\r\nThe status pane says 'query executed successfully: ...'\r\n\r\nBut it doesn't say \"0 rows returned\" and the results pane shows the data from the first SELECT.\r\n\r\nThis is very confusing - I'm seeing stale data from a previous command.\r\nAs I experiment with various queries, the stale data can be from several commands back.\r\n\r\nThere should be positive indication that the query returned no data, and the old results should be removed from the display.\r\n\r\nUseful extra information\r\n-------------------------\r\n\r\nThe info below often helps, please fill it out if you're able to. :)\r\n\r\n#### What operating system are you using?\r\n\r\n- [ x] Windows: ( _version:_10 pro ___ )\r\n- [ ] Linux: ( _distro:_ ___ )\r\n- [ ] Mac OS: ( _version:_ ___ )\r\n- [ ] Other: ___\r\n\r\n#### What is your DB4S version?\r\n\r\n- [ ] 3.10.1\r\n- [ ] 3.10.0\r\n- [ ] 3.9.1\r\n- [ x] Other: 3.10.99 (Jun 15)\r\n\r\n#### Did you also\r\n\r\n- [ x] Try out the latest nightly version: https://github.com/sqlitebrowser/sqlitebrowser#nightly-builds\r\n- [ x] Search for an existing similar issue: https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20\r\n","author":{"url":"https://github.com/tlhackque","@type":"Person","name":"tlhackque"},"datePublished":"2018-06-17T14:35:32Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1431"}
| react-profiling | 0 |
| react-import-map | react,react-dom,react-dom/client,react-dom/profiling,react-is,react/compiler-runtime,react/jsx-dev-runtime,react/jsx-runtime,scheduler@b8488ee2c322 |
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:f05e17b9-6152-40b5-921d-7724d293bd8c |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | 9B26:64532:938508:CCAF2D:6AFD36AB |
| html-safe-nonce | 90c9fc85d74a61fb533649944c73a4c36e6869f4f6021a58cefa42f19890456f |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QjI2OjY0NTMyOjkzODUwODpDQ0FGMkQ6NkFGRDM2QUIiLCJ2aXNpdG9yX2lkIjoiMjM4MTY1NjA4NTc5NTUxODEyMyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9 |
| visitor-hmac | 80f5306d308dcc33edaa5b70b8dc7d6b3dc0456815e4e54c44f7520ecce201be |
| hovercard-subject-tag | issue:333067461 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1431/issue_layout |
| twitter:image | https://opengraph.githubassets.com/0e57a9acb126763adb7f926247d33a3826124a7e801271d6631427c89c45efd5/sqlitebrowser/sqlitebrowser/issues/1431 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/0e57a9acb126763adb7f926247d33a3826124a7e801271d6631427c89c45efd5/sqlitebrowser/sqlitebrowser/issues/1431 |
| og:image:alt | Details for the issue This is a usability issue - I consider it a bug. What did you do? In the Execute SQL tab, execute a SELECT that returns a few rows of data, which display. Modify the SELECT su... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | tlhackque |
| hostname | github.com |
| expected-hostname | github.com |
| None | 065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19 |
| turbo-cache-control | no-preview |
| go-import | github.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git |
| octolytics-dimension-user_id | 7454271 |
| octolytics-dimension-user_login | sqlitebrowser |
| octolytics-dimension-repository_id | 19416551 |
| octolytics-dimension-repository_nwo | sqlitebrowser/sqlitebrowser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 19416551 |
| octolytics-dimension-repository_network_root_nwo | sqlitebrowser/sqlitebrowser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 941021edf0c2ec58298f4a2c8f27ae507d129c92 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width