[ 
https://issues.apache.org/jira/browse/DERBY-64?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12463906
 ] 

James F. Adams commented on DERBY-64:
-------------------------------------

I have attached an updated patch (Derby64Patch4.txt) that should address the 
comments on my previous effort.

The tests have been re-implemented as JUnit tests.
I added code to verify that the created tables have the correct column names, 
types, and nullability.
I modified the changes I made to CreateTableNode.java and sqlgrammar.jj so none 
of the added/modified lines are longer than 80 characters.

> Create a table with a query
> ---------------------------
>
>                 Key: DERBY-64
>                 URL: https://issues.apache.org/jira/browse/DERBY-64
>             Project: Derby
>          Issue Type: New Feature
>          Components: SQL
>            Reporter: Christian d'Heureuse
>         Assigned To: James F. Adams
>         Attachments: Derby64Patch1.txt, Derby64Patch2.txt, Derby64Patch3.txt, 
> Derby64Patch4.txt
>
>
> I suggest to implement a SQL statement to create and fill a table with a 
> query, without having to write the columns definition.
> e.g.:
>  CREATE TABLE new_table AS SELECT ...;
> or:
>  SELECT ... INTO new_table FROM ...;

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Reply via email to