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 .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from bobbysmith007. Next status will be '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.