Updated Branches: refs/heads/master 3aa469da2 -> 0d7601d2d
Add a limit statement to the subquery Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/0d7601d2 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/0d7601d2 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/0d7601d2 Branch: refs/heads/master Commit: 0d7601d2d76f403d245214e33bd11b080806af27 Parents: 3aa469d Author: Hugo Trippaers <[email protected]> Authored: Mon Aug 27 09:14:38 2012 +0200 Committer: Hugo Trippaers <[email protected]> Committed: Mon Aug 27 09:14:38 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/0d7601d2/setup/db/db/schema-302to40.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-302to40.sql b/setup/db/db/schema-302to40.sql index 2b47969..aaf23e6 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;
