vipshop#470 修复作业配置 groups 为null时，导致显示不出来的问题

leewcc · leewcc · commit 643890d01e0c · 2018-08-06T10:22:12.000+08:00
diff --git a/saturn-console-api/src/main/resources/mapper/CurrentJobConfigMapper.xml b/saturn-console-api/src/main/resources/mapper/CurrentJobConfigMapper.xml
@@ -67,7 +67,12 @@
     <where>
       namespace = #{namespace,jdbcType=VARCHAR}
       <if test="condition.groups != null">
-        and groups = #{condition.groups}
+        and (
+        groups = #{condition.groups}
+        <if test="condition.groups == ''">
+          or groups is NULL
+        </if>
+        )
       </if>
       <if test="condition.isEnabled != null">
         and is_enabled = #{condition.isEnabled}
@@ -99,7 +104,12 @@
     <where>
       namespace = #{namespace,jdbcType=VARCHAR}
       <if test="condition.groups != null">
-        and groups = #{condition.groups}
+        and (
+        groups = #{condition.groups}
+        <if test="condition.groups == ''">
+          or groups is NULL
+        </if>
+        )
       </if>
       <if test="condition.isEnabled != null">
         and is_enabled = #{condition.isEnabled}
