diff options
| author | unknown <evgen@moonbone.local> | 2005-10-25 20:37:26 +0400 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2005-10-25 20:37:26 +0400 |
| commit | b96dbef6fd553360f13a52d2b496fe7d86665e7c (patch) | |
| tree | aae868ddbefc26a40a216f2bb05d0aca1b3739ed /mysql-test/r/date_formats.result | |
| parent | 6e49a48a25465eeb8e9e4c6b510b78ed508242bc (diff) | |
| download | mariadb-git-b96dbef6fd553360f13a52d2b496fe7d86665e7c.tar.gz | |
Fix bug #14016 date_format() 2nd parameter was compared using case insensitive
collation
By default constant strings in second parameter of date_time() have case
insensitive collation. Because of this expressions date_format(f,'%m') and
date_format(f,'%M') wrongly becomes equal, which results in choosing wrong
column to sort by.
Now if second parameter of date_format() is constant then it's collation is
changed to case sensitive.
sql/item_timefunc.cc:
Fix bug #14016 date_format() 2nd parameter was compared using case insensitive collation.
If second parameter of date_format() is constant then it's collation is changed to case sensitive.
mysql-test/r/date_formats.result:
Test case for bug#14016 2nd parameter was compared using case insensitive collation
mysql-test/t/date_formats.test:
Test case for bug#14016 2nd parameter was compared using case insensitive collation
Diffstat (limited to 'mysql-test/r/date_formats.result')
| -rw-r--r-- | mysql-test/r/date_formats.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/date_formats.result b/mysql-test/r/date_formats.result index 2db014c4a52..34a2dedd976 100644 --- a/mysql-test/r/date_formats.result +++ b/mysql-test/r/date_formats.result @@ -456,3 +456,11 @@ f1 f2 Warnings: Warning 1292 Truncated incorrect date value: '2003-04-05 g' Warning 1292 Truncated incorrect datetime value: '2003-04-05 10:11:12.101010234567' +create table t1 (f1 datetime); +insert into t1 (f1) values ("2005-01-01"); +insert into t1 (f1) values ("2005-02-01"); +select date_format(f1, "%m") as d1, date_format(f1, "%M") as d2 from t1 order by date_format(f1, "%M"); +d1 d2 +02 February +01 January +drop table t1; |