#622  Unique constraint error on SQL server
Released
Robin Shen opened 2 years ago

It seems that there is a problem with database field o_Project.o_serviceDeskName (in case of using MSSQL as DBMS). The problem is in unique constraint: as you may know in MSSQL NULL is treated as distinct value and having two projects with o_serviceDeskName = NULL lead to constraint violation. Also there is no means to enter this value in UI. The workarounds are to setup this value straight inside database or change (remove) this unique constraint. I know that in other databases unique constraints allow to have multiple NULL values (Oracle, MySQL,...) and I believe that this is logical and correct behavior. But sadly we are forced to use MSSQL for now...

Robin Shen changed fields 2 years ago
Name Previous Value Current Value
Priority
Normal
Major
OneDev changed state to 'Closed' 2 years ago
Previous Value Current Value
Open
Closed
OneDev commented 2 years ago

State changed as code fixing the issue is committed

OneDev changed state to 'Released' 2 years ago
Previous Value Current Value
Closed
Released
OneDev commented 2 years ago

State changed as build #2369 is successful

issue 1 of 1
Type
Bug
Priority
Major
Assignee
Affected Versions
Not Found
Issue Votes (1)
Watchers (4)
Reference
onedev/server#622
Please wait...
Page is in error, reload to recover