{"action":"opened","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/603","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/603/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/603/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/603/events","html_url":"https://github.com/actiontech/dble/issues/603","id":343897055,"node_id":"MDU6SXNzdWUzNDM4OTcwNTU=","number":603,"title":"If complex query break the sharding rule，the session will hang","user":{"login":"yanhuqing666","id":16715575,"node_id":"MDQ6VXNlcjE2NzE1NTc1","avatar_url":"https://avatars1.githubusercontent.com/u/16715575?v=4","gravatar_id":"","url":"https://api.github.com/users/yanhuqing666","html_url":"https://github.com/yanhuqing666","followers_url":"https://api.github.com/users/yanhuqing666/followers","following_url":"https://api.github.com/users/yanhuqing666/following{/other_user}","gists_url":"https://api.github.com/users/yanhuqing666/gists{/gist_id}","starred_url":"https://api.github.com/users/yanhuqing666/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yanhuqing666/subscriptions","organizations_url":"https://api.github.com/users/yanhuqing666/orgs","repos_url":"https://api.github.com/users/yanhuqing666/repos","events_url":"https://api.github.com/users/yanhuqing666/events{/privacy}","received_events_url":"https://api.github.com/users/yanhuqing666/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-07-24T06:08:38Z","updated_at":"2018-07-24T06:08:38Z","closed_at":null,"author_association":"COLLABORATOR","body":"* **dble version：**  2.18.07.0~\r\n* **preconditions ：**  \r\n```\r\nCREATE TABLE `test_table1` (\r\n  `id` int(11) NOT NULL,\r\n  `c_flag` char(255) DEFAULT NULL,\r\n  `c_decimal` decimal(16,4) DEFAULT NULL,\r\n  PRIMARY KEY (`id`)\r\n) ENGINE=InnoDB DEFAULT CHARSET=utf8;\r\n``` \r\n* **configs：** \r\n\r\n**schema.xml**  \r\n\r\n```\r\n...\r\n<table name=\"test_table1\" dataNode=\"dn1,dn2\" rule=\"auto-sharding-long-test\" />\r\n...\r\n```\r\n\r\n**rule.xml**  \r\n\r\n```\r\n<?xml version='1.0' encoding='utf-8'?>\r\n<!DOCTYPE dble:rule SYSTEM \"rule.dtd\">\r\n<tableRule name=\"auto-sharding-long-test\">\r\n\t\t<rule>\r\n\t\t\t<columns>id</columns>\r\n\t\t\t<algorithm>rang-long-test</algorithm>\r\n\t\t</rule>\r\n</tableRule>\r\n\t\r\n\t\r\n<function name=\"rang-long-test\" class=\"NumberRange\">\r\n\t\t<property name=\"mapFile\">autopartition-long.rule.auto</property>\r\n</function>\r\n<dble:rule xmlns:dble=\"http://dble.cloud/\">\r\n\r\n```\r\n\r\n**autopartition-long.rule.auto**  \r\n\r\n```\r\n1-2=0\r\n3-4=1\r\n\r\n\r\n```\r\n\r\n* **steps：**    \r\nstep1.  \r\nselect * from test_table1 where id =5 order by c_flag;\r\nstep2.  \r\nexplain select * from test_table1 where id =5 order by c_flag;\r\n* **expect result：**  \r\n1.report the id break the sharding rule\r\n2.report the id break the sharding rule\r\n* **real result：**  \r\n1. hang\r\n2. table node buildOwn exception\r\n* **supplements：**  \r\n    1.\r\n\r\n\r\n/label ~BUG\r\n"}}
{"actor":{"display_login":"yanhuqing666"}}