[icinga-checkins] icinga.org: icinga-web/next: SELECT DISTINCT on CLOBs breaks Oracle support

git at icinga.org git at icinga.org
Mon Apr 15 15:15:49 CEST 2013


Module: icinga-web
Branch: next
Commit: f0a306ab6d5d9cb99b6307c294a3ac9eb65dbb66
URL:    https://git.icinga.org/?p=icinga-web.git;a=commit;h=f0a306ab6d5d9cb99b6307c294a3ac9eb65dbb66

Author: Marius Hein <marius.hein at netways.de>
Date:   Mon Apr 15 13:56:41 2013 +0200

SELECT DISTINCT on CLOBs breaks Oracle support

Remove distinct from api views. This is made now with PHP on
application server side.

fixes #3965

---

 app/modules/Api/config/views/histories.xml |    2 +-
 app/modules/Api/config/views/host.xml      |    4 ++--
 app/modules/Api/config/views/service.xml   |    2 +-
 3 files changed, 4 insertions(+), 4 deletions(-)

diff --git a/app/modules/Api/config/views/histories.xml b/app/modules/Api/config/views/histories.xml
index 703f9c1..acdee2b 100644
--- a/app/modules/Api/config/views/histories.xml
+++ b/app/modules/Api/config/views/histories.xml
@@ -6,7 +6,7 @@
         <dql name="TARGET_HOST_STATUS_HISTORY" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT
                 h.icon_image AS HOST_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 hsh.statehistory_id AS STATEHISTORY_ID,
diff --git a/app/modules/Api/config/views/host.xml b/app/modules/Api/config/views/host.xml
index 6040cd0..4fa4ed5 100644
--- a/app/modules/Api/config/views/host.xml
+++ b/app/modules/Api/config/views/host.xml
@@ -6,7 +6,7 @@
         <dql name="TARGET_HOST" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT
                 h.icon_image AS HOST_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,
@@ -162,7 +162,7 @@
          <dql base="TARGET_HOST" name="TARGET_HOST_OPEN_PROBLEMS" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT
                    h.icon_image AS SERVICE_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,
diff --git a/app/modules/Api/config/views/service.xml b/app/modules/Api/config/views/service.xml
index a128353..868a6c2 100644
--- a/app/modules/Api/config/views/service.xml
+++ b/app/modules/Api/config/views/service.xml
@@ -6,7 +6,7 @@
         <dql name="TARGET_SERVICE" >
             <query>
             <![CDATA[
-            SELECT DISTINCT
+            SELECT
                 s.icon_image AS SERVICE_ICON_IMAGE,
                 i.instance_name AS INSTANCE_NAME,
                 h.host_object_id AS HOST_OBJECT_ID,





More information about the icinga-checkins mailing list