René's URL Explorer Experiment


Title: CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction · Issue #1764 · sqlitebrowser/sqlitebrowser · GitHub

Open Graph Title: CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction · Issue #1764 · sqlitebrowser/sqlitebrowser

X Title: CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction · Issue #1764 · sqlitebrowser/sqlitebrowser

Description: Details for the issue What did you do? File > New In-Memory Database Modal: Edit table definition > Cancel File > Import... > Database from SQL file... Modal: Create new database > No export.sql: begin transaction; create table names( id...

Open Graph Description: Details for the issue What did you do? File > New In-Memory Database Modal: Edit table definition > Cancel File > Import... > Database from SQL file... Modal: Create new database > No export.sql: b...

X Description: Details for the issue What did you do? File > New In-Memory Database Modal: Edit table definition > Cancel File > Import... > Database from SQL file... Modal: Create new database > N...

Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/1764

X: @github

direct link

Domain: github.com


Hey, it has json ld scripts:
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transaction","articleBody":"Details for the issue\r\n--------------------\r\n\r\n#### What did you do?\r\n\r\n1. File  > New In-Memory Database\r\n2. Modal: _Edit table definition_ > Cancel\r\n3. File > Import... > Database from SQL file...\r\n4. Modal: _Create new database_ > No\r\n\r\n`export.sql`:\r\n\r\n``` sql\r\nbegin transaction;\r\ncreate table names(\r\n  id integer primary key,\r\n  name text unique\r\n);\r\ncommit;\r\n```\r\n\r\n\r\n#### What did you expect to see?\r\n\r\nMy SQL file imported into the in-memory database\r\n\r\n\r\n#### What did you see instead?\r\n\r\nAlert:  \r\n> Error importing data: Error in statement #\u003cspan>\u003c/span>1: cannot start a transaction within a transaction. Aborting execution and rolling back\r\n\r\n\r\n#### Other notes\r\n\r\nUsing this file instead produces no error:\r\n\r\n`export-case-sensitive.sql`:\r\n\r\n``` sql\r\nBEGIN TRANSACTION;\r\nCREATE TABLE names(\r\n  id integer PRIMARY KEY,\r\n  name text UNIQUE\r\n);\r\nCOMMIT;\r\n```\r\n\r\n\r\nUseful extra information\r\n-------------------------\r\n\r\nmacOS: _10.14.3_  \r\nDB4S: _3.11.1 r2_\r\n\r\n\r\n#### Did you also\r\n\r\n- [ ] [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\r\nPossibly related to #568, #675\r\n","author":{"url":"https://github.com/jsejcksn","@type":"Person","name":"jsejcksn"},"datePublished":"2019-02-24T02:21:12Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/1764"}

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:f2378cb8-0dba-6691-413a-32575fc932dd
current-catalog-service-hash81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114
request-idEDC4:C816B:18DA96:22D4B6:6AFDAE1D
html-safe-nonceba08014c825ca9db635e9aa874a1df7f111a4785838fa9b26dec75f30a1c8d5d
visitor-payloadeyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFREM0OkM4MTZCOjE4REE5NjoyMkQ0QjY6NkFGREFFMUQiLCJ2aXNpdG9yX2lkIjoiOTg4NzcyODIxMzMwOTMxMjI5IiwicmVnaW9uX2VkZ2UiOiJpYWQiLCJyZWdpb25fcmVuZGVyIjoiaWFkIn0=
visitor-hmac358b51af7b5d08d2bdbb73241f2e9189d33f2700edbe9d74c6111817e4f8d50a
hovercard-subject-tagissue:413772403
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/1764/issue_layout
twitter:imagehttps://opengraph.githubassets.com/669437ff58cfa7b830ed8e66f8c4ab8fd61dad5f440af71a950e3e108acf0f40/sqlitebrowser/sqlitebrowser/issues/1764
twitter:cardsummary_large_image
og:imagehttps://opengraph.githubassets.com/669437ff58cfa7b830ed8e66f8c4ab8fd61dad5f440af71a950e3e108acf0f40/sqlitebrowser/sqlitebrowser/issues/1764
og:image:altDetails for the issue What did you do? File > New In-Memory Database Modal: Edit table definition > Cancel File > Import... > Database from SQL file... Modal: Create new database > No export.sql: b...
og:image:width1200
og:image:height600
og:site_nameGitHub
og:typeobject
og:author:usernamejsejcksn
hostnamegithub.com
expected-hostnamegithub.com
Nonebc86424ef34a73b386237872800e922d149d65ba907f63d6f150a2dcb8433bea
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
release0ddf53eb35c87f1f8df13dbf75c3bdadbfc6e969
ui-targetcanary-2
theme-color#1e2327
color-schemelight dark
react-app-nameissues

Links:

Skip to contenthttps://github.com/sqlitebrowser/sqlitebrowser/issues/1764#start-of-content
https://github.com/
Sign inhttps://github.com/login?return_to=https%3A%2F%2Fgithub.com%2Fsqlitebrowser%2Fsqlitebrowser%2Fissues%2F1764
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%2F1764
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/1764
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1764
Reloadhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1764
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/1764
New issuehttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1764
CASE-SENSITIVITY: Error importing data from SQL file: cannot start a transaction within a transactionhttps://github.com/sqlitebrowser/sqlitebrowser/issues/1764#top
https://github.com/MKleusberg
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issue-413772403
Try out the latest nightly versionhttps://github.com/sqlitebrowser/sqlitebrowser#nightly-builds
Search for an existing similar issuehttps://github.com/sqlitebrowser/sqlitebrowser/issues?utf8=%E2%9C%93&q=is%3Aissue%20
#568https://github.com/sqlitebrowser/sqlitebrowser/issues/568
#675https://github.com/sqlitebrowser/sqlitebrowser/issues/675
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-466734079
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 Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2159955921
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-466737427
https://github.com/mgrojo
mgrojohttps://github.com/mgrojo
on Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-466775569
#1045https://github.com/sqlitebrowser/sqlitebrowser/issues/1045
d783d36https://github.com/sqlitebrowser/sqlitebrowser/commit/d783d36dbde97e04827009b6a84d18a984266117
@MKleusberghttps://github.com/MKleusberg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 24, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-466776626
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Feb 25, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467115949
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Feb 25, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467117967
MKleusberghttps://github.com/MKleusberg
on Feb 25, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2162630341
Fix transaction detection in SQL importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/0f6946c19dacb4900336bc3d043f70a3608501f7
0f6946chttps://github.com/sqlitebrowser/sqlitebrowser/commit/0f6946c19dacb4900336bc3d043f70a3608501f7
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Feb 25, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467126741
@jsejcksnhttps://github.com/jsejcksn
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 25, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467223696
@MKleusberghttps://github.com/MKleusberg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 26, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467261807
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 26, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467279792
@justinclifthttps://github.com/justinclift
semverhttps://semver.org/
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 26, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467304187
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Feb 27, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-467819276
@jsejcksnhttps://github.com/jsejcksn
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 27, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-468045770
@MKleusberghttps://github.com/MKleusberg
https://github.com/justinclift
justinclifthttps://github.com/justinclift
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-468110545
https://nightlies.sqlitebrowser.org/latest/https://nightlies.sqlitebrowser.org/latest/
https://github.com/jsejcksn
jsejcksnhttps://github.com/jsejcksn
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-468115509
@MKleusberghttps://github.com/MKleusberg
jsejcksnhttps://github.com/jsejcksn
completedhttps://github.com/sqlitebrowser/sqlitebrowser/issues?q=is%3Aissue%20state%3Aclosed%20archived%3Afalse%20reason%3Acompleted
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2169827532
justinclifthttps://github.com/justinclift
3.12.0 - Future releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2169939444
justinclifthttps://github.com/justinclift
MKleusberghttps://github.com/MKleusberg
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2169939690
https://github.com/MKleusberg
MKleusberghttps://github.com/MKleusberg
on Feb 28, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#issuecomment-468277905
@jsejcksnhttps://github.com/jsejcksn
MKleusberghttps://github.com/MKleusberg
3.12.0 - Future releasehttps://github.com/sqlitebrowser/sqlitebrowser/milestone/15
3.11.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
on Mar 30, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2240978257
MKleusberghttps://github.com/MKleusberg
on Mar 30, 2019https://github.com/sqlitebrowser/sqlitebrowser/issues/1764#event-2240979257
Fix transaction detection in SQL importhttps://github.com/sqlitebrowser/sqlitebrowser/commit/16bf93bab62b37c80722960d3d1e17bf54178aa2
16bf93bhttps://github.com/sqlitebrowser/sqlitebrowser/commit/16bf93bab62b37c80722960d3d1e17bf54178aa2
Sign up for freehttps://github.com/signup?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1764
Sign in to commenthttps://github.com/login?return_to=https://github.com/sqlitebrowser/sqlitebrowser/issues/1764
MKleusberghttps://github.com/MKleusberg
bugConfirmed bugs or reports that are very likely to be bugs.https://github.com/sqlitebrowser/sqlitebrowser/issues?q=state%3Aopen%20label%3A%22bug%22
3.11.2https://github.com/sqlitebrowser/sqlitebrowser/milestone/17
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.