{"action":"closed","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/696","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/696/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/696/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/696/events","html_url":"https://github.com/actiontech/dble/issues/696","id":358938268,"node_id":"MDU6SXNzdWUzNTg5MzgyNjg=","number":696,"title":"hint  return incorrect result  when type =sql and table name in sql does not exist ","user":{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false},"labels":[{"id":1038981828,"node_id":"MDU6TGFiZWwxMDM4OTgxODI4","url":"https://api.github.com/repos/actiontech/dble/labels/hint","name":"hint","color":"1bc7e5","default":false}],"state":"closed","locked":false,"assignee":{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false},"assignees":[{"login":"yexiaoli88","id":39580715,"node_id":"MDQ6VXNlcjM5NTgwNzE1","avatar_url":"https://avatars2.githubusercontent.com/u/39580715?v=4","gravatar_id":"","url":"https://api.github.com/users/yexiaoli88","html_url":"https://github.com/yexiaoli88","followers_url":"https://api.github.com/users/yexiaoli88/followers","following_url":"https://api.github.com/users/yexiaoli88/following{/other_user}","gists_url":"https://api.github.com/users/yexiaoli88/gists{/gist_id}","starred_url":"https://api.github.com/users/yexiaoli88/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/yexiaoli88/subscriptions","organizations_url":"https://api.github.com/users/yexiaoli88/orgs","repos_url":"https://api.github.com/users/yexiaoli88/repos","events_url":"https://api.github.com/users/yexiaoli88/events{/privacy}","received_events_url":"https://api.github.com/users/yexiaoli88/received_events","type":"User","site_admin":false}],"milestone":{"url":"https://api.github.com/repos/actiontech/dble/milestones/13","html_url":"https://github.com/actiontech/dble/milestone/13","labels_url":"https://api.github.com/repos/actiontech/dble/milestones/13/labels","id":3603552,"node_id":"MDk6TWlsZXN0b25lMzYwMzU1Mg==","number":13,"title":"2.18.10.0","description":"","creator":{"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},"open_issues":4,"closed_issues":13,"state":"open","created_at":"2018-08-28T10:10:07Z","updated_at":"2018-09-18T02:11:01Z","due_on":null,"closed_at":null},"comments":2,"created_at":"2018-09-11T08:22:42Z","updated_at":"2018-09-18T02:11:01Z","closed_at":"2018-09-18T02:11:01Z","author_association":"COLLABORATOR","body":"* **dble version：5.6.29-dble-9.9.9.9-4ecbd6a-20180907104021**  \r\n* **preconditions ：**  \r\n```\r\ndrop table if exists test;\r\ncreate table test (id int ,name varchar(20));\r\ninsert into test values(1,'test1'),(2,'test2'),(3,'test3'),(4,'test4'),(8,'test8'),(9,'test9'),(10,'test10'),(11,'test11');\r\n```\r\n* **configs：** \r\n\r\n**schema.xml**  \r\n\r\n```\r\n<schema name=\"testdb\" dataNode=\"dn1\">\r\n     <table name=\"test\" dataNode=\"dn1,dn2,dn3,dn4\" rule=\"sharding-by-mod\" /> \r\n</schema>\r\n\r\n```\r\n\r\n**rule.xml**  \r\n\r\n```\r\n\r\n <tableRule name=\"sharding-by-mod\">\r\n        <rule>\r\n            <columns>id</columns>\r\n            <algorithm>hashmod</algorithm>\r\n        </rule>\r\n    </tableRule>\r\n<function name=\"hashmod\" class=\"Hash\">\r\n        <property name=\"partitionCount\">4</property>\r\n        <property name=\"partitionLength\">1</property>\r\n </function>\r\n\r\n```\r\n\r\n* **steps：**    \r\n1.execute hint sql in dble:\r\n```\r\nMySQL [testdb]>  /*!dble:sql = select * from test_not_exists where id = 200*/select * from test;\r\n+------+-------+\r\n| id   | name  |\r\n+------+-------+\r\n|    4 | test4 |\r\n|    8 | test8 |\r\n+------+-------+\r\n2 rows in set (0.04 sec)\r\n\r\n```\r\n* **real result：**  \r\n    1. step 1 return data which exists on default datanode\r\n"}}
{"actor":{"display_login":"yexiaoli88"}}