Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (herse.apache.org: domain of m96@gmx.li designates
 213.165.64.20 as permitted sender)
Subject: Re: renaming columns
From: m96 <m96@gmx.li>
To: Derby Discussion <derby-user@db.apache.org>
In-Reply-To: <4595088F.5010804@sun.com>
References: <200612291239.14515.ralf.wiebicke@exedio.com>
	 <4595088F.5010804@sun.com>
Content-Type: text/plain; charset=ISO-8859-1
Date: Fri, 29 Dec 2006 13:31:27 +0100
Message-Id: <1167395487.3299.124.camel@localhost>
Mime-Version: 1.0
Content-Transfer-Encoding: 8bit

hi,

then why it's described in the reference manual
http://db.apache.org/derby/docs/10.2/ref/ref-single.html#crefsqljrenamestatements

btw: it doesn't work for me either...
i'm using also 10.2.2.0

cheers.


On Fri, 2006-12-29 at 13:22 +0100, �ystein Gr�vlen wrote:
> Ralf Wiebicke wrote:
> > Hi!
> > 
> > I try to rename a column using the following statements:
> > 
> > create table t (a int)
> > rename column t.a to b
> > 
> > The second statement throws an exception:
> > 
> >  [Error Code: 30000, SQL State: 42X01]  Syntax error: Encountered "column" at 
> > ine 1, column 8.
> > 
> > Although this feature is not yet documented, according to this bug entry:
> > 
> > http://issues.apache.org/jira/browse/DERBY-1490
> > 
> > this should work since subversion revision 472708. I'm using 
> > version "10.2.2.0 - (485682)" which is later. When I look at the diff for 
> > revision 472708, this seems to be, what I want.
> > 
> > Any ideas?
> 
> The release note for 10.2 does not mention that rename column has been 
> added.
> 
> Note that 10.2.2 is made from another svn branch than the development 
> branch (trunk).  Revision numbers on different branches are not directly 
> comparable.
> 
> --
> �ystein