[jira] [Created] (CLOUDSTACK-1229) Incorrect SQL syntax to insert api limit related configuration items in upgrade path script

["Min Chen (JIRA)" <ji...@apache.org>]

Min Chen created CLOUDSTACK-1229:
------------------------------------

             Summary: Incorrect SQL syntax to insert api limit related configuration items in upgrade path script
                 Key: CLOUDSTACK-1229
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-1229
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
          Components: Install and Setup
    Affects Versions: 4.1.0
            Reporter: Min Chen
             Fix For: 4.1.0


In schema-40to410.sql, extra quotes are in the following insert statement around configuration name:

INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', '"detail.batch.query.size"', '2000', 'Default entity detail batch query size for listing');
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', '"api.throttling.interval"', '1', 'Time interval (in seconds) to reset API count');
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', '"api.throttling.max"', '25', 'Max allowed number of APIs within fixed interval');
INSERT IGNORE INTO `cloud`.`configuration` VALUES ('Advanced', 'DEFAULT', 'management-server', '"api.throttling.cachesize"', '50000', 'Account based API count cache size');


--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira