db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <Dag.Wan...@Sun.COM>
Subject Re: [jira] Commented: (DERBY-165) Droppping columns with ALTER TABLE errors out
Date Wed, 06 Jul 2005 12:51:40 GMT

Hi Shreyas,

Derby does not support dropping columns, cf
http://incubator.apache.org/derby/docs/ref/rrefsqlj81859.html.

I think it would be desirable if the parser recognized it and gave a suitable
message, though.

Dag

>>>>> "SK(" == Shreyas Kaushik (JIRA) <derby-dev@db.apache.org> wrote:
SK(> 
SK(>     [ http://issues.apache.org/jira/browse/DERBY-165?page=comments#action_12315131
] 
SK(> Shreyas Kaushik commented on DERBY-165:
SK(> ---------------------------------------
SK(> 
SK(> What should be the expected behaviour for this? Is this documented in the SQL spec.
I don't have a copy of that.
SK(> 
SK(> 
SK(> > Droppping columns with ALTER TABLE errors out
SK(> > ---------------------------------------------
SK(> >
SK(> >          Key: DERBY-165
SK(> >          URL: http://issues.apache.org/jira/browse/DERBY-165
SK(> >      Project: Derby
SK(> >         Type: New Feature
SK(> >   Components: SQL
SK(> >  Environment: Linux
SK(> >     Reporter: Shreyas Kaushik
SK(> >     Priority: Minor
SK(> 
SK(> >
SK(> > When I try to drop columns using ALTER TABLE command I get the following error,
irrespective of me using "column" keyword in addition to the drop keyword.
SK(> > ----------------------ERROR REPORT-------------------------------------------
SK(> > ij> alter table test_linux drop column dept;
SK(> > ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
SK(> > ij> alter table test_linux drop dept;
SK(> > ERROR 42X01: Syntax error: Encountered "drop" at line 1, column 24.
SK(> > ----------------------ERROR REPORT-------------------------------------------
SK(> 
SK(> -- 
SK(> This message is automatically generated by JIRA.
SK(> -
SK(> If you think it was sent incorrectly contact one of the administrators:
SK(>    http://issues.apache.org/jira/secure/Administrators.jspa
SK(> -
SK(> For more information on JIRA, see:
SK(>    http://www.atlassian.com/software/jira
SK(> 
-- 
Dag H. Wanvik
Sun Microsystems, Web Services, Database Technology Group
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 
NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recipient, please contact
the sender by reply email and destroy all copies of the original
message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 

Mime
View raw message