MySQL Bugs: #109043: Last Row Disappears on Apply/Finish

Bug #109043	Last Row Disappears on Apply/Finish
Submitted:	9 Nov 2022 16:49	Modified:	14 Nov 2022 14:44
Reporter:	Steven Cinquegrana	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	8.0.31	OS:	Windows (Microsoft Windows 10 Pro)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
After making a change to a row value, when I click Apply then Finish, immediately the last data row and the new row below it disappear. This has been happening for MANY versions. It's been reported but hasn't been addressed.

I'm remotely connecting to a HostGator MySQL back-end. When I do this on a locally hosted DB it doesn't happen. So it appears to have some relation to either remote hosting or HostGator itself. Dunno.

How to repeat:
1. Open a table on the HostGator MySQL back-end.
2. Make a change to a row value.
3. Click Apply, then Finish.

The last data row and the new row below it disappear.

Suggested fix:
Investigate, reproduce, fix?

Hello Steven Cinquegrana,

Thank you for the bug report.
Could you please provide screenshot of the issue along with the table structure to reproduce this issue at our end?

Regards,
Ashwini Patil

I've added two screen shots showing the problem before and after.

And also the create statement for a table residing on HostGator displaying the problem is below.

PS Why can't I click "Add Comment"? It takes me to "Edit Submission".

CREATE TABLE `product_version` (
  `Id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'The PK row Id.',
  `ProductId` int(11) NOT NULL COMMENT 'FK to the product table.',
  `Version` varchar(10) CHARACTER SET utf8mb4 NOT NULL DEFAULT 'Admin' COMMENT 'The product version.',
  `ModifyDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The date and time the data was last modified.',
  `ModifyUser` varchar(50) CHARACTER SET utf8mb4 NOT NULL DEFAULT 'Admin' COMMENT 'The user who last modified the data.',
  `Comment` varchar(1000) CHARACTER SET utf8mb4 DEFAULT NULL COMMENT 'Any comments about the row data.',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Id_UNIQUE` (`Id`),
  KEY `FL_product-product_version_idx` (`ProductId`),
  CONSTRAINT `FL_product-product_version` FOREIGN KEY (`ProductId`) REFERENCES `product` (`Id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='The table of product versions.';

MySQL Problem Before.

Attachment: MySQL Problem 1.png (image/png, text), 25.36 KiB.

MySQL Problem After.

Attachment: MySQL Problem 2.png (image/png, text), 23.28 KiB.

Hello Steven Cinquegrana,

Thank you for the details.
Could you please provide table structure for "product" along with insert statement?

Regards,
Ashwini Patil

Product table create:

CREATE TABLE `product` (
  `Id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'The PK row Id.',
  `Code` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Product code.',
  `Name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the product.',
  `Description` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Description of the product.',
  `IsTaxable` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'A flag indicating whether the product has tax applied. Default=false.',
  `IsActive` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'A flag indicating whether the product is active. Default=true.',
  `Sequence` int(4) NOT NULL COMMENT 'Sorting sequence if required.',
  `DownloadUri` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The relative URI from which to download the application installer.',
  `ModifyDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'The date and time the data was last modified.',
  `ModifyUser` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Admin' COMMENT 'The user who last modified the data.',
  `Comment` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Any comments about the row data.',
  PRIMARY KEY (`Id`),
  UNIQUE KEY `Id_UNIQUE` (`Id`),
  UNIQUE KEY `ProductCode_UNIQUE` (`Code`),
  KEY `FK1_idx` (`Sequence`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='The table of products and services.';

Hello Steven Cinquegrana,

Thank you for the details.
I tried to reproduce your issue on windows 10 with workbench 8.0.31 using tables provided but I am not seeing any issues at my end.

Regards,
Ashwini Patil

8.0.31 test results

Attachment: 109043_test_results.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, text), 140.59 KiB.

You did see my comment regarding NOT seeing the issue on a local server, right? I ONLY see this when working with a hosted DB, in my case HostGator.