GeezerVisonThe World Wide Web, restored to 800 pixels of glory. |
| Home|About|Gaming cabinet|Archives|How it works|Starter sites |
GeezerVison is showing github.com — Heidisql crashes when trying to change the foreign key parameters · Issue #2663 · HeidiSQL/HeidiSQL Open Labels bugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLlinuxAffects Linux version (not Wine)Affects Linux version (not Wine) DescriptionDescriptionWhen I open any database, go to a table with foreign keys and try to change ON DELETE or ON UPDATE part of the foreign key, for example changing it from CASCADE to SET NULL one or more times without clicking the save button the application crashes. HeidiSQL version and OSDeidisql version: 12.22.1.841, OS: Fedora Linux 44 ( KDE plasma Desktop Edition) Database server versionMysql 8.0.46 and also Mysql 9.7.2 Reproduction recipeIn the example below I opened a table that had 2 foreign keys. As you can see both foreign keys have their ON UPDATE and ON DELETE actions set to CASCADE 
I clicked on the the dropdowns for ON UPDATE and ON DELETE and selected SET NULL 
The app crashed. Sometimes this happens when I just try to select the ON UPDATE or ON DELETE dropdown values but in this case it crashed after I selected both.
It happened for both versions of Mysql 8.0.46 and Mysql 9.7.2 Error/BacktraceActivity
MetadataMetadataAssigneesLabelsbugDefective behaviour in HeidiSQLDefective behaviour in HeidiSQLlinuxAffects Linux version (not Wine)Affects Linux version (not Wine) TypeProjectsMilestoneRelationshipsDevelopmentIssue actions |
| You are visitor 01402503 — GeezerVison does not store the pages you look up. Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required. |