Re: [jira] Commented: (DERBY-716) Re-enable VTIs

[Army]

Dag H. Wanvik wrote:

  ij> create table st as select * from
         table (syscs_diag.space_table('T1')) s with no data;

Is this form documented anywhere? I can see it in the grammar, but I
can't find it anywhere in the docs. Omission?

Not sure if you are referring to the SYSCS_DIAG.SPACE_TABLE syntax or the 
"create table AS ... with no data" option...

Rick just posted about the diagnostic syntax.  The CREATE TABLE AS ... syntax 
was added in 10.3 as part of DERBY-64.  But it looks like there was no 
corresponding documentation.  If nothing exists in the current documentation 
then I guess a new Jira should be opened for this...?

Army