db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From m96 <...@gmx.li>
Subject Re: renaming columns
Date Fri, 29 Dec 2006 12:31:27 GMT
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


Mime
View raw message