data-merge-not-working-mysql

Bug #620934 reported by Lars Helge Øverland on 2010-08-20
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
DHIS
Undecided
Quang Nguyen

Bug Description

Duplicate data elimination and organisation unit merge (in data admin module) don't work in MySql. This is because MySQL doesn’t allow referring to a table that’s targeted for update in a FROM clause.

Changed in dhis2:
milestone: none → 2.0.6

Since the SQL syntax is different in mysql and postgres we need to move these to the StatementManager. See dhis-support-jdbc - org.hisp.dhis.jdbc.statementbuilder package / implementations.

Changed in dhis2:
assignee: nobody → Quang Nguyen (quangnguyen)
milestone: 2.0.6 → 2.0.5
Changed in dhis2:
status: New → Fix Committed
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers