Retool DB: UUID type is no longer nullable

It seems the UUID field type in retool db is no longer nullable. Or has ANY settings at all for that matter.

image

Even worse: as default value it sets a RANDOM UUID, so we can no longer distinguish which ones are set by us. None of these were set by us, but appeared after a migration of a new UUID column:

Screenshot 2025-02-28 at 16.52.55

We have older tables with UUID fields that are nullable:

I cant find any documentation about this or anything in the changelogs that this changed.

Pretty frustrating, since this is currently a showstopper for us.

Is that intended behaviour (and why) or a bug?

Hi @perelin,
This must be super frustrating for you. I am currently checking with our engineering team to see if this is intended behavior.

I want to confirm, however, that you are on retool cloud?

Thanks.

@perelin,
Are you using the UUID field as your primary key?