diff options
author | unknown <heikki@hundin.mysql.fi> | 2005-03-17 17:44:27 +0200 |
---|---|---|
committer | unknown <heikki@hundin.mysql.fi> | 2005-03-17 17:44:27 +0200 |
commit | 31ab90c80542fa572cd1dff412e9bd265e3a96c0 (patch) | |
tree | 1e7b0b3f2b03783ee78c076c458f2fb358d9ac38 /innobase | |
parent | e4a2c7e92f375b4127c02941be0ae9c6f18c3ee6 (diff) | |
download | mariadb-git-31ab90c80542fa572cd1dff412e9bd265e3a96c0.tar.gz |
data0type.ic:
Fix that 'a' LIKE 'a%' was not true for an InnoDB BLOB or TEXT type column prefix index search: InnoDB assumed that the BLOB and TEXT should not be padded with space in comparisons; this bug is also in 4.1; it may have worked in 4.1 because MySQL may have asked there for strings >= 'a', while in 5.0 it asks for strings >= 'a '
innobase/include/data0type.ic:
Fix that 'a' LIKE 'a%' was not true for an InnoDB BLOB or TEXT type column prefix index search: InnoDB assumed that the BLOB and TEXT should not be padded with space in comparisons; this bug is also in 4.1; it may have worked in 4.1 because MySQL may have asked there for strings >= 'a', while in 5.0 it asks for strings >= 'a '
Diffstat (limited to 'innobase')
-rw-r--r-- | innobase/include/data0type.ic | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/innobase/include/data0type.ic b/innobase/include/data0type.ic index bf04e1c9b27..9264851a84a 100644 --- a/innobase/include/data0type.ic +++ b/innobase/include/data0type.ic @@ -195,7 +195,8 @@ dtype_get_pad_char( || type->mtype == DATA_BINARY || type->mtype == DATA_FIXBINARY || type->mtype == DATA_MYSQL - || type->mtype == DATA_VARMYSQL) { + || type->mtype == DATA_VARMYSQL + || type->mtype == DATA_BLOB) { /* Space is the padding character for all char and binary strings */ |