diff options
author | adam <adam> | 2011-05-07 04:03:07 +0000 |
---|---|---|
committer | adam <adam> | 2011-05-07 04:03:07 +0000 |
commit | d711bb3310cd584e8e462afbdfcd595fccddd3e6 (patch) | |
tree | dc51a4224630cb42250a2e6a25e0ea87fd8d1cdb /benchmarks | |
parent | 5bd9fdd9ee7b5434ba714f3fcc3a8ea0ccbcbd65 (diff) | |
download | pkgsrc-d711bb3310cd584e8e462afbdfcd595fccddd3e6.tar.gz |
Changes 5.5.12:
* Fixed bugs: Illegal mix of collations
* Problem: comparison of a DATETIME sp variable and NOW() led to Illegal mix of
collations error when character_set_connection=utf8.
* Error happened in Arg_comparator::set_compare_func(), because the first
argument was errouneously converted to utf8, while the second argument was
not.
* Fix: separate agg_arg_charsets_for_comparison() into two functions:
- agg_arg_charsets_for_comparison() - for pure comparison, when we don't need
to return any string result and therefore don't need to convert arguments
to @@character_set_connection:
SELECT a = b;
- agg_arg_charsets_for_string_results_with_comparison() - when we need to
return a string result, but we also need to do comparison internally:
SELECT REPLACE(a,b,c)
If all arguments are numbers:
SELECT REPLACE(123,2,3) -> 133
we convert arguments to @@character_set_connection.
Diffstat (limited to 'benchmarks')
0 files changed, 0 insertions, 0 deletions