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