dhis2-devs team mailing list archive

[Lars Helge Øverland <larshelge@xxxxxxxxx>]

Public bug reported:

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.

** Affects: dhis2
     Importance: High
         Status: Confirmed

** Changed in: dhis2
    Milestone: None => 2.13

** Changed in: dhis2
       Status: New => Confirmed

** Changed in: dhis2
   Importance: Undecided => High

-- 
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:
  Confirmed

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