-
Notifications
You must be signed in to change notification settings - Fork 690
Closed
Description
I've a table:
CREATE TABLE BOM(name JSON, UNIQUE(name->test))
it dosen't work.
If we try:
CREATE TABLE BOM(name JSON, UNIQUE(name.test))
it work, but after first "insert" it always says constraint violation, unrelated to inserted object.
If we do:
CREATE UNIQUE INDEX xx on BOM(name->test)
it work too, but uniqueness is not checked at all.
In general, it seems, I can't use any functions inside UNIQUE constraint.
Maybe related #406
Copilot