sveta@Thinkie:~/build/ps-5.7/mysql-test$ ~/build/percona-toolkit/bin/pt-table-sync h=127.0.0.1,P=13001,u=root,D=test,t=pt_zerospace h=127.0.0.1,P=13002,u=root,D=test,t=pt_zerospace --execute
Field 'a' doesn't have a default value [for Statement "INSERT INTO `test`.`pt_zerospace`() VALUES () /*percona-toolkit src_db:test src_tbl:pt_zerospace src_dsn:D=test,P=13001,h=127.0.0.1,t=pt_zerospace,u=root dst_db:test dst_tbl:pt_zerospace dst_dsn:D=test,P=13002,h=127.0.0.1,t=pt_zerospace,u=root lock:0 transaction:1 changing_src:0 replicate:0 bidirectional:0 pid:12107 user:sveta host:Thinkie*/"] at line 10762 while doing test.pt_zerospace on 127.0.0.1
Thank you for the report.
With version 2.2.19 I get one more error:
sveta@Thinkie: ~/build/ ps-5.7/ mysql-test$ ~/build/ percona- toolkit/ bin/pt- table-sync h=127.0. 0.1,P=13001, u=root, D=test, t=pt_zerospace h=127.0. 0.1,P=13002, u=root, D=test, t=pt_zerospace --execute `pt_zerospace` () VALUES () /*percona-toolkit src_db:test src_tbl: pt_zerospace src_dsn: D=test, P=13001, h=127.0. 0.1,t=pt_ zerospace, u=root dst_db:test dst_tbl: pt_zerospace dst_dsn: D=test, P=13002, h=127.0. 0.1,t=pt_ zerospace, u=root lock:0 transaction:1 changing_src:0 replicate:0 bidirectional:0 pid:12107 user:sveta host:Thinkie*/"] at line 10762 while doing test.pt_zerospace on 127.0.0.1
Field 'a' doesn't have a default value [for Statement "INSERT INTO `test`.
Bug confirmed.