killbill-uncached

util: add missing order in tag and tag definition queries Signed-off-by:

4/4/2018 6:55:45 AM

Details

diff --git a/util/src/main/resources/org/killbill/billing/util/tag/dao/TagDefinitionSqlDao.sql.stg b/util/src/main/resources/org/killbill/billing/util/tag/dao/TagDefinitionSqlDao.sql.stg
index 3b16041..1328fc6 100644
--- a/util/src/main/resources/org/killbill/billing/util/tag/dao/TagDefinitionSqlDao.sql.stg
+++ b/util/src/main/resources/org/killbill/billing/util/tag/dao/TagDefinitionSqlDao.sql.stg
@@ -67,6 +67,7 @@ from <tableName()> t
 where t.is_active
 and <idField("t.")> in (<ids>)
 <AND_CHECK_TENANT("t.")>
+<defaultOrderBy("t.")>
 ;
 >>
 
diff --git a/util/src/main/resources/org/killbill/billing/util/tag/dao/TagSqlDao.sql.stg b/util/src/main/resources/org/killbill/billing/util/tag/dao/TagSqlDao.sql.stg
index cf6ac03..7af9782 100644
--- a/util/src/main/resources/org/killbill/billing/util/tag/dao/TagSqlDao.sql.stg
+++ b/util/src/main/resources/org/killbill/billing/util/tag/dao/TagSqlDao.sql.stg
@@ -44,6 +44,7 @@ where t.is_active
 and t.object_id = :objectId
 and t.object_type = :objectType
 <AND_CHECK_TENANT("t.")>
+<defaultOrderBy("t.")>
 ;
 >>
 
@@ -55,6 +56,7 @@ where 1 = 1
 and t.object_id = :objectId
 and t.object_type = :objectType
 <AND_CHECK_TENANT("t.")>
+<defaultOrderBy("t.")>
 ;
 >>