Modify

Opened 6 years ago

Closed 6 years ago

#3067 closed defect (invalid)

UNION fails because of collation in MySQL

Reported by: timo.hanhirova@… Owned by: bobbysmith007
Priority: normal Component: TimingAndEstimationPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.10

Description

Eeror message "Report execution failed: (1271, "Illegal mix of collations for operation 'UNION'")" is shown when trying to run ticket/hour reports. Checking database didn't reveal anything, everything is in ut8_unicode_ci as it should be, and UNIONs in billing reports work fine.

Attachments (0)

Change History (1)

comment:1 Changed 6 years ago by bobbysmith007

  • Resolution set to invalid
  • Status changed from new to closed

This seems to be your problem: http://bugs.mysql.com/bug.php?id=21505

If you think it is something else, please feel free to reopen and I will investigate further.

Relevant facts:

  • I use cast and convert which the mysql bug refers to as an instigator
  • I would expect views and subselects to be treated similarly thus UNION expressing the same bug.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.