title: Getting Error - 'Inconsistency in usage of column' while partitioning a table
body: <p>I have got a table <code>ee_company_product_listings_par</code> which has got many columns including <code>cplc_id</code> and <code>marketplaceID</code>.</p>
  
  <p>This is the DDL of the table:- </p>
  
  <pre><code>ee_company_product_listings_par | CREATE TABLE `ee_company_product_listings_par` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `company_product_id` int(11) DEFAULT NULL,
      `feed_dump_id` int(11) DEFAULT NULL,
      `listing_status_id` int(11) DEFAULT NULL,
      `sku` varchar(500) DEFAULT NULL,
      `mrp` float DEFAULT NULL,
      `selling_price` float DEFAULT NULL,
      `quantity` int(11) NOT NULL,
      `merchant_payout` float DEFAULT NULL,
      `shipping_cost` float DEFAULT NULL,
      `commission` float DEFAULT NULL,
      `commission_service_tax` float DEFAULT NULL,
      `pmt_gateway_charge` float DEFAULT NULL,
      `shipping_local` float DEFAULT NULL,
      `shipping_zonal` float DEFAULT NULL,
      `shipping_national` float DEFAULT NULL,
      `site_uid` varchar(200) DEFAULT '-',
      `listing_ref_number` varchar(200) DEFAULT '-',
      `UID` varchar(50) DEFAULT NULL,
      `marketplaceID` int(11) NOT NULL,
      `confirmed` tinyint(1) NOT NULL DEFAULT '0',
      `inventory_live` tinyint(2) NOT NULL DEFAULT '1',
      `update_cpl_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
      `sku_corrected` tinyint(1) DEFAULT '0',
      `cplisting_entry_time` timestamp NULL DEFAULT NULL,
      `weight` float(10,2) DEFAULT NULL,
      `length` float(10,2) DEFAULT NULL,
      `height` float(10,2) DEFAULT NULL,
      `width` float(10,2) DEFAULT NULL,
      `cplc_id` int(11) NOT NULL DEFAULT '0',
      `mp_cat_id` int(11) DEFAULT NULL,
      `process_id` varchar(10) DEFAULT NULL,
      `host_ip` varchar(20) DEFAULT NULL,
      `color` varchar(100) DEFAULT NULL,
      `size` varchar(100) DEFAULT NULL,
      `identifier` varchar(200) DEFAULT NULL,
      `mp_brand_id` int(11) DEFAULT NULL,
      PRIMARY KEY (`id`,`cplc_id`,`marketplaceID`)
  ) ENGINE=InnoDB AUTO_INCREMENT=21474383 DEFAULT CHARSET=latin1 |
  </code></pre>
  
  <p>Range of <code>cplc_id</code> is from 0-10000
  Range of <code>marketplaceID</code> is from 0-100</p>
  
  <p>I want to create Range partitions on the basis of these two columns. </p>
  
  <p>This was the query I am running:-</p>
  
  <pre><code>alter table ee_company_product_listings_par partition by range columns (cplc_id, marketplaceID) (
  PARTITION p500_5 VALUES LESS THAN (500, 5),
  PARTITION p500_10 VALUES LESS THAN (500,10),
  PARTITION p1000_5 VALUES LESS THAN (1000,5),
  PARTITION p1000_10 VALUES LESS THAN (1000,10),
  partition pmax values less than MAXVALUE
  );
  </code></pre>
  
  <p>This is the error I am getting:-</p>
  
  <pre><code>ERROR 1064 (42000): Inconsistency in usage of column lists for partitioning near 'MAXVALUE
  )' at line 4
  </code></pre>
  
  <p>Can someone help to find what is the problem in the query. Searched all over the internet but didn't find any solution. There might be some silly mistake as I am totally new to partitioning.  Any help would be appreciated.</p>