soerepro: par_a_code must be unique
Bug #1009503 reported by
Olivier Maury
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Datum |
New
|
Critical
|
amd |
Bug Description
The file template and the integration at soerepro/
This will block the integration of values for such parameters.
To find them, use this SQL query:
SELECT par_a_code, COUNT(*) AS cpt
FROM parametre
GROUP BY par_a_code
HAVING COUNT(*) > 1
ORDER BY par_a_code;
When these few codes will be replaced, a UNIQUE constraint must be added.
To post a comment you must log in.