[
https://issues.apache.org/jira/browse/CLOUDSTACK-9914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16138946#comment-16138946
]
ASF subversion and git services commented on CLOUDSTACK-9914:
-------------------------------------------------------------
Commit 57255ac72c99ee667a4d0ce765d67acbe4cc25ac in cloudstack's branch
refs/heads/master from [~brascher]
[ https://gitbox.apache.org/repos/asf?p=cloudstack.git;h=57255ac ]
CLOUDSTACK-9914: Update Quota plugin to support currency values up to 5 decimal
places (#2123)
Summary: this commit alters column currency_value from table
cloud_usage.quota_tariff to support values up to 5 decimal places. The
current implementation allows up to 2 decimal places.
Issue: need to use more than 2 decimal places to define resources values
in Quota tariff.
Solution: modify column currency_value from table
cloud_usage.quota_tariff to support values up to 5 decimal places.
Values with more than 5 decimal places will be displayed with scientific
notation in the user interface.
SQL command: "ALTER TABLE cloud_usage.quota_tariff MODIFY currency_value
DECIMAL(15,5) not null"
> Alter quota_tariff to support currency values up to 5 decimal places
> --------------------------------------------------------------------
>
> Key: CLOUDSTACK-9914
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9914
> Project: CloudStack
> Issue Type: Improvement
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: Install and Setup
> Affects Versions: 4.9.0, 4.9.2.0, 4.9.1.0, 4.9.0.1, 4.9.3.0
> Reporter: Gabriel Beims Bräscher
> Assignee: Gabriel Beims Bräscher
> Priority: Trivial
> Fix For: 4.10.1.0
>
>
> Issue: the current quota plugin does not allow configuring currency values
> with more than two decimal places. For instance, I would like to configure
> $0.0125 for using 1 CPU of clock rate 100MHz and $0.00599 for the network
> usage (Bytes Sent).
> Solution: modify column currency_value from table cloud_usage.quota_tariff to
> support values up to 5 decimal places. Values with more than 5 decimal places
> will be displayed with scientific notation in the user interface.
> SQL command: "ALTER TABLE cloud_usage.quota_tariff MODIFY currency_value
> DECIMAL(15,5) not null"
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
