Andrew McIntyre wrote:
After Derby was open sourced, rename and drop of columns quickly
became one of the most voted for items in JIRA, probably because most
other database systems support it. A volunteer chipped in and now both
rename and drop have been reimplemented in the trunk (thanks,
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!
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 renaming columns. I'm not yet sure, whether I want to work
around this problem, or wait for the next release.
Best regards,
Ralf.
/derby/docs/10.2/ref/ref-single.html#crefsqljrenamestat
ements
This link does not describe renaming columns, but tables and indexes.
Renaming
tables works for me.
cheers.
, 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 renaming columns. I'm not yet sure, whether I want to work
around this problem, or wait for the next release.
Best regards,
Ralf.
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,
renaming columns. I'm not yet sure, whether I want to work
around this problem, or wait for the next release.
Before the decision to open source Cloudscape as Derby had been made,
an effort was already underway to make its SQL syntax more compatible
with DB2 UDB. The DB2 UDB version which was current
10 matches
Mail list logo