Resource tables prone to failure due to case sensitivity

Bug #1240130 reported by Lars Helge Øverland on 2013-10-15
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
DHIS
High
Lars Helge Øverland

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.

Changed in dhis2:
milestone: none → 2.13
status: New → Confirmed
importance: Undecided → High

Seems this is already fixed in 2.13.

Changed in dhis2:
status: Confirmed → Fix Committed
assignee: nobody → Lars Helge Øverland (larshelge)
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers