summaryrefslogtreecommitdiff
path: root/innobase
diff options
context:
space:
mode:
authorunknown <heikki@hundin.mysql.fi>2005-03-17 17:44:27 +0200
committerunknown <heikki@hundin.mysql.fi>2005-03-17 17:44:27 +0200
commit31ab90c80542fa572cd1dff412e9bd265e3a96c0 (patch)
tree1e7b0b3f2b03783ee78c076c458f2fb358d9ac38 /innobase
parente4a2c7e92f375b4127c02941be0ae9c6f18c3ee6 (diff)
downloadmariadb-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.ic3
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 */