← Back to team overview

dhis2-devs team mailing list archive

[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