I have a table with UUID as primary key. When inserting an entry with all lowercase UUID, it works fine, e.g.
insert into “my_table” (id) values (‘1eb41c3c-6100-44fc-abcb-67fcfc378191a’);
But when inserting with upper case letters in the UUID, it is converted into lower case automatically. e.g.
insert into “my_table” (id) values (‘1eb41c3c-6100-44fc-abcb-67fcfc378191A’);
it will cause a duplicated key error.
But the UUID with upper cases are still valid uuid. My question is: is there a flag to set in the cockroachdb, so that UUID can be case sensitive?