bk commit into 4.0 tree

Below is the list of changes that have just been committed into a local
4.0 repository of heikki. When heikki does a push these changes will
be propagated to the main repository and, within 24 hours after the
push, to the public repository.
For information on how to access the public repository
see http://www.mysql.com/doc/I/n/Installing_source_tree.html

ChangeSet
  1.1323 02/09/26 21:21:44 heikki@xxxxxxxxxxxxxxx +1 -0
  ha_innodb.h:
    Put the flag HA_NOT_READ_PREFIX_LAST back to index_flags: seems to fix also 
the LIKE ... DESC bug

  sql/ha_innodb.h
    1.46 02/09/26 21:21:34 heikki@xxxxxxxxxxxxxxx +1 -5
    Put the flag HA_NOT_READ_PREFIX_LAST back to index_flags: seems to fix also 
the LIKE ... DESC bug

# This is a BitKeeper patch.  What follows are the unified diffs for the
# set of deltas contained in the patch.  The rest of the patch, the part
# that BitKeeper cares about, is below these diffs.
# User: heikki
# Host: hundin.mysql.fi
# Root: /home/heikki/mysql-4.0

--- 1.45/sql/ha_innodb.h        Wed Sep 25 20:35:01 2002
+++ 1.46/sql/ha_innodb.h        Thu Sep 26 21:21:34 2002
@@ -81,10 +81,6 @@
                          HA_NO_WRITE_DELAYED |
                          HA_PRIMARY_KEY_IN_READ_INDEX |
                          HA_DROP_BEFORE_CREATE |
-                         /* We should also list HA_NOT_READ_PREFIX_LAST
-                            here but it currently seems to break ORDER BY;
-                            until release 4.0.5 some LIKE 'abc%' ... DESC
-                            queries will not work correctly */
                          HA_NO_PREFIX_CHAR_KEYS |
                          HA_TABLE_SCAN_ON_INDEX),
          last_dup_key((uint) -1),
@@ -100,7 +96,7 @@
        ulong index_flags(uint idx) const
        {
          return (HA_READ_NEXT | HA_READ_PREV | HA_READ_ORDER |
-                 HA_KEY_READ_ONLY);
+                 HA_KEY_READ_ONLY | HA_NOT_READ_PREFIX_LAST);
        }
        uint max_record_length() const { return HA_MAX_REC_LENGTH; }
        uint max_keys()          const { return MAX_KEY; }

---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail internals-thread4822@xxxxxxxxxxxxxxx
To unsubscribe, e-mail <internals-unsubscribe@xxxxxxxxxxxxxxx>