> i did some simple tests using text data type. > > it works with the primary key, not with unique indexes. > it does not work when the column is unique, not null. > > The following is my test.
Can you simplify your test case please? I can't undertand what "doesn't work" mean here and for which case. FWIW, this feature has nothing with the real data, I don't think inserting any data is helpful unless I missed anything. -- Best Regards Andy Fan