The Daily WTF

CodeSOD: Looks Guid to Me

An anonymous user discovered an oddity in an enterprise software database table: the MODULES table had both MD_ID and MD_GUID fields. While it's typically ideal for each GUID to be unique, the Releases module lacked a GUID. This inconsistency raised questions about the reason behind this deviation and the improper storage of GUIDs as strings. The data suggested that users were providing minimal additional information in the description field, making it less clear in some cases. The absence of a GUID for the Releases module left users puzzled as to why it was special and why unique identifiers were not treated consistently. Despite the lack of an apparent logical reason, the inconsistency highlighted the importance of adhering to data integrity practices and ensuring the proper storage and handling of unique identifiers.
favicon
thedailywtf.com
thedailywtf.com
Create attached notes ...