diff options
| author | Ramil Kalimullin <ramil@mysql.com> | 2009-10-18 21:26:55 +0500 |
|---|---|---|
| committer | Ramil Kalimullin <ramil@mysql.com> | 2009-10-18 21:26:55 +0500 |
| commit | 0b43c4e74c81ff136093c3238e03fb0c38b562fd (patch) | |
| tree | ec425ed3547d9d254ea62e49464e02d39a8e7814 /sql/sql_locale.cc | |
| parent | f6868a4eb42f39a5f4e8179b91fe38f0ff299ebe (diff) | |
| parent | 662d8367440f7de655500990469754c7b538ce73 (diff) | |
| download | mariadb-git-0b43c4e74c81ff136093c3238e03fb0c38b562fd.tar.gz | |
Fix for bug#47963: Wrong results when index is used
Problem: using null microsecond part in a WHERE condition
(e.g. WHERE date_time_field <= "YYYY-MM-DD HH:MM:SS.0000")
may lead to wrong results due to improper DATETIMEs
comparison in some cases.
Fix: comparing DATETIMEs as strings we must trim trailing 0's
in such cases.
mysql-test/r/innodb_mysql.result:
Fix for bug#47963: Wrong results when index is used
- test result.
mysql-test/t/innodb_mysql.test:
Fix for bug#47963: Wrong results when index is used
- test case.
sql/item.cc:
Fix for bug#47963: Wrong results when index is used
- comparing DATETIMEs as strings we must trim trailing 0's in the
microsecond part to ensure
'YYYY-MM-DD HH:MM:SS.000' == 'YYYY-MM-DD HH:MM:SS'
Diffstat (limited to 'sql/sql_locale.cc')
0 files changed, 0 insertions, 0 deletions