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: 3, SQL State: 42X01] Syntax error: Encountered column at
ine 1, column 8.
Although this feature is
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!
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.
[slap-on-forehead]
Thanks for the hint.
I'm wondering, that such a fundamental feature is not yet available in the
latest release. I
sorry,
my fault. i was looking at the same time the latest alpha version of the
documentation that includes column renaming, but 10.2 not.
http://db.apache.org/derby/docs/dev/ref/ref-single.html#crefsqljrenamestatements
then why it's described in the reference manual
I was recently extremely disappointed and annoyed too, as I could not
believe, that such a fundamental feature is missing; what's even worse
is the fact, that deleting of rows is not possible (can you imagine
that, when you worked with mySQL, PostgreSQL, hsqldb, ... before??) and
so on.
I
Stanley Bradbury wrote:
Ralf Wiebicke wrote:
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.
Hi Ralf -
I'm glad to see that you are taking Derby for a test drive. Being
included
Paul J DeCoursey wrote:
I personally don't mind the limitations and sometimes welcome them.
They force me to be more forward thinking in my db design. And for
most things Derby is perfect, I use it most often for quick
prototyping and proof of concept builds. Then when it comes time to
Alexander Schatten wrote on 29.12.2006 17:21:
I was recently extremely disappointed and annoyed too, as I could not
believe, that such a fundamental feature is missing; what's even worse
is the fact, that deleting of rows is not possible (can you imagine
that, when you worked with mySQL,
On 12/29/06, Ralf Wiebicke [EMAIL PROTECTED] wrote:
I'm wondering, that such a fundamental feature is not yet available in the
latest release. I noticed derby, because its included in Java 6. So I
thought, it's mature enough to support it in my project. All other databases
I use do support