diff options
Diffstat (limited to 'schema')
| -rw-r--r-- | schema/changelog-3.7.xml | 2 |
1 files changed, 1 insertions, 1 deletions
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"> |