{"issue":{"milestone":{"creator":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"49cb434238ae04c786eb888a33591ad6"},"title":"0.9.4 M1","open_issues":0,"created_at":"2011-12-29T23:55:07Z","state":"closed","due_on":null,"closed_issues":2,"number":4,"description":null,"url":"https://api.github.com/repos/Jach/testr/milestones/4"},"title":"[DDB-25] Create Table from Source Table UDP","created_at":"2011-12-29T23:57:08Z","user":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"49cb434238ae04c786eb888a33591ad6"},"updated_at":"2011-12-29T23:57:16Z","state":"closed","labels":[{"name":"UDR Library","url":"https://api.github.com/repos/Jach/testr/labels/UDR+Library","color":"ee3c4c"}],"id":2684104,"closed_at":"2011-12-29T23:57:09Z","html_url":"https://github.com/Jach/testr/issues/39","pull_request":{"patch_url":null,"html_url":null,"diff_url":null},"body":"[created=\"Sun, 14 Mar 2010 19:31:18 -0700\", resolved=\"Fri, 9 Apr 2010 06:10:03 -0700\"]\n<br /><br />\n<p>Create a UDP that will deduce, and optionally execute the DDL for a table.</p>\n\n        <p>call applib.CREATE_TABLE_FROM_SOURCE_TABLE ( source_table_or_view, target_schema, target_table_name, additional columns clause );</p>\n\n        <p>required:<br/>\n        source_table_or_view : the name of the source table, as a string.  Source Table can also be a fully qualified source table name \"server\".\"schema\".\"tableNAME\" or \"sCHemA\".\"tablE\"<br/>\n        target_table_name : the name, case sensitive, of the target table name</p>\n\n        <p>optional:<br/>\n        target_schema - the schema to create the new table in.  If null use the schema on the calling connection.<br/>\n        additional_columns_clause : a string with any additional column defintions to be present.  'ename VARCHAR(128) NOT NULL, dname VARCHAR(128) NOT NULL' will create the table as originally defined, and with the additional columns</p>\n\n        <p>test plan:<br/>\n        test to make sure datatypes, precision match (varchar(128) = varchar(128))<br/>\n        test to make sure it works with tables and views<br/>\n        test to make sure that it works with remote tables<br/>\n        test to make sure errors are thrown when:</p>\n        <ul class=\"alternate\" type=\"square\">\n        <li>Table already exists</li>\n        <li>additional columns clause is invalid</li>\n        <li>additional columns clause contains another column already in the table</li>\n        </ul>\n\n\n      ","number":39,"url":"https://api.github.com/repos/Jach/testr/issues/39","comments":7,"assignee":null},"comment":{"created_at":"2011-12-29T23:57:16Z","user":{"login":"Jach","id":159184,"url":"https://api.github.com/users/Jach","avatar_url":"https://secure.gravatar.com/avatar/49cb434238ae04c786eb888a33591ad6?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"49cb434238ae04c786eb888a33591ad6"},"updated_at":"2011-12-29T23:57:16Z","id":3306848,"body":"[author=\"rzhang\", created=\"Thu, 18 Mar 2010 00:17:55 -0700\"]\n<br /><br />\n<p>Please refer to changlist# 13492.</p>\n\n          <p>One issue.<br/>\n          Server and remote tables.<br/>\n          In fact, I understand these concepts in luciddb.<br/>\n          Can you explain them with example as you answer my question above?<br/>\n          TODO.<br/>\n          Support Server.$schema.$table or remote tables.</p>\n\n          <p>You can kick off testing on <a href=\"https://studio.dynamobi.com/browse/DDB-25\" title=\"Create Table from Source Table UDP\"><del>DDB-25</del></a><br/>\n          Any feedback or advice is welcome.</p>","url":"https://api.github.com/repos/Jach/testr/issues/comments/3306848"},"action":"created"}