------------------------------------------------------------
revno: 156
committer: Lars Helge Oeverland [email protected]
branch nick: trunk
timestamp: Sat 2009-04-04 14:17:57 +0200
message:
H2 sql grammar fix
modified:
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
=== modified file
'dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java'
---
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
2009-04-03 22:56:42 +0000
+++
dhis-2/dhis-services/dhis-service-jdbc/src/main/java/org/hisp/dhis/jdbc/statementbuilder/H2StatementBuilder.java
2009-04-04 12:17:57 +0000
@@ -258,10 +258,7 @@
{
String sql =
"DELETE FROM datavalue " +
- "USING dataelement " +
- "WHERE datavalue.dataelementid = dataelement.dataelementid " +
- "AND dataelement.aggregationtype = 'sum' " +
- "AND datavalue.value IN ( '0', '0.', '.0', '0.0', ' 0', '0 ', '0
0' )";
+ "WHERE datavalue.value IN ( '0', '0.', '.0', '0.0', ' 0', '0 ', '0
0' )";
return sql;
}
--
Trunk
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk
Your team DHIS 2 developers is subscribed to branch lp:dhis2.
To unsubscribe from this branch go to
https://code.launchpad.net/~dhis2-devs-core/dhis2/trunk/+edit-subscription.
_______________________________________________
Mailing list: https://launchpad.net/~dhis2-devs
Post to : [email protected]
Unsubscribe : https://launchpad.net/~dhis2-devs
More help : https://help.launchpad.net/ListHelp
