10.2.1.3 beta candidate now available

[Rick Hillegas <Ri...@Sun.COM>]

I have rolled up this week's patches into a new beta candidate, 
10.2.1.3. As usual, you can navigate to the beta in the following ways:

1) from the master 10.2 release page 
(http://wiki.apache.org/db-derby/TenTwoRelease)
2) from the snapshot discription page 
(http://wiki.apache.org/db-derby/TenTwoSnapshot)
3) directly from http://people.apache.org/~rhillegas/10.2.1.3-beta/

This new beta includes more grant/revoke fixes plus new ALTER TABLE 
capabilities. Thanks to everyone for your hard work testing and 
improving this beta candidate.

Please test-drive the improved distribution.

Regards,
-Rick

Re: ALTER TABLE changes in 10.2.1.3

[Bryan Pendleton <bp...@amberpoint.com>]

Stephen Caine wrote:
> Is dropping a column now supported in 10.2.1.3?

Hi Stephen, thanks for trying the beta!

The ALTER COLUMN changes in this beta are DERBY-119 and DERBY-1491,
which allow you to do:

   ALTER TABLE t ALTER COLUMN c [ NOT ] NULL
      This lets you add or remove the NOT NULL constraint on a column
   ALTER TABLE t ALTER COLUMN c [ WITH ] DEFAULT default-value
      This lets you change the default value for a column

Dropping a column is DERBY-1489, which is getting closer to being
ready to commit, but is not there yet.

You might want to register yourself as a "watcher" on DERBY-1489
to keep better track on its progress:
http://issues.apache.org/jira/browse/DERBY-1489

thanks,

bryan

Re: 10.2.1.3 beta candidate now available

[Stephen Caine <st...@commongrnd.com>]

Rick,

Is dropping a column now supported in 10.2.1.3?

When I tried this, I got an error:

ALTER TABLE %@ DROP COLUMN "%@"
ALTER TABLE QILAN."company" DROP COLUMN "test_column"
Syntax error: Encountered "DROP" at line 1, column 29.

Stephen Caine
Soft Breeze Systems, LLC