Changeset 29832

Timestamp:

Nov 24, 2010, 3:43:16 PM (15 years ago)

Author:

bills

Message:

from trunk Fix bug setting the inverse bit in magictool -definebyquery

File:

• tags/ipp-20101029/ippTools/share/magictool_definebyquery_select.sql (modified) (1 diff, 1 prop)

tags/ipp-20101029/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 (