Comment 0 for bug 1462904

Revision history for this message
Nilnandan Joshi (nilnandan-joshi) wrote :

mysql> show create table order_scores_history_old \G
*************************** 1. row ***************************
       Table: order_scores_history_old
Create Table: CREATE TABLE `order_scores_history_old` (
  `suborder_id` int(20) DEFAULT NULL,
  `suborder_code` varchar(20) DEFAULT NULL,
  `order_date` datetime DEFAULT NULL,
  `supc` varchar(15) DEFAULT NULL,
  `subcategory_id` int(11) DEFAULT NULL,
  `seller_code` varchar(20) DEFAULT NULL,
  `seller_id` int(11) NOT NULL,
  `shipping_model` varchar(11) DEFAULT NULL,
  `shipping_model_detail` varchar(30) DEFAULT NULL,
  `order_cld_date` datetime DEFAULT NULL,
  `time_flag` int(2) DEFAULT NULL,
  `OOS_penalty` double(3,2) DEFAULT NULL,
  `Wrong_Product_Delivered` double(3,2) NOT NULL DEFAULT '0.00',
  `unhappy_with_the_quality` double(3,2) NOT NULL DEFAULT '0.00',
  `Physical_Damage_in_Product` double(3,2) NOT NULL DEFAULT '0.00',
  `Invoice_not_received` double(3,2) NOT NULL DEFAULT '0.00',
  `Faulty_Product_Delivered` double(3,2) NOT NULL DEFAULT '0.00',
  `Products_Freebie_not_received` double(3,2) NOT NULL DEFAULT '0.00',
  `Products_Warranty_Card_Certificate_not_received` double(3,2) NOT NULL DEFAULT '0.00',
  `Products_Used_Product_Received` double(3,2) NOT NULL DEFAULT '0.00',
  `rating` varchar(5) DEFAULT NULL,
  `IC_Poor_product_quality` double(3,2) NOT NULL DEFAULT '0.00',
  `IC_Poor_packaging` double(3,2) NOT NULL DEFAULT '0.00',
  `IC_Damaged_product_delivered` double(3,2) NOT NULL DEFAULT '0.00',

  ```Customer_Wants_Size_Change``` double(6,4) NOT NULL DEFAULT '0.0000',

  `IC_Wrong_product_delivered` double(3,2) NOT NULL DEFAULT '0.00',
  `date_delivered` datetime DEFAULT NULL,
  `ops_penalty` double(3,2) DEFAULT '0.00',
  `order_cld_after_exp_date` double(3,2) DEFAULT '0.00',
  `order_moved_after_exp_date` double(3,2) DEFAULT '0.00',
  `order_shipped_after_exp_date` double(3,2) DEFAULT '0.00',
  `fss_penalty` double(3,2) DEFAULT '0.00',
  `selling_price` int(12) DEFAULT NULL,
  `sdf_cashback` int(12) DEFAULT NULL,
  `promo_value` int(12) DEFAULT NULL,
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  KEY `indx_updated` (`updated`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
1 row in set (0.00 sec)

mysql> quit
Bye
nilnandan@desktop:~$ pt-duplicate-key-checker
Can't determine column type for ```customer_wants_size_change``` double(6,4) not null default '0.0000' at /usr/bin/pt-duplicate-key-checker line 360.
nilnandan@desktop:~$

Current workaround can be ignore that table.

nilnandan@desktop:~$ pt-duplicate-key-checker --ignore-tables=order_scores_history_old
# ########################################################################
# Summary of indexes
# ########################################################################

# Total Indexes 55
nilnandan@desktop:~$