From 65b0f9c5398ddcb28018cb1963108534c638b1f4 Mon Sep 17 00:00:00 2001
From: Anton Tananaev <anton@traccar.org>
Date: Fri, 3 Jun 2022 16:32:02 -0700
Subject: Fix another permission issue

---
 src/main/java/org/traccar/storage/DatabaseStorage.java | 5 ++++-
 1 file changed, 4 insertions(+), 1 deletion(-)

(limited to 'src/main/java/org/traccar/storage')

diff --git a/src/main/java/org/traccar/storage/DatabaseStorage.java b/src/main/java/org/traccar/storage/DatabaseStorage.java
index 2b9172153..e4e4f3294 100644
--- a/src/main/java/org/traccar/storage/DatabaseStorage.java
+++ b/src/main/java/org/traccar/storage/DatabaseStorage.java
@@ -324,7 +324,10 @@ public class DatabaseStorage extends Storage {
             result.append(" UNION ");
 
             result.append("SELECT DISTINCT ");
-            result.append(groupStorageName).append('.').append(outputKey);
+            if (!expandDevices) {
+                result.append(groupStorageName).append('.');
+            }
+            result.append(outputKey);
             result.append(" FROM ");
             result.append(groupStorageName);
 
-- 
cgit v1.2.3