[GH-ISSUE #126] Binary UUIDs Result in Empty Fields #92

New issue

Closed

opened 2026-02-25 21:33:14 +03:00 by kerem · 1 comment

kerem commented

2026-02-25 21:33:14 +03:00

Owner

Originally created by @arminlinzbauer on GitHub (Dec 15, 2021).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/126

When trying to diff two databases with BINARY data (in my case UUIDs), the resulting diff contains empty strings instead of the UUIDs - this effectively means SQL code like this, for example: a merge table:

INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');
INSERT INTO `mytable` VALUES('','','');

Originally created by @arminlinzbauer on GitHub (Dec 15, 2021). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/126 When trying to diff two databases with BINARY data (in my case UUIDs), the resulting diff contains empty strings instead of the UUIDs - this effectively means SQL code like this, for example: a merge table: ```sql INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); INSERT INTO `mytable` VALUES('','',''); ```