{"action":"created","issue":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31068","repository_url":"https://api.github.com/repos/cockroachdb/cockroach","labels_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31068/labels{/name}","comments_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31068/comments","events_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31068/events","html_url":"https://github.com/cockroachdb/cockroach/issues/31068","id":367789181,"node_id":"MDU6SXNzdWUzNjc3ODkxODE=","number":31068,"title":"logictest: TestPlannerLogic/5node-dist/distsql_interleaved_join created unexpected plan","user":{"login":"tschottdorf","id":5076964,"node_id":"MDQ6VXNlcjUwNzY5NjQ=","avatar_url":"https://avatars1.githubusercontent.com/u/5076964?v=4","gravatar_id":"","url":"https://api.github.com/users/tschottdorf","html_url":"https://github.com/tschottdorf","followers_url":"https://api.github.com/users/tschottdorf/followers","following_url":"https://api.github.com/users/tschottdorf/following{/other_user}","gists_url":"https://api.github.com/users/tschottdorf/gists{/gist_id}","starred_url":"https://api.github.com/users/tschottdorf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tschottdorf/subscriptions","organizations_url":"https://api.github.com/users/tschottdorf/orgs","repos_url":"https://api.github.com/users/tschottdorf/repos","events_url":"https://api.github.com/users/tschottdorf/events{/privacy}","received_events_url":"https://api.github.com/users/tschottdorf/received_events","type":"User","site_admin":false},"labels":[{"id":843052634,"node_id":"MDU6TGFiZWw4NDMwNTI2MzQ=","url":"https://api.github.com/repos/cockroachdb/cockroach/labels/A-sql-planning","name":"A-sql-planning","color":"22aa88","default":false}],"state":"open","locked":false,"assignee":{"login":"jordanlewis","id":43821,"node_id":"MDQ6VXNlcjQzODIx","avatar_url":"https://avatars1.githubusercontent.com/u/43821?v=4","gravatar_id":"","url":"https://api.github.com/users/jordanlewis","html_url":"https://github.com/jordanlewis","followers_url":"https://api.github.com/users/jordanlewis/followers","following_url":"https://api.github.com/users/jordanlewis/following{/other_user}","gists_url":"https://api.github.com/users/jordanlewis/gists{/gist_id}","starred_url":"https://api.github.com/users/jordanlewis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordanlewis/subscriptions","organizations_url":"https://api.github.com/users/jordanlewis/orgs","repos_url":"https://api.github.com/users/jordanlewis/repos","events_url":"https://api.github.com/users/jordanlewis/events{/privacy}","received_events_url":"https://api.github.com/users/jordanlewis/received_events","type":"User","site_admin":false},"assignees":[{"login":"jordanlewis","id":43821,"node_id":"MDQ6VXNlcjQzODIx","avatar_url":"https://avatars1.githubusercontent.com/u/43821?v=4","gravatar_id":"","url":"https://api.github.com/users/jordanlewis","html_url":"https://github.com/jordanlewis","followers_url":"https://api.github.com/users/jordanlewis/followers","following_url":"https://api.github.com/users/jordanlewis/following{/other_user}","gists_url":"https://api.github.com/users/jordanlewis/gists{/gist_id}","starred_url":"https://api.github.com/users/jordanlewis/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/jordanlewis/subscriptions","organizations_url":"https://api.github.com/users/jordanlewis/orgs","repos_url":"https://api.github.com/users/jordanlewis/repos","events_url":"https://api.github.com/users/jordanlewis/events{/privacy}","received_events_url":"https://api.github.com/users/jordanlewis/received_events","type":"User","site_admin":false}],"milestone":null,"comments":9,"created_at":"2018-10-08T13:25:14Z","updated_at":"2018-10-08T14:39:52Z","closed_at":null,"author_association":"MEMBER","body":"Seen on a PR which I don't think should have that effect: https://teamcity.cockroachdb.com/viewLog.html?buildId=950803&buildTypeId=Cockroach_UnitTests_Test&tab=buildResultsDiv\r\n\r\n(There's a chance that it is, in some obscure way, caused by it, but I don't think so and it hasn't repro'ed in several minutes of stressrace on my gceworker)\r\n\r\nBasically the plan looks as if there were only four nodes.\r\n\r\nHave:\r\n\r\n<img width=\"609\" alt=\"image\" src=\"https://user-images.githubusercontent.com/5076964/46611517-53295b00-cb0e-11e8-9862-fd38fb707d91.png\">\r\n\r\nWant:\r\n\r\n<img width=\"579\" alt=\"image\" src=\"https://user-images.githubusercontent.com/5076964/46611527-5886a580-cb0e-11e8-8c65-5542fd418643.png\">\r\n\r\n\r\n```\r\nlogic.go:2247: \r\n\t \r\n\ttestdata/planner_test/distsql_interleaved_join:393: SELECT url FROM [EXPLAIN (DISTSQL) SELECT * FROM outer_c1 LEFT OUTER JOIN outer_p1 USING (pid1) WHERE pid1 >= 0 AND pid1 < 40]\r\n\texpected:\r\n\t    https://cockroachdb.github.io/distsqlplan/decode.html#eJzUlE-Lo0AQxe_7KeSddtlaYqu7B2HBSwYMIQ6SOQ0yiF3JCMaW7naYEPzug3rIJJP5l5xys_v1q1e_gnKHWkle5Bs2CO8hQPBA8EEIkBEarQo2RuleHh_H8hmhSyjrprX9dUYolGaEO9jSVowQcW1ZV5w_ccq5ZD1TZc164oIg2eZlNaTNeWXRZ5SbXG8j1VrWD0XfQ1quH99KTS-NpUBYbhsOnfn0Zukkd8tp6sySeAFCxSv7MxK_f_3XfZXhE4SktaETCYo8inyKAor-IesIqrV7DmPzNSMUHb3Dukdsa6Ula5YHTFl3YhoL9Uc1k-Do4elo7yBanDVmcZVj9s5i9a6S1T-L1b9K1k9-FSmbRtWGv7Qdbr9eLNc87qJRrS74VqtiiBmPyeAbLiQbO6piPMT1IA0NvjaLD81_D8zusdm7JNm_xBx8y5x1P14CAAD___ca6HA=\r\n\t    \r\n\tbut found (query options: \"\") :\r\n\t    https://cockroachdb.github.io/distsqlplan/decode.html#eJzUlEHLm0AQhu_9FfKeWjolrpochIKXFAwhFklPRYq4k1QwruyupSH434t6SJOm7feZk7fdnX323WcOc0GtJO_yExuEXyFA8EDwQQhAWCIjNFoVbIzS_ZURiOVPhC6hrJvW9scZoVCaEV5gS1sxQsS1ZV1x_oNTziXrjSpr1gsXBMk2L6shccsHiz6jPOX6HKnWsv5W9P9Iy-P3P0tNXxqfAmF_bjh0tutPeyf5sl-nziaJdyBUfLBvI_H-3UfdvzIsQUhaGzqRoMijyKcooGiFrCOo1l49jM2PjFB09BfXq2JbKy1Zs7xxyroH3dipD6pZLO8uPo72bqLFpDaLWbbZm-TqzdLVn-QazNI1mOTqz9L1P2MxZdOo2vCLJoHbjxKWRx7njlGtLvizVsUQM26TgRsOJBs7VsW4ieuhNHzwd1j8E17dwO497D2T7D8DB8_Ay1fBWffmVwAAAP__PKlIOw==\r\n```\r\n\r\n@jordanlewis for routing."},"comment":{"url":"https://api.github.com/repos/cockroachdb/cockroach/issues/comments/427861093","html_url":"https://github.com/cockroachdb/cockroach/issues/31068#issuecomment-427861093","issue_url":"https://api.github.com/repos/cockroachdb/cockroach/issues/31068","id":427861093,"node_id":"MDEyOklzc3VlQ29tbWVudDQyNzg2MTA5Mw==","user":{"login":"tschottdorf","id":5076964,"node_id":"MDQ6VXNlcjUwNzY5NjQ=","avatar_url":"https://avatars1.githubusercontent.com/u/5076964?v=4","gravatar_id":"","url":"https://api.github.com/users/tschottdorf","html_url":"https://github.com/tschottdorf","followers_url":"https://api.github.com/users/tschottdorf/followers","following_url":"https://api.github.com/users/tschottdorf/following{/other_user}","gists_url":"https://api.github.com/users/tschottdorf/gists{/gist_id}","starred_url":"https://api.github.com/users/tschottdorf/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tschottdorf/subscriptions","organizations_url":"https://api.github.com/users/tschottdorf/orgs","repos_url":"https://api.github.com/users/tschottdorf/repos","events_url":"https://api.github.com/users/tschottdorf/events{/privacy}","received_events_url":"https://api.github.com/users/tschottdorf/received_events","type":"User","site_admin":false},"created_at":"2018-10-08T14:39:52Z","updated_at":"2018-10-08T14:39:52Z","author_association":"MEMBER","body":"https://github.com/cockroachdb/cockroach/issues/13525#issuecomment-414724192?"}}
{"actor":{"display_login":"tschottdorf"}}