602622 - weave tables are created with redundant indexes

Status: RESOLVED FIXED

(Cloud Services Graveyard :: Server: Sync, defect)

Description

[Jeff Vier [:jvier]]

the key "usr_col_mod_pay" fully encompasses key "modified".

Therefore, "modified" should be dropped.


MariaDB [weave0]> show create table wbo74;
+-------+-------------+
| Table | Create Table|
+-------+-------------+
| wbo74 | CREATE TABLE `wbo74` (
  `username` int(11) NOT NULL,
  `collection` smallint(6) NOT NULL DEFAULT '0',
  `id` varbinary(64) NOT NULL DEFAULT '',
  `parentid` varbinary(64) DEFAULT NULL,
  `predecessorid` varbinary(64) DEFAULT NULL,
  `sortindex` int(11) DEFAULT NULL,
  `modified` bigint(20) DEFAULT NULL,
  `payload` longtext,
  `payload_size` int(11) DEFAULT NULL,
  PRIMARY KEY (`username`,`collection`,`id`),
  KEY `modified` (`username`,`collection`,`modified`),
  KEY `usr_col_mod_pay` (`username`,`collection`,`modified`,`payload_size`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
+-------+--------------+
1 row in set (0.00 sec)

Comment 1

[Jeff Vier [:jvier]]

In fact, the decision was made with eng to drop usr_col_mod_pay instead.

this is being done along with the alters in bug 604132

Comment 2

[Jeff Vier [:jvier]]

Done forever ago.