Percona Toolkit moved to https://jira.percona.com/projects/PT

  1. Bug #911996
  2. Comment #3

Comment 3 for bug 911996

Revision history for this message
Paul Graydon (twirrim) wrote : Re: pt-table-sync replicate resulting in "Unknown Column"

mysql> SHOW CREATE TABLE boc.doc\G
*************************** 1. row ***************************
       Table: doc
Create Table: CREATE TABLE `doc` (
  `docno` varchar(12) NOT NULL DEFAULT '',
  `doctype` char(1) DEFAULT NULL,
  `rdate` date NOT NULL DEFAULT '0000-00-00',
  `grantor` varchar(40) NOT NULL DEFAULT '',
  `grantee` varchar(40) NOT NULL DEFAULT '',
  `class` varchar(12) DEFAULT NULL,
  `class_desc` varchar(12) DEFAULT NULL,
  `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`docno`),
  KEY `names` (`grantor`,`grantee`),
  KEY `grantee` (`grantee`),
  KEY `idx_doc_rdate` (`rdate`),
  KEY `idx_doc_class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1