Menu

#1732 Default UUID values corrupt script file

current-release
open-fixed
None
5
2025-05-30
2025-04-16
No

When you create a UUID column with a default value, then the default value is written to the script file without quotes, corrupting the file.

For example:

CREATE TABLE example (id UUID DEFAULT '69dab71b-12b2-11e8-bfe3-41154f2b6534');
COMMIT;
CHECKPOINT;

This results in the following in the script file:

CREATE MEMORY TABLE PUBLIC.EXAMPLE(ID UUID DEFAULT 69dab71b-12b2-11e8-bfe3-41154f2b6534)

And errors when you attempt to open the database again. Manually adding quotes to the value in the script file allows you to open the file, but it's corrupted again next time CHECKPOINT runs.

Discussion

  • Fred Toussi

    Fred Toussi - 2025-05-30
    • status: open --> open-fixed
    • assigned_to: Fred Toussi
     
  • Fred Toussi

    Fred Toussi - 2025-05-30

    Thanks for reporting. Fixed and committed to SVN for the next release.

     

Log in to post a comment.

MongoDB Logo MongoDB