dhis2-devs team mailing list archive
-
dhis2-devs team
-
Mailing list archive
-
Message #25686
[Bug 1240130] Re: Resource tables prone to failure due to case sensitivity
Seems this is already fixed in 2.13.
** Changed in: dhis2
Status: Confirmed => Fix Committed
** Changed in: dhis2
Assignee: (unassigned) => Lars Helge Øverland (larshelge)
--
You received this bug notification because you are a member of DHIS 2
developers, which is subscribed to DHIS.
https://bugs.launchpad.net/bugs/1240130
Title:
Resource tables prone to failure due to case sensitivity
Status in DHIS 2:
Fix Committed
Bug description:
In the resource tables which use object names as column names, there
is a vulnerability in the sense that some databases, like Postgres,
are case-sensitive when it comes to field uniqueness constraints, but
case-insensitive when it comes to column name. So, as an example, you
could have two categories in the system "Age" and "AGE", which will
cause an error when trying to generate the category resource table
with two identical "age" columns.
To manage notifications about this bug go to:
https://bugs.launchpad.net/dhis2/+bug/1240130/+subscriptions
References