Title: [Bug]: Crash when re-enabling "AI" on first column after setting PK on second column · Issue #3953 · sqlitebrowser/sqlitebrowser · GitHub
Open Graph Title: [Bug]: Crash when re-enabling "AI" on first column after setting PK on second column · Issue #3953 · sqlitebrowser/sqlitebrowser
X Title: [Bug]: Crash when re-enabling "AI" on first column after setting PK on second column · Issue #3953 · sqlitebrowser/sqlitebrowser
Description: What did you do? [DB] Browser for SQLite crashes when re-enabling the AI (Auto Increment) checkbox on the first column, after setting PK (Primary Key) on the second column. In this scenario, the AI checkbox is silently disabled (unchecke...
Open Graph Description: What did you do? [DB] Browser for SQLite crashes when re-enabling the AI (Auto Increment) checkbox on the first column, after setting PK (Primary Key) on the second column. In this scenario, the AI...
X Description: What did you do? [DB] Browser for SQLite crashes when re-enabling the AI (Auto Increment) checkbox on the first column, after setting PK (Primary Key) on the second column. In this scenario, the AI...
Opengraph URL: https://github.com/sqlitebrowser/sqlitebrowser/issues/3953
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[Bug]: Crash when re-enabling \"AI\" on first column after setting PK on second column","articleBody":"### What did you do?\n\n[DB] Browser for SQLite crashes when re-enabling the AI (Auto Increment) checkbox on the first column, after setting PK (Primary Key) on the second column. In this scenario, the AI checkbox is silently disabled (unchecked) on the first column, but PK remains checked on the second.\n\nSteps to Reproduce:\n\n1. Create a new table\n2. Add two columns (e.g. id and title)\n3. In the first column (id), check AI → Note: PK is auto-checked as well\n4. In the second column (title), check PK → The AI in the first column is now silently unchecked (but PK remains in the second column)\n5. Now go back to the first column and re-check AI\n6. The application crashes immediately without warning or error message.\n\nhttps://github.com/user-attachments/assets/da766aff-10b8-4458-8051-6a2dbfa3dda4\n\nCrash is 100% reproducible\n\n\n### What did you expect to see?\n\nEither a warning should appear saying AI can only be enabled if that column is the sole primary key or AI should be greyed out / disabled unless PK is active on the same column\n\n### What did you see instead?\n\nThe application crashes immediately without warning or error message.\n\n### DB4S Version\n\n3.13.1\n\n### What OS are you seeing the problem on?\n\nMacOS\n\n### OS version\n\nSequoia 15.5\n\n### Relevant log output\n\n```shell\nProcess: DB Browser for SQLite [36691]\nPath: /Applications/DB Browser for SQLite.app/Contents/MacOS/DB Browser for SQLite\nIdentifier: net.sourceforge.sqlitebrowser\nVersion: 3.13.1 (3.13.1)\nOS Version: macOS 15.5 (24F74)\nSystem Integrity Protection: enabled\n\nException Type: EXC_BAD_ACCESS (SIGSEGV)\nException Codes: KERN_INVALID_ADDRESS at 0x0000000000000001\nTermination Reason: SIGNAL 11 Segmentation fault\n\nCrashed Thread: 0 Dispatch queue: com.apple.main-thread\nCrash Function: sqlb::Table::removeKeyFromConstraint(...)\n\nThread 0 Crashed:\n0 DB Browser for SQLite sqlb::Table::removeKeyFromConstraint(...) + 1123\n1 DB Browser for SQLite EditTableDialog::fieldItemChanged(...) + 6435\n2 QtWidgets QTreeWidgetItem::setData(...) + 1323\n...\n```\n\n### Prevention against duplicate issues\n\n- [x] I have searched for similar issues","author":{"url":"https://github.com/TheKite0","@type":"Person","name":"TheKite0"},"datePublished":"2025-06-13T22:05:33Z","url":"https://github.com/sqlitebrowser/sqlitebrowser/issues/3953"}
| 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:aa952c46-f809-64b2-b621-ff533bc05687 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | CB1E:3B7815:1DDCB0:27B226:6AFD1287 |
| html-safe-nonce | f6aeed519a113b568b81e8a97ce197fa11ef12874e5c802c8f23e77c37060002 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJDQjFFOjNCNzgxNToxRERDQjA6MjdCMjI2OjZBRkQxMjg3IiwidmlzaXRvcl9pZCI6Ijc0MTU2MzE5MDAxNzUwNDUyNTUiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | b2e2368701239ea59b48981427b82a56d83d1d43dc762c46b24f2656eefce2ec |
| hovercard-subject-tag | issue:3144912812 |
| 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/3953/issue_layout |
| twitter:image | https://opengraph.githubassets.com/99cbd3d7dc4622f90bcbfb005fb462646345ff8795f7d10f08e92b5f3dcfdd72/sqlitebrowser/sqlitebrowser/issues/3953 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/99cbd3d7dc4622f90bcbfb005fb462646345ff8795f7d10f08e92b5f3dcfdd72/sqlitebrowser/sqlitebrowser/issues/3953 |
| og:image:alt | What did you do? [DB] Browser for SQLite crashes when re-enabling the AI (Auto Increment) checkbox on the first column, after setting PK (Primary Key) on the second column. In this scenario, the AI... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | TheKite0 |
| hostname | github.com |
| expected-hostname | github.com |
| None | 7c34e25df4e46e972c8f0225e63410231bdeb9ea5634597c712796bbcdb2e627 |
| 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 | 8fa571ebaa95e4e6bf872197c0e84b7dc48e6785 |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
| react-app-name | issues |
Links:
Viewport: width=device-width