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

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

A B,

Thank you for reviewing and committing the latest patch.

I would like to work on the "WITH DATA" option.  I assume I will need to modify 
CreateTableConstantAction to load the data obtained via the query expression 
after the conglomerate is created.  I am not at all familiar with this area of 
the code so any guidance would be greatly appreciated.

> 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