From 9cc862ea2c3fed6eb69dea8e6f8a646fc7995dbe Mon Sep 17 00:00:00 2001
From: Abyss777 <abyss@fox5.ru>
Date: Wed, 21 Sep 2016 12:32:44 +0500
Subject: Fix groups cleanup request on some MySQL 5.7.x installations

---
 schema/changelog-3.7.xml | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'schema')

diff --git a/schema/changelog-3.7.xml b/schema/changelog-3.7.xml
index d82dbe91b..1bae2aaff 100644
--- a/schema/changelog-3.7.xml
+++ b/schema/changelog-3.7.xml
@@ -17,7 +17,7 @@
 
     <update tableName="groups">
       <column name="groupid"/>
-      <where>groupid NOT IN (SELECT id FROM (SELECT id FROM groups) AS groups_ids)</where>
+      <where>groupid NOT IN (SELECT id FROM (SELECT DISTINCT id FROM groups) AS groups_ids)</where>
     </update>
 
     <addColumn tableName="devices">
-- 
cgit v1.2.3