diff options
| author | evgen@moonbone.local <> | 2007-06-29 22:13:33 +0400 |
|---|---|---|
| committer | evgen@moonbone.local <> | 2007-06-29 22:13:33 +0400 |
| commit | fc601d775fe520a15e564127f00234b5b58287b0 (patch) | |
| tree | 1c22fb051181a5fc4a75149272b8cf7802312635 /strings/ctype-simple.c | |
| parent | f8b7669ee96b7de12e731df2ad3dce0cb5b3086e (diff) | |
| download | mariadb-git-fc601d775fe520a15e564127f00234b5b58287b0.tar.gz | |
Bug#29261: Sort order of the collation wasn't used when comparing trailing
spaces.
When the my_strnncollsp_simple function compares two strings and one is a prefix
of another then this function compares characters in the rest of longer key
with the space character to find whether the longer key is greater or less.
But the sort order of the collation isn't used in this comparison. This may
lead to a wrong comparison result, wrongly created index or wrong order of the
result set of a query with the ORDER BY clause.
Now the my_strnncollsp_simple function uses collation sort order to compare
the characters in the rest of longer key with the space character.
Diffstat (limited to 'strings/ctype-simple.c')
| -rw-r--r-- | strings/ctype-simple.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/strings/ctype-simple.c b/strings/ctype-simple.c index e57204f8d33..fca5607e152 100644 --- a/strings/ctype-simple.c +++ b/strings/ctype-simple.c @@ -180,7 +180,7 @@ int my_strnncollsp_simple(CHARSET_INFO * cs, const uchar *a, uint a_length, for (end= a + a_length-length; a < end ; a++) { if (*a != ' ') - return (*a < ' ') ? -swap : swap; + return (map[*a] < ' ') ? -swap : swap; } } return res; |