[icinga-checkins] icinga.org: icinga-api/master: * ...and again, missed some 'AS' keywords

git at icinga.org git at icinga.org
Wed Sep 29 16:45:47 CEST 2010


Module: icinga-api
Branch: master
Commit: 89a8e016b9975051a7f1537b265813d57d218d7e
URL:    https://git.icinga.org/?p=icinga-api.git;a=commit;h=89a8e016b9975051a7f1537b265813d57d218d7e

Author: jmosshammer <jannis.mosshammer at netways.com>
Date:   Wed Sep 29 16:45:29 2010 +0200

* ...and again, missed some 'AS' keywords

---

 .../data_interfaces/IcingaApiSearchIdoPgsql.php    |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)

diff --git a/objects/search/data_interfaces/IcingaApiSearchIdoPgsql.php b/objects/search/data_interfaces/IcingaApiSearchIdoPgsql.php
index cf416f4..c1fcb28 100644
--- a/objects/search/data_interfaces/IcingaApiSearchIdoPgsql.php
+++ b/objects/search/data_interfaces/IcingaApiSearchIdoPgsql.php
@@ -187,7 +187,7 @@ class IcingaApiSearchIdoPgsql
 			${LIMIT}',
 		self::TARGET_HOST_STATUS_SUMMARY => 
 			'select
-				${FIELDS:hs.current_state HOST_STATE, count(hs.current_state) COUNT}
+				${FIELDS:hs.current_state AS HOST_STATE, count(hs.current_state) AS COUNT}
 			from
 				${TABLE_PREFIX}hoststatus AS hs
 			${if_table:oh:inner join ${TABLE_PREFIX}objects AS oh on oh.object_id = hs.host_object_id}
@@ -210,7 +210,7 @@ class IcingaApiSearchIdoPgsql
 			${LIMIT}',
 		self::TARGET_SERVICE_STATUS_SUMMARY =>
 			'select
-				${FIELDS:ss.current_state SERVICE_STATE, count(ss.current_state) COUNT}
+				${FIELDS:ss.current_state AS SERVICE_STATE, count(ss.current_state) AS COUNT}
 			from
 				${TABLE_PREFIX}servicestatus AS ss
 			${if_table:os:inner join ${TABLE_PREFIX}objects AS os on os.object_id = ss.service_object_id}





More information about the icinga-checkins mailing list