Eli Mesika has posted comments on this change.
Change subject: engine: cluster policy: adding description and info icons
......................................................................
Patch Set 1:
(1 comment)
....................................................
File packaging/dbscripts/upgrade/03_03_0680_add_description_to_policy_unit.sql
Line 38: WHERE id = '7db4ab05-81ab-42e8-868a-aee2df483ed2';
Line 39: -- weight function
Line 40: UPDATE policy_units
Line 41: SET description='Gives hosts with lower CPU usage, higher weight
(means that hosts with higher CPU usage are more likely to be selected)'
Line 42: WHERE id = '7db4ab05-81ab-42e8-868a-aee2df483edb';
all of those statements may be simplified and optimized by using 2 update
statements instead of all the above using the CASE format.
Example
UPDATE tbl_name SET field_name =
CASE
WHEN condition_1 THEN 'Blah'
WHEN condition_2 THEN 'Foo'
WHEN condition_x THEN 123
ELSE 'bar'
END
Line 43:
--
To view, visit http://gerrit.ovirt.org/17629
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: comment
Gerrit-Change-Id: Ib51cf7f15b7d73c87e0c728953171584216e1d00
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Gilad Chaplik <[email protected]>
Gerrit-Reviewer: Doron Fediuck <[email protected]>
Gerrit-Reviewer: Eli Mesika <[email protected]>
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
[email protected]
http://lists.ovirt.org/mailman/listinfo/engine-patches
