db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Army <qoz...@gmail.com>
Subject Re: [jira] Commented: (DERBY-716) Re-enable VTIs
Date Wed, 25 Apr 2007 23:26:39 GMT
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


Mime
View raw message