hankinsoft/SQLPro

Renaming or dropping a column in a table locks up SQLPro for SQLite

Closed this issue · 6 comments

GaryMeyers1 commented

This is probably going to be hard for you to reproduce but I have run PRAGMA integrity_check on my database. I tried to rename a column in a table with just 195 rows and 52 columns but SQLPro locked up. I exported the data from the table into a JSON file and then truncated the table, but the rename attempt still locked up SQLPro. I then clicked the minus sign in the upper right corner to drop the column, with the table still being empty, and SQLPro locked up. I downloaded another app from the internet to drop the column from the table. I then launched SQLPro and loaded my JSON data, mapping the deleted column to SKIP.

Expected behavior
SQLPro should have renamed the column without an error. SQLPro should have dropped the column without an error.

Screenshots
column rename
column drop

Environment details (please complete the following information):

  • Device: iMac
  • OS: 13.6.4 (22G513)
  • SQLPro for SQLite: Version 2024.10 (Build 4361)
  • Installation source: Website download
GaryMeyers1 commented

I have old versions of my database that I can delete records from, to make them small enough to email to Kyle, after confirming that the rename and drop operations also fail on those smaller files.

GaryMeyers1 commented

I emailed a sample database to Kyle that locks up when dropping a column.

hankinsoft commented

Reproduced and am working on a fix now.

hankinsoft commented

Could you try this build:

https://sqlprostudio.s3.us-east-1.amazonaws.com/sqlite/SQLProSQLite.2024.12.app.zip

And let me know if that helps out?

GaryMeyers1 commented
hankinsoft commented

Great, thanks for letting me know!