Comments
Sort by recent activity
Same problem here, and this appears to be the bit that causes the error: SELECT <br> 'TRIGGER' AS `TYPE`,<br> t.TRIGGER_SCHEMA AS `DATABASE`,<br> t.TRIGGER_NAME AS `NAME` ,<br> 'TABLE' AS `REFERENCED_TYPE`,<br> t.EVENT_OBJECT_SCHEMA AS `REFERENCED_DATABASE`,<br> t.EVENT_OBJECT_TABLE AS `REFERENCED_NAME`<br>FROM <br> INFORMATION_SCHEMA.TRIGGERS t<br>WHERE t.TRIGGER_SCHEMA = 'sys'<br><br>UNION ALL<br>SELECT<br> 'TABLE' AS `TYPE`,<br> c.CONSTRAINT_SCHEMA AS `DATABASE`,<br> c.TABLE_NAME AS `NAME`,<br> 'TABLE' AS `REFERENCED_TYPE`,<br> c.UNIQUE_CONSTRAINT_SCHEMA AS `REFERENCED_DATABASE`,<br> c.REFERENCED_TABLE_NAME AS `REFERENCED_NAME`<br>FROM<br> 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...
/ comments
Same problem here, and this appears to be the bit that causes the error:SELECT <br> 'TRIGGER' AS `TYPE`,<br> t.TRIGGER_SCHEMA AS `DATABASE`,<br>  ...