{"action":"created","issue":{"url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/16","labels_url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/16/labels{/name}","comments_url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/16/comments","events_url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/16/events","html_url":"https://github.com/MySQLOnRocksDB/mysql-5.6/issues/16","id":53820607,"number":16,"title":"Point lookup by reverse column family doesn't work","user":{"login":"yoshinorim","id":253614,"avatar_url":"https://avatars.githubusercontent.com/u/253614?v=3","gravatar_id":"","url":"https://api.github.com/users/yoshinorim","html_url":"https://github.com/yoshinorim","followers_url":"https://api.github.com/users/yoshinorim/followers","following_url":"https://api.github.com/users/yoshinorim/following{/other_user}","gists_url":"https://api.github.com/users/yoshinorim/gists{/gist_id}","starred_url":"https://api.github.com/users/yoshinorim/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yoshinorim/subscriptions","organizations_url":"https://api.github.com/users/yoshinorim/orgs","repos_url":"https://api.github.com/users/yoshinorim/repos","events_url":"https://api.github.com/users/yoshinorim/events{/privacy}","received_events_url":"https://api.github.com/users/yoshinorim/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/labels/bug","name":"bug","color":"fc2929"}],"state":"open","locked":false,"assignee":{"login":"spetrunia","id":2734550,"avatar_url":"https://avatars.githubusercontent.com/u/2734550?v=3","gravatar_id":"","url":"https://api.github.com/users/spetrunia","html_url":"https://github.com/spetrunia","followers_url":"https://api.github.com/users/spetrunia/followers","following_url":"https://api.github.com/users/spetrunia/following{/other_user}","gists_url":"https://api.github.com/users/spetrunia/gists{/gist_id}","starred_url":"https://api.github.com/users/spetrunia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spetrunia/subscriptions","organizations_url":"https://api.github.com/users/spetrunia/orgs","repos_url":"https://api.github.com/users/spetrunia/repos","events_url":"https://api.github.com/users/spetrunia/events{/privacy}","received_events_url":"https://api.github.com/users/spetrunia/received_events","type":"User","site_admin":false},"milestone":null,"comments":2,"created_at":"2015-01-09T00:41:18Z","updated_at":"2015-02-25T22:07:43Z","closed_at":null,"body":"How to repeat:\r\nCREATE TABLE `linktable` (\r\n  `id1` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `id2` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `visibility` tinyint(3) NOT NULL DEFAULT '0',\r\n  `data` varchar(255) COLLATE latin1_bin NOT NULL DEFAULT '',\r\n  `time` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `version` int(11) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`link_type`,`id1`,`id2`) COMMENT 'rev:cf_primary',\r\n  KEY `id1_type` (`id1`,`link_type`,`visibility`,`time`,`id2`,`version`,`data`)\r\n) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;\r\ninsert into linktable values (1,1,1,1,1,1,1),(2,2,2,2,2,2,2),(3,3,3,3,3,3,3),(4,4,4,4,4,4,4),(5,5,5,5,5,5,5),(6,6,6,6,6,6,6),(7,7,7,7,7,7,7),(8,8,8,8,8,8,8),(9,9,9,9,9,9,9),(10,10,10,10,10,10,10),(11,11,11,11,11,11,11),(12,12,12,12,12,12,12),(13,13,13,13,13,13,13),(14,14,14,14,14,14,14),(15,15,15,15,15,15,15),(16,16,16,16,16,16,16),(17,17,17,17,17,17,17),(18,18,18,18,18,18,18),(19,19,19,19,19,19,19),(20,20,20,20,20,20,20);\r\n\r\nmysql> select * from linktable force index(PRIMARY) where link_type=1;\r\nEmpty set (0.00 sec)\r\n\r\nmysql> select * from linktable force index(id1_type) where link_type=1;\r\n+-----+-----+-----------+------------+------+------+---------+\r\n| id1 | id2 | link_type | visibility | data | time | version |\r\n+-----+-----+-----------+------------+------+------+---------+\r\n|   1 |   1 |         1 |          1 | 1    |    1 |       1 |\r\n+-----+-----+-----------+------------+------+------+---------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> update linktable set version=100 where link_type=1;\r\nQuery OK, 0 rows affected (0.00 sec)\r\nRows matched: 0  Changed: 0  Warnings: 0\r\n\r\nmysql> update linktable set version=100 where id1=1;\r\nQuery OK, 1 row affected (0.00 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n\r\n\r\nIt doesn't work with reverse cf on secondary index, either:\r\nCREATE TABLE `linktable` (\r\n  `id1` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `id2` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `link_type` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `visibility` tinyint(3) NOT NULL DEFAULT '0',\r\n  `data` varchar(255) COLLATE latin1_bin NOT NULL DEFAULT '',\r\n  `time` bigint(20) unsigned NOT NULL DEFAULT '0',\r\n  `version` int(11) unsigned NOT NULL DEFAULT '0',\r\n  PRIMARY KEY (`link_type`,`id1`,`id2`),\r\n  KEY `id1_type` (`id1`,`link_type`,`visibility`,`time`,`id2`,`version`,`data`) COMMENT 'rev:cf_id1_type'\r\n) ENGINE=ROCKSDB DEFAULT CHARSET=latin1 COLLATE=latin1_bin;\r\ninsert into linktable values (1,1,1,1,1,1,1),(2,2,2,2,2,2,2),(3,3,3,3,3,3,3),(4,4,4,4,4,4,4),(5,5,5,5,5,5,5),(6,6,6,6,6,6,6),(7,7,7,7,7,7,7),(8,8,8,8,8,8,8),(9,9,9,9,9,9,9),(10,10,10,10,10,10,10),(11,11,11,11,11,11,11),(12,12,12,12,12,12,12),(13,13,13,13,13,13,13),(14,14,14,14,14,14,14),(15,15,15,15,15,15,15),(16,16,16,16,16,16,16),(17,17,17,17,17,17,17),(18,18,18,18,18,18,18),(19,19,19,19,19,19,19),(20,20,20,20,20,20,20);\r\n\r\nmysql> select * from linktable force index(id1_type) where id1=1;\r\nEmpty set (0.00 sec)\r\n\r\nmysql> select * from linktable force index(PRIMARY) where id1=1;\r\n+-----+-----+-----------+------------+------+------+---------+\r\n| id1 | id2 | link_type | visibility | data | time | version |\r\n+-----+-----+-----------+------------+------+------+---------+\r\n|   1 |   1 |         1 |          1 | 1    |    1 |       1 |\r\n+-----+-----+-----------+------------+------+------+---------+\r\n1 row in set (0.00 sec)\r\n\r\nmysql> update linktable set version=100 where id1=10;\r\nQuery OK, 0 rows affected (0.00 sec)\r\nRows matched: 0  Changed: 0  Warnings: 0\r\n\r\nmysql> update linktable set version=100 where link_type=1;\r\nQuery OK, 1 row affected (0.03 sec)\r\nRows matched: 1  Changed: 1  Warnings: 0\r\n"},"comment":{"url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/comments/76071158","html_url":"https://github.com/MySQLOnRocksDB/mysql-5.6/issues/16#issuecomment-76071158","issue_url":"https://api.github.com/repos/MySQLOnRocksDB/mysql-5.6/issues/16","id":76071158,"user":{"login":"spetrunia","id":2734550,"avatar_url":"https://avatars.githubusercontent.com/u/2734550?v=3","gravatar_id":"","url":"https://api.github.com/users/spetrunia","html_url":"https://github.com/spetrunia","followers_url":"https://api.github.com/users/spetrunia/followers","following_url":"https://api.github.com/users/spetrunia/following{/other_user}","gists_url":"https://api.github.com/users/spetrunia/gists{/gist_id}","starred_url":"https://api.github.com/users/spetrunia/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/spetrunia/subscriptions","organizations_url":"https://api.github.com/users/spetrunia/orgs","repos_url":"https://api.github.com/users/spetrunia/repos","events_url":"https://api.github.com/users/spetrunia/events{/privacy}","received_events_url":"https://api.github.com/users/spetrunia/received_events","type":"User","site_admin":false},"created_at":"2015-02-25T22:07:43Z","updated_at":"2015-02-25T22:07:43Z","body":"Agreed to split the patch into smaller pieces, this is the first one: https://reviews.facebook.net/D33975"}}