Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
5.5.54, 5.5.55, 5.5.56, 5.5.57, 5.5.58
-
None
-
FreeBSD 10.3-STABLE
-
5.5.59
Description
select greatest(20170718 + interval 1 day, curDate()) |
fail with
Illegal mix of collations (latin1_german1_ci,NUMERIC) and (latin1_swedish_ci,NUMERIC) for operation 'greatest'
|
Without date function (date_add or curDate) operation greatest works.
Only MariaDB-Server and not MySQl-Server seems to be affected.
MariaDB-Version prior 5.5.54 are not affected..
additional information:
show variables like 'collation%'; |
+----------------------+-------------------+ |
| Variable_name | Value |
|
+----------------------+-------------------+ |
| collation_connection | latin1_german1_ci |
|
| collation_database | latin1_german1_ci |
|
| collation_server | latin1_german1_ci |
|
+----------------------+-------------------+ |
 |
show variables like 'character%'; |
+--------------------------+----------------------------------+ |
| Variable_name | Value |
|
+--------------------------+----------------------------------+ |
| character_set_client | latin1 |
|
| character_set_connection | latin1 |
|
| character_set_database | latin1 |
|
| character_set_filesystem | binary | |
| character_set_results | latin1 |
|
| character_set_server | latin1 |
|
| character_set_system | utf8 |
|
| character_sets_dir | /usr/local/share/mysql/charsets/ | |
+--------------------------+----------------------------------+ |
|