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) <[email protected]> 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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
