Modify

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: Russ Tyndall
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 9 years ago by Russ Tyndall

Resolution: invalid
Status: newclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Russ Tyndall.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment


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

 
Note: See TracTickets for help on using tickets.