Changeset 29835 for branches/eam_branches/ipp-20101103/ippTools/share/magictool_definebyquery_select.sql

Timestamp:

Nov 26, 2010, 10:33:51 AM (16 years ago)

Author:

eugene

Message:

merge updates from trunk

Location:

branches/eam_branches/ipp-20101103/ippTools

Files:

• . (modified) (1 prop)
• share/magictool_definebyquery_select.sql (modified) (1 diff)

branches/eam_branches/ipp-20101103/ippTools/share/magictool_definebyquery_select.sql

@@ -4 +4 @@
     MAX(diffWarps.diff_id) AS diff_id,
     -- The following trick pulls out the 'inverse' value for the maximum diff_id
-    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(diffWarps.inverse ORDER BY diffWarps.diff_id), ',', 1), UNSIGNED) AS inverse,
+    CONVERT(SUBSTRING_INDEX(GROUP_CONCAT(diffWarps.inverse ORDER BY diffWarps.diff_id DESC), ',', 1), UNSIGNED) AS inverse,
     diff_data_group
 FROM (