Opened 9 years ago

Closed 9 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


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 9 years ago by bobbysmith007

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

This seems to be your problem:

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

as closed The owner will remain bobbysmith007.
The resolution will be deleted. Next status will be 'reopened'.

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

Note: See TracTickets for help on using tickets.