Changeset 29831 for trunk/ippTools/share/magictool_definebyquery_select.sql

Timestamp:

Nov 24, 2010, 3:42:26 PM (15 years ago)

Author:

bills

Message:

Fix ticket #1439. The trick to match the inverse bit with the maximum diff_id needed to order by
diff_id DESC not ascending

File:

• trunk/ippTools/share/magictool_definebyquery_select.sql (modified) (1 diff)

trunk/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 (