René's URL Explorer Experiment


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

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@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-profiling0
react-import-mapreact,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-controllervoltron_issues_fragments
route-actionissue_layout
fetch-noncev2:f05e17b9-6152-40b5-921d-7724d293bd8c
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-id9B26:64532:938508:CCAF2D:6AFD36AB
html-safe-nonce90c9fc85d74a61fb533649944c73a4c36e6869f4f6021a58cefa42f19890456f
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiI5QjI2OjY0NTMyOjkzODUwODpDQ0FGMkQ6NkFGRDM2QUIiLCJ2aXNpdG9yX2lkIjoiMjM4MTY1NjA4NTc5NTUxODEyMyIsInJlZ2lvbl9lZGdlIjoiaWFkIiwicmVnaW9uX3JlbmRlciI6ImlhZCJ9
visitor-hmac80f5306d308dcc33edaa5b70b8dc7d6b3dc0456815e4e54c44f7520ecce201be
hovercard-subject-tagissue:333067461
github-keyboard-shortcutsrepository,issues,copilot
google-site-verificationApib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I
octolytics-urlhttps://collector.github.com/github/collect
analytics-location///voltron/issues_fragments/issue_layout
fb:app_id1401488693436528
apple-itunes-appapp-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/sqlitebrowser/sqlitebrowser/1431/issue_layout
twitter:imagehttps://opengraph.githubassets.com/0e57a9acb126763adb7f926247d33a3826124a7e801271d6631427c89c45efd5/sqlitebrowser/sqlitebrowser/issues/1431
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/0e57a9acb126763adb7f926247d33a3826124a7e801271d6631427c89c45efd5/sqlitebrowser/sqlitebrowser/issues/1431
og:image:altDetails 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:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernametlhackque
hostnamegithub.com
expected-hostnamegithub.com
None065128366c233a9d57ff68ab6c96e25b99dd1b0ab70d23b70873d3dd6b5e4f19
turbo-cache-controlno-preview
go-importgithub.com/sqlitebrowser/sqlitebrowser git https://github.com/sqlitebrowser/sqlitebrowser.git
octolytics-dimension-user_id7454271
octolytics-dimension-user_loginsqlitebrowser
octolytics-dimension-repository_id19416551
octolytics-dimension-repository_nwosqlitebrowser/sqlitebrowser
octolytics-dimension-repository_publictrue
octolytics-dimension-repository_is_forkfalse
octolytics-dimension-repository_network_root_id19416551
octolytics-dimension-repository_network_root_nwosqlitebrowser/sqlitebrowser
turbo-body-classeslogged-out env-production page-responsive
disable-turbofalse
browser-stats-urlhttps://api.github.com/_private/browser/stats
browser-errors-urlhttps://api.github.com/_private/browser/errors
release941021edf0c2ec58298f4a2c8f27ae507d129c92
ui-targetfull
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1431#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1431
GitHubRepository hosting, code review, and collaborationhttps://github.com/platform
CopilotAI coding agent for tasks, projects, and automated workhttps://github.com/features/copilot
ActionsCI/CD and automationhttps://github.com/features/actions
Code QualityQuality analysis, fixes, and enforcementhttps://github.com/features/code-quality
CodespacesCloud development environmentshttps://github.com/features/codespaces
Code SecurityVulnerability detection and remediationhttps://github.com/security/advanced-security/code-security
Secret ProtectionSecret scanning and leak preventionhttps://github.com/security/advanced-security/secret-protection
All Featureshttps://github.com/features
Documentationhttps://docs.github.com/en
Traininghttps://learn.github.com/skills
Certificationshttps://learn.github.com/credentials
Build with Copilothttps://github.com/features/ai
Customize Copilothttps://docs.github.com/en/copilot/how-tos/copilot-on-github/customize-copilot/customize-copilot-overview
Integrationshttps://github.com/marketplace
Trending reposhttps://github.com/trending
GitHub Sponsorshttps://github.com/open-source/sponsors
Developer articleshttps://github.com/resources/articles
ChangelogYour source for the latest features, improvements, and fixes across GitHub products, all in one place.https://github.blog/changelog/
Enterpriseshttps://github.com/enterprise
Teamhttps://github.com/team
Startupshttps://github.com/enterprise/startups
Nonprofitshttps://github.com/solutions/industry/nonprofits
Healthcarehttps://github.com/solutions/industry/healthcare
Financial serviceshttps://github.com/solutions/industry/financial-services
Manufacturinghttps://github.com/solutions/industry/manufacturing
Governmenthttps://github.com/solutions/industry/government
See all industrieshttps://github.com/solutions/industry
Why GitHubhttps://github.com/why-github
Customer Storieshttps://github.com/customer-stories
Business insightshttps://github.com/solutions/executive-insights
Trust Centerhttps://github.com/trust-center
GitHub Advanced SecurityEnterprise-grade code securityhttps://github.com/security/advanced-security
Copilot for businessEnterprise-grade AI featureshttps://github.com/features/copilot/copilot-business
Premium SupportEnterprise-grade 24/7 supporthttps://github.com/enterprise/premium-support
Documentationhttps://docs.github.com/en
Resource centerhttps://github.com/resources
Bloghttps://github.blog/
Events & webinarshttps://github.com/resources/events
Community Forumhttps://github.com/orgs/community/discussions
Customer Storieshttps://github.com/customer-stories
Integrationshttps://github.com/marketplace
Customer supporthttps://help.github.com/
Traininghttps://learn.github.com/skills
GitHub Statushttps://www.githubstatus.com/
Abouthttps://github.com/about
Partnershttps://github.com/partners
Changeloghttps://github.blog/changelog/
GitHub UniverseThe event for developers, by developers — talks, workshops, and what’s next for GitHub.https://githubuniverse.com/
Pricinghttps://github.com/pricing
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1431
Sign uphttps://github.com/signup?ref_cta=Sign+up&ref_loc=header+logged+out&ref_page=%2F%3Cuser-name%3E%2F%3Crepo-name%3E%2Fvoltron%2Fissues_fragments%2Fissue_layout&source=header-repo&source_repo=sqlitebrowser%2Fsqlitebrowser
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1431
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1431
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1431
sqlitebrowserhttps://github.com/sqlitebrowser
sqlitebrowserhttps://github.com/sqlitebrowser/sqlitebrowser
Codehttps://github.com/sqlitebrowser/sqlitebrowser
Issues786 (786)https://github.com/sqlitebrowser/sqlitebrowser/issues
Pull requests30 (30)https://github.com/sqlitebrowser/sqlitebrowser/pulls
Discussionshttps://github.com/sqlitebrowser/sqlitebrowser/discussions
Actionshttps://github.com/sqlitebrowser/sqlitebrowser/actions
Projectshttps://github.com/sqlitebrowser/sqlitebrowser/projects
Wikihttps://github.com/sqlitebrowser/sqlitebrowser/wiki
Security and qualityhttps://github.com/sqlitebrowser/sqlitebrowser/security
Insightshttps://github.com/sqlitebrowser/sqlitebrowser/insights
https://github.com/sqlitebrowser/sqlitebrowser
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1431
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1431
Execute SQL SELECT returning 0 rows shows stale datahttps://github.com/sqlitebrowser/sqlitebrowser/issues/1431#top
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 17, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issue-333067461
https://github.com/sqlitebrowser/sqlitebrowser#nightly-buildshttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20https://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 17, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-397885120
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Jun 17, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-397893183
@tlhackquehttps://github.com/tlhackque
justinclifthttps://github.com/justinclift
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
on Jun 17, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#event-1685050705
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-398158692
https://sqlite.org/lang_select.htmlhttps://sqlite.org/lang_select.html
https://github.com/chrisjlocke
chrisjlockehttps://github.com/chrisjlocke
on Jun 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-398160343
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-398161740
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jun 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-398184447
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 18, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-398189895
mgrojohttps://github.com/mgrojo
on Jun 19, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#event-1689135855
Reset SQL results table when the query has not returned datahttps://github.com/sqlitebrowser/sqlitebrowser/commit/bf89d992a81e4abdae57f5e996fe5f5f6338415b
bf89d99https://github.com/sqlitebrowser/sqlitebrowser/commit/bf89d992a81e4abdae57f5e996fe5f5f6338415b
MKleusberghttps://github.com/MKleusberg
on Jun 21, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#event-1693220528
Reset SQL results table when the query has not returned datahttps://github.com/sqlitebrowser/sqlitebrowser/commit/01f0146bbeef30cc8c8b634650b3aaf91907810b
01f0146https://github.com/sqlitebrowser/sqlitebrowser/commit/01f0146bbeef30cc8c8b634650b3aaf91907810b
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Jun 23, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-399678920
@tlhackquehttps://github.com/tlhackque
https://github.com/tlhackque
tlhackquehttps://github.com/tlhackque
on Jun 24, 2018https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#issuecomment-399751493
mgrojohttps://github.com/mgrojo
on Oct 14, 2023https://github.com/sqlitebrowser/sqlitebrowser/issues/1431#event-10655922707
Reset SQL results table when the query has not returned datahttps://github.com/sqlitebrowser/sqlitebrowser/commit/ea5cc0ae5ab084c13ebdc1d992f87a14f4723061
ea5cc0ahttps://github.com/sqlitebrowser/sqlitebrowser/commit/ea5cc0ae5ab084c13ebdc1d992f87a14f4723061
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1431
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1431
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
https://github.com
Termshttps://docs.github.com/site-policy/github-terms/github-terms-of-service
Privacyhttps://docs.github.com/site-policy/privacy-policies/github-privacy-statement
Securityhttps://github.com/security
Statushttps://www.githubstatus.com/
Communityhttps://github.community/
Docshttps://docs.github.com/
Contacthttps://support.github.com?tags=dotcom-footer

Viewport: width=device-width


URLs of crawlers that visited me.