Subversion Repositories DevTools

Rev

Rev 6268 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 6268 Rev 6615
Line 134... Line 134...
134 
 
 134 
 
135 
       /* UPDATED Packages */
 135 
       /* UPDATED Packages */
136 
       SELECT ( CASE
 136 
       SELECT ( CASE
137 
                  WHEN ra.V_NMM = rb.V_NMM AND ra.patch_number = rb.patch_number AND ra.build_number != rb.build_number THEN
 137 
                  WHEN ra.V_NMM = rb.V_NMM AND ra.patch_number = rb.patch_number AND ra.build_number != rb.build_number THEN
138 
                    'UR'
 138 
                    'UR'
139 
                  WHEN ra.V_NMM = rb.V_NMM AND TO_NUMBER(ra.patch_number) < TO_NUMBER(rb.patch_number) THEN
 139 
                        WHEN ra.V_NMM = rb.V_NMM AND COALESCE(TO_NUMBER(REGEXP_SUBSTR(ra.patch_number, '^\d+(\.\d+)?')), 0) < COALESCE(TO_NUMBER(REGEXP_SUBSTR(rb.patch_number, '^\d+(\.\d+)?')), 0) THEN
140 
                    'UW'
 140 
                    'UW'
141 
                  ELSE
 141 
                  ELSE
142 
                    'U'
 142 
                    'U'
143 
                END
 143 
                END
144 
              ) AS CHANGE_TYPE,
 144 
              ) AS CHANGE_TYPE,