pt-table-sync fails for point primary keys

[Daniël van Eeden]

pt-table-sync doesn't seem to support a point primary key.

CREATE TABLE `geotest` (
  `g` geometry DEFAULT NULL,
  `p` point NOT NULL DEFAULT '',
  PRIMARY KEY (`p`(25))
) ENGINE=InnoDB DEFAULT CHARSET=latin1

$ pt-table-sync --replicate percona.checksums --print P=22384,u=root,p=msandbox,h=127.0.0.1
Argument "\0\0\0\0^A^A\0\0\0\0\0\0\0\0\0\0@\0\0\0\0\0\0\0@" isn't numeric in numeric comparison (<=>) at /usr/bin/pt-table-sync line 2345. while doing test.geotest on 127.0.0.1

pt-table-sync 2.1.2

[Daniel Nichter (daniel-nichter)]

Not surprising: we've only ever tested standard BTREE indexes.

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PT-1087