{"action":"closed","issue":{"url":"https://api.github.com/repos/actiontech/dble/issues/649","repository_url":"https://api.github.com/repos/actiontech/dble","labels_url":"https://api.github.com/repos/actiontech/dble/issues/649/labels{/name}","comments_url":"https://api.github.com/repos/actiontech/dble/issues/649/comments","events_url":"https://api.github.com/repos/actiontech/dble/issues/649/events","html_url":"https://github.com/actiontech/dble/issues/649","id":351105143,"node_id":"MDU6SXNzdWUzNTExMDUxNDM=","number":649,"title":"DDL with hint execute Error","user":{"login":"sunsun314","id":7465154,"node_id":"MDQ6VXNlcjc0NjUxNTQ=","avatar_url":"https://avatars3.githubusercontent.com/u/7465154?v=4","gravatar_id":"","url":"https://api.github.com/users/sunsun314","html_url":"https://github.com/sunsun314","followers_url":"https://api.github.com/users/sunsun314/followers","following_url":"https://api.github.com/users/sunsun314/following{/other_user}","gists_url":"https://api.github.com/users/sunsun314/gists{/gist_id}","starred_url":"https://api.github.com/users/sunsun314/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sunsun314/subscriptions","organizations_url":"https://api.github.com/users/sunsun314/orgs","repos_url":"https://api.github.com/users/sunsun314/repos","events_url":"https://api.github.com/users/sunsun314/events{/privacy}","received_events_url":"https://api.github.com/users/sunsun314/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},{"id":943060629,"node_id":"MDU6TGFiZWw5NDMwNjA2Mjk=","url":"https://api.github.com/repos/actiontech/dble/labels/resolve","name":"resolve","color":"fbca04","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":3,"closed_issues":16,"state":"open","created_at":"2018-08-28T10:10:07Z","updated_at":"2018-09-19T07:08:23Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2018-08-16T08:27:20Z","updated_at":"2018-09-19T07:08:23Z","closed_at":"2018-09-19T07:08:22Z","author_association":"COLLABORATOR","body":"* **dble version：**  07.2\r\n* **preconditions ：**  \r\nno\r\n* **configs：** \r\n\r\n**schema.xml**  \r\n\r\n```\r\n<?xml version=\"1.0\"?>\r\n<!DOCTYPE dble:schema SYSTEM \"schema.dtd\">\r\n<dble:schema xmlns:dble=\"http://dble.cloud/\">\r\n\r\n    <schema name=\"TESTDB\" dataNode=\"dn1\" >\r\n    \t  <table name=\"test_s\" dataNode=\"dn1,dn2\" rule=\"sharding-by-hash2\" />\r\n        <table name=\"test_a\" primaryKey=\"ID\" dataNode=\"dn1,dn2,dn3,dn4\" type=\"global\" />\r\n        <table name=\"test_b\" primaryKey=\"ID\" dataNode=\"dn1,dn2,dn3,dn4\" type=\"global\" />\r\n    </schema>\r\n    <!-- <dataNode name=\"dn1$0-743\" dataHost=\"localhost1\" database=\"db$0-743\"\r\n        /> -->\r\n    <dataNode name=\"dn1\" dataHost=\"localhost1\" database=\"db1\"/>\r\n    <dataNode name=\"dn2\" dataHost=\"localhost1\" database=\"db2\"/>\r\n    <dataNode name=\"dn3\" dataHost=\"localhost2\" database=\"db3\"/>\r\n    <dataNode name=\"dn4\" dataHost=\"localhost2\" database=\"db4\"/>\r\n    <dataHost name=\"localhost1\" maxCon=\"20\" minCon=\"1\" balance=\"0\" switchType=\"1\" slaveThreshold=\"100\">\r\n        <heartbeat>select user()</heartbeat>\r\n        <!-- can have multi write hosts -->\r\n        <writeHost host=\"hostM1\" url=\"10.186.24.37:3306\" user=\"root\"\r\n                   password=\"123456\">\r\n        </writeHost>\r\n    </dataHost>\r\n    <dataHost name=\"localhost2\" maxCon=\"20\" minCon=\"1\" balance=\"0\" switchType=\"1\" slaveThreshold=\"100\">\r\n        <heartbeat>select user()</heartbeat>\r\n        <!-- can have multi write hosts -->\r\n        <writeHost host=\"hostM1\" url=\"10.186.24.37:3399\" user=\"root\"\r\n                   password=\"123456\">\r\n        </writeHost>\r\n    </dataHost>\r\n</dble:schema>\r\n```\r\n\r\n**rule.xml**  \r\ndefault config\r\n\r\n**server.xml**  \r\ndefault config\r\n\r\n* **steps：**    \r\n  execute  /*!dble:datanode=dn1*/truncate table test_s;\r\n* **expect result：**  \r\nreturn OK and result right\r\n* **real result：**  \r\nERROR 1064 (HY000): NullPointerException\r\n* **supplements：**  \r\nCause by DDL with hint ,hint RouteResultSet has no schema or table info,when try to lock the table this error occur\r\n/label ~BUG\r\n"}}
{"actor":{"display_login":"yexiaoli88"}}