mysql migration: make sure the indices sql which left-join be the same database #6424
Description
Issue type:
[ ] question
[x] bug report
[ ] feature request
[ ] documentation issue
Database system/driver:
[ ] cordova
[ ] mongodb
[ ] mssql
[x] mysql / mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo
TypeORM version:
[x] latest
[ ] @next
[ ] 0.x.x (or put your version here)
Steps to reproduce or a small repository showing the problem:
Current
SELECT `s`.*
FROM `INFORMATION_SCHEMA`.`STATISTICS` `s`
LEFT JOIN `INFORMATION_SCHEMA`.`REFERENTIAL_CONSTRAINTS` `rc`
ON `s`.`INDEX_NAME` = `rc`.`CONSTRAINT_NAME`
Should be
SELECT `s`.*
FROM `INFORMATION_SCHEMA`.`STATISTICS` `s`
LEFT JOIN `INFORMATION_SCHEMA`.`REFERENTIAL_CONSTRAINTS` `rc`
ON `s`.`INDEX_NAME` = `rc`.`CONSTRAINT_NAME`
AND `s`.`TABLE_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA`. # --- new condition