search

brittneybrinsfield / sequel-pro

Automatically exported from code.google.com/p/sequel-pro
Other
0 stars 0 forks source link

Add Field To existing table with default value crashes program #1773

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.Add a new field to existing table with existing data in all fields and setup 
a default value from structure tab
2.Click content tab and program freezes
3.Force quit, restart.  Data is there but causes a freeze.  It has done this 
consistently since I updated to this version of Sequel Pro

What is the expected output?
All data including newly added field with the default value
What do you see instead?
Program freezes.  Upon restart of program the correct data is there

What version of Sequel Pro are you using?
1.0.2 Build 4096
What version of OS X are you using?
10.8.4
What version of MySQL are you connecting to on the server?
5.5.32-log

Please provide any additional information below.
This used to work until I upgraded.  I have only done this adding a new INT 
field with a default value of 0.

Original issue reported on code.google.com by holletts...@gmail.com on 6 Aug 2013 at 3:26

GoogleCodeExporter commented 9 years ago 
ALTER Table operations in Sequel Pro are currently not threaded.
This means SP will freeze until the operation is completed (which can take some 
time on large tables).

Original comment by schlabbe...@gmail.com on 6 Aug 2013 at 9:44

GoogleCodeExporter commented 9 years ago

Original comment by stuart02 on 21 Oct 2013 at 6:10