Changeset 9c824156bbb942b0da737b077c77025f0b56c67d for sql

Timestamp:

05/09/08 20:53:07 (5 years ago)

Author:

Denish Patel <denish@omniti.com>

git-committer:

Denish Patel <denish@omniti.com> 1210366387 +0000

git-parent:

[3b5d1e9688429ed8e55ebcc0a750dda9a2fe54b4]

git-author:

Denish Patel <denish@omniti.com> 1210366387 +0000

Message:

fix 20 minutes rollup function.

Files:

• sql/schema.sql (modified) (1 diff)

sql/schema.sql

@@ -404 +404 @@
-                       MIN(min_value) as min_value ,MAX(max_value) as max_value
-                       FROM stratcon.rollup_matrix_numeric_5m
-ROLLUP_TIME<= v_min_whence AND WHENCE
+rollup_time<= v_min_whence AND rollup_time
-                GROUP BY rollup_time,sid,name
-