Menu
▾
▴
[Rhq-commits] [rhq-project.org rhq] [2841] RHQ-1383 Only include data when it is 'severe' enough.
|
From: <hr...@rh...> - 2009-01-30 09:09:06
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head><style type="text/css"><!-- #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } #msg DL { border : 1px #006 solid; background-color : #369; padding : 6px; color : #fff; } #msg DT { float : left; width : 6em; font-weight : bold; } #msg DL, #msg DT, #msg UL, #msg LI { font-family : arial,helvetica,sans-serif; font-size : 10pt; } h3 { font-family : arial,helvetica,sans-serif; font-size : 10pt; font-weight : bold; } #msg PRE { overflow : auto; white-space : normal; background-color : #ffc; border : 1px #fc0 solid; padding : 6px; } #msg UL, PRE, .diff { overflow : auto; } #patch h4 { font-family : arial,helvetica,sans-serif; font-size : 10pt; } #patch h4 { padding: 8px; background : #369; color : #fff; margin : 0; } #patch .propset h4, #patch .binary h4 {margin: 0;} #patch pre {padding:0;line-height:1.2em;margin:0;} #patch .diff {background:#eeeeee;padding: 0 0 10px 0;} #patch .propset .diff, #patch .binary .diff {padding: 10px 0;} #patch span {display:block;padding:0 10px;} #patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;} #patch .add {background:#ddffdd;} #patch .rem {background:#ffdddd;} #patch .lines, .info {color:#888888;background:#ffffff;} .diff { width : 100%; } --></style> <title>[rhq-project.org rhq] [2841] RHQ-1383 Only include data when it is 'severe' enough.</title> </head> <body> <div id="msg"> <dl> <dt>Revision</dt> <dd>2841</dd> <dt>Author</dt> <dd>hrupp</dd> <dt>Date</dt> <dd>2009-01-30 03:09:04 -0600 (Fri, 30 Jan 2009)</dd> </dl> <h3>Log Message</h3> <pre>RHQ-1383 Only include data when it is 'severe' enough.</pre> <h3>Modified Paths</h3> <ul> <li><a href="#rhqtrunkmodulescoredomainsrcmainjavaorgrhqcoredomainmeasurementMeasurementOOBjava">rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/measurement/MeasurementOOB.java</a></li> </ul> </div> <div id="patch"> <h3>Diff</h3> <a id="rhqtrunkmodulescoredomainsrcmainjavaorgrhqcoredomainmeasurementMeasurementOOBjava"></a> <div class="modfile"><h4>Modified: rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/measurement/MeasurementOOB.java (2840 => 2841)</h4> <pre class="diff"> <span class="info">--- rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/measurement/MeasurementOOB.java 2009-01-30 05:25:20 UTC (rev 2840) +++ rhq/trunk/modules/core/domain/src/main/java/org/rhq/core/domain/measurement/MeasurementOOB.java 2009-01-30 09:09:04 UTC (rev 2841) </span><span class="lines">@@ -124,7 +124,8 @@ </span><span class="cx"> " AND def.numeric_type = 0\n" + " group by d.schedule_id \n" + " ) data\n" + </span><span class="rem">- " group by id\n" + </span><span class="add">+ " group by id, mx\n" + + " having mx > 0.01 " + </span><span class="cx"> ")"; public static final String INSERT_QUERY_ORACLE = "insert into rhq_measurement_oob (oob_factor, schedule_id, time_stamp ) \n" + </span><span class="lines">@@ -157,7 +158,8 @@ </span><span class="cx"> " AND def.numeric_type = 0\n" + " GROUP BY d.schedule_id \n" + ")\n" + </span><span class="rem">- "GROUP BY id\n" + </span><span class="add">+ "GROUP BY id, mx\n" + + "HAVING mx > 0.01" + </span><span class="cx"> ") "; private static final long serialVersionUID = 1L; </span> </pre> </div> </div> </body> </html> |
