-
Notifications
You must be signed in to change notification settings - Fork 159
Description
Hi, I get below error on --type=data or all. --type=schema works as expected. How can I solve it?
pp@6bb82a2c0270:~/DBDiff$ ./dbdiff server1.small:server2.stage-small --type=data
ℹ Now calculating data diff for table admin_rule
✖ Unexpected error: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-small.admin_rule as a
LEFT JOIN kp-stage-small.admin_rule as b ON ' at line 1 (SQL: SELECT CONVERT(a.rule_idUSING utf8) asrule_id,CONVERT(a.role_idUSING utf8) asrole_id,CONVERT(a.resource_idUSING utf8) asresource_id,CONVERT(a.privilegesUSING utf8) asprivileges,CONVERT(a.assert_idUSING utf8) asassert_id,CONVERT(a.role_typeUSING utf8) asrole_type,CONVERT(a.permissionUSING utf8) aspermissionFROM kp-small.admin_rule as a LEFT JOIN kp-stage-small.admin_rule as b ONa.rule_id=b.rule_idWHEREb.rule_idIS NULL ) PHP Fatal error: Uncaught PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-small.admin_rule as a LEFT JOIN kp-stage-small.admin_rule as b ON' at line 1 in /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php:299
Stack trace:
#0 /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(299): PDO->prepare('SELECT CONVERT(...')
#1 /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(617): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'SELECT CONVERT(...', Array)
#2 /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(581): Illuminate\Database\Connection->runQueryCallback('SELECT CONVERT(...', Array, Object(Closure))
#3 /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(304): I in /data/web/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php on line 625