git commit: Backport from master

[hu...@apache.org]

Updated Branches:
  refs/heads/4.0 3f1f366c9 -> b04ac1d3b


Backport from master

Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/b04ac1d3
Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/b04ac1d3
Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/b04ac1d3

Branch: refs/heads/4.0
Commit: b04ac1d3bbbd74aed17cf1114942f5a6ff8e792e
Parents: 3f1f366
Author: Hugo Trippaers <ht...@schubergphilis.com>
Authored: Mon Aug 27 09:24:12 2012 +0200
Committer: Hugo Trippaers <ht...@schubergphilis.com>
Committed: Mon Aug 27 09:24:12 2012 +0200

----------------------------------------------------------------------
 setup/db/db/schema-302to40.sql |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/b04ac1d3/setup/db/db/schema-302to40.sql
----------------------------------------------------------------------
diff --git a/setup/db/db/schema-302to40.sql b/setup/db/db/schema-302to40.sql
index 4ba6344..977505e 100644
--- a/setup/db/db/schema-302to40.sql
+++ b/setup/db/db/schema-302to40.sql
@@ -237,7 +237,7 @@ ALTER TABLE physical_network_service_providers DROP FOREIGN KEY fk_pnetwork_serv
 SET @constraintname = (select CONCAT(CONCAT('DROP INDEX ', A.CONSTRAINT_NAME), ' ON physical_network_service_providers' )
 from information_schema.key_column_usage A
 JOIN information_schema.key_column_usage B ON B.table_name = 'physical_network_service_providers' AND B.COLUMN_NAME = 'provider_name' AND A.COLUMN_NAME ='physical_network_id' AND B.CONSTRAINT_NAME=A.CONSTRAINT_NAME
-where A.table_name = 'physical_network_service_providers');
+where A.table_name = 'physical_network_service_providers' LIMIT 1);
 
 PREPARE stmt1 FROM @constraintname; 
 EXECUTE stmt1;