killbill-uncached

junction: fix typo in sql statements Order events in asc order,

8/27/2012 3:34:02 PM

Details

diff --git a/junction/src/main/resources/com/ning/billing/junction/dao/BlockingStateSqlDao.sql.stg b/junction/src/main/resources/com/ning/billing/junction/dao/BlockingStateSqlDao.sql.stg
index 78e62d6..2558208 100644
--- a/junction/src/main/resources/com/ning/billing/junction/dao/BlockingStateSqlDao.sql.stg
+++ b/junction/src/main/resources/com/ning/billing/junction/dao/BlockingStateSqlDao.sql.stg
@@ -12,7 +12,7 @@ getBlockingStateFor() ::= <<
       , created_date   
     from blocking_states
     where id = :id
-    order by created_date desc, record_id desc
+    order by created_date asc, record_id asc
     limit 1
     ;
 >>
@@ -29,7 +29,7 @@ getBlockingHistoryFor() ::= <<
       , created_date   
     from blocking_states
     where id = :id 
-    order by created_date desc, record_id desc
+    order by created_date asc, record_id asc
     ;
 >>