Illegal mix of collections of operation 'UNION'

• 
  Same problem here, and this appears to be the bit that causes the error:

  
  

  SELECT <br>&nbsp;&nbsp;&nbsp; 'TRIGGER' AS `TYPE`,<br>&nbsp;&nbsp;&nbsp; t.TRIGGER_SCHEMA AS `DATABASE`,<br>&nbsp;&nbsp;&nbsp; t.TRIGGER_NAME&nbsp; AS `NAME` ,<br>&nbsp;&nbsp;&nbsp; 'TABLE' AS `REFERENCED_TYPE`,<br>&nbsp;&nbsp;&nbsp; t.EVENT_OBJECT_SCHEMA AS `REFERENCED_DATABASE`,<br>&nbsp;&nbsp;&nbsp; t.EVENT_OBJECT_TABLE AS `REFERENCED_NAME`<br>FROM <br>&nbsp;&nbsp;&nbsp; INFORMATION_SCHEMA.TRIGGERS t<br>WHERE t.TRIGGER_SCHEMA = 'sys'<br><br>UNION ALL<br>SELECT<br>&nbsp;&nbsp;&nbsp; 'TABLE' AS `TYPE`,<br>&nbsp;&nbsp;&nbsp; c.CONSTRAINT_SCHEMA AS `DATABASE`,<br>&nbsp;&nbsp;&nbsp; c.TABLE_NAME&nbsp; AS `NAME`,<br>&nbsp;&nbsp;&nbsp; 'TABLE' AS `REFERENCED_TYPE`,<br>&nbsp;&nbsp;&nbsp; c.UNIQUE_CONSTRAINT_SCHEMA AS `REFERENCED_DATABASE`,<br>&nbsp;&nbsp;&nbsp; c.REFERENCED_TABLE_NAME AS `REFERENCED_NAME`<br>FROM<br>&nbsp;&nbsp;&nbsp; INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS c<br>WHERE c.CONSTRAINT_SCHEMA = 'sys';

  
  

  TRIGGER_NAME is utf8_general_ci, while TABLE_NAME is utf8_tolower_ci [at least in MySQL 8.0.16]. This basically makes the tool unusable, so it'd be nice to get it fixed...
  

  PeterL August 07, 2019 13:44

  - 0 +
• 
  I also get the error "Illegal mix of collations for operation 'UNION'" when trying to compare to a local mysql (version 

  8.0.18)

  database. This will occur even if it is a completely empty database. I've tried all options available in the mysqlcompare tool, nothing helps. 
  As PeterL notes, this makes the tool unusable.

  Brian_Mindwell December 05, 2019 17:43

  - 0 +
• 
  Hi guys,
  
  Is there a fix for this issue?
  
  Thanks,
  Chris

  TrueByte March 16, 2020 15:40

  - 0 +

Add comment

Please sign in to leave a comment.