{"action":"created","issue":{"url":"https://api.github.com/repos/ADBSQL/AntDB/issues/37","repository_url":"https://api.github.com/repos/ADBSQL/AntDB","labels_url":"https://api.github.com/repos/ADBSQL/AntDB/issues/37/labels{/name}","comments_url":"https://api.github.com/repos/ADBSQL/AntDB/issues/37/comments","events_url":"https://api.github.com/repos/ADBSQL/AntDB/issues/37/events","html_url":"https://github.com/ADBSQL/AntDB/issues/37","id":280904592,"number":37,"title":"从父表中删除数据报错“diffent TupleDesc of number attribute”","user":{"login":"mass3","id":19543186,"avatar_url":"https://avatars0.githubusercontent.com/u/19543186?v=4","gravatar_id":"","url":"https://api.github.com/users/mass3","html_url":"https://github.com/mass3","followers_url":"https://api.github.com/users/mass3/followers","following_url":"https://api.github.com/users/mass3/following{/other_user}","gists_url":"https://api.github.com/users/mass3/gists{/gist_id}","starred_url":"https://api.github.com/users/mass3/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mass3/subscriptions","organizations_url":"https://api.github.com/users/mass3/orgs","repos_url":"https://api.github.com/users/mass3/repos","events_url":"https://api.github.com/users/mass3/events{/privacy}","received_events_url":"https://api.github.com/users/mass3/received_events","type":"User","site_admin":false},"labels":[{"id":770920106,"url":"https://api.github.com/repos/ADBSQL/AntDB/labels/ADB_3.1","name":"ADB_3.1","color":"d4c5f9","default":false},{"id":724405560,"url":"https://api.github.com/repos/ADBSQL/AntDB/labels/bug","name":"bug","color":"ee0701","default":true}],"state":"closed","locked":false,"assignee":{"login":"constzl","id":32921993,"avatar_url":"https://avatars0.githubusercontent.com/u/32921993?v=4","gravatar_id":"","url":"https://api.github.com/users/constzl","html_url":"https://github.com/constzl","followers_url":"https://api.github.com/users/constzl/followers","following_url":"https://api.github.com/users/constzl/following{/other_user}","gists_url":"https://api.github.com/users/constzl/gists{/gist_id}","starred_url":"https://api.github.com/users/constzl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/constzl/subscriptions","organizations_url":"https://api.github.com/users/constzl/orgs","repos_url":"https://api.github.com/users/constzl/repos","events_url":"https://api.github.com/users/constzl/events{/privacy}","received_events_url":"https://api.github.com/users/constzl/received_events","type":"User","site_admin":false},"assignees":[{"login":"constzl","id":32921993,"avatar_url":"https://avatars0.githubusercontent.com/u/32921993?v=4","gravatar_id":"","url":"https://api.github.com/users/constzl","html_url":"https://github.com/constzl","followers_url":"https://api.github.com/users/constzl/followers","following_url":"https://api.github.com/users/constzl/following{/other_user}","gists_url":"https://api.github.com/users/constzl/gists{/gist_id}","starred_url":"https://api.github.com/users/constzl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/constzl/subscriptions","organizations_url":"https://api.github.com/users/constzl/orgs","repos_url":"https://api.github.com/users/constzl/repos","events_url":"https://api.github.com/users/constzl/events{/privacy}","received_events_url":"https://api.github.com/users/constzl/received_events","type":"User","site_admin":false}],"milestone":null,"comments":0,"created_at":"2017-12-11T06:13:59Z","updated_at":"2017-12-11T10:07:44Z","closed_at":"2017-12-11T10:07:44Z","author_association":"MEMBER","body":"### 从父表中删除数据报“ERROR:  diffent TupleDesc of number attribute”\r\n```\r\npostgres=# DELETE FROM fp where f1 < 2 returning *, f3-f1;\r\nERROR:  diffent TupleDesc of number attribute\r\nDETAIL:  local is 3, remote is 4\r\npostgres=# \r\n```\r\n### 测试sql：\r\n```\r\ncreate table fp(f1 int, f2 varchar(255), f3 int);\r\ncreate table fp_child (fc int) INHERITS (fp);\r\nALTER table fp ADD COLUMN f4 int8 DEFAULT 99;\r\nINSERT INTO fp VALUES (1,'test',42), (2,'More', 11), (3,upper('more'), 7+9);\r\nINSERT INTO fp_child VALUES(123,'child',999,-123);\r\nINSERT INTO fp_child VALUES(456,'child',999,-456);\r\nUPDATE fp SET f4 = f4 + f3 WHERE f4 = 99;\r\nDELETE FROM fp_child where fc = -123 returning *, f4-f1;\r\nDELETE FROM fp where f1 < 2 returning *, f3-f1;\r\n```"},"comment":{"url":"https://api.github.com/repos/ADBSQL/AntDB/issues/comments/350678419","html_url":"https://github.com/ADBSQL/AntDB/issues/37#issuecomment-350678419","issue_url":"https://api.github.com/repos/ADBSQL/AntDB/issues/37","id":350678419,"user":{"login":"constzl","id":32921993,"avatar_url":"https://avatars0.githubusercontent.com/u/32921993?v=4","gravatar_id":"","url":"https://api.github.com/users/constzl","html_url":"https://github.com/constzl","followers_url":"https://api.github.com/users/constzl/followers","following_url":"https://api.github.com/users/constzl/following{/other_user}","gists_url":"https://api.github.com/users/constzl/gists{/gist_id}","starred_url":"https://api.github.com/users/constzl/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/constzl/subscriptions","organizations_url":"https://api.github.com/users/constzl/orgs","repos_url":"https://api.github.com/users/constzl/repos","events_url":"https://api.github.com/users/constzl/events{/privacy}","received_events_url":"https://api.github.com/users/constzl/received_events","type":"User","site_admin":false},"created_at":"2017-12-11T10:07:44Z","updated_at":"2017-12-11T10:07:44Z","author_association":"NONE","body":"已经修正该问题。\r\n\r\ncommit f331187ccaed52ef5756d4ee33a4157b7a05c097\r\nAuthor: zhangliang10 <zhangliang10@asiainfo.com>\r\nDate:   Mon Dec 11 18:06:45 2017 +0800\r\n\r\n    修正 bug #37:从父表中删除数据报\"ERROR: diffent TupleDesc of number attribute\".\r\n    \r\n    原因：\r\n        FetchRemoteQuery 函数在获取一条slot时，没有检查当前handle是否可直接使用。\r\n    \r\n    Notes:\r\n        由于每个NodeHandle可能在各个RemoteQuery之间切换使用，正确的处理NodeHandle的owner变的尤为重要。"}}
{"actor":{"display_login":"constzl"}}