Apache Derby - 35
Schema APP
Tables -- AIRLINE
Try to rename column AIRLINEID to a new name. Under Preview SQL only GO is displayed and renaming doesnt occur for INTEGER column
Apache Derby APP schema
Table fancy_table. Rename Column col1 which is an integer field. ADS displays error
Column rename related code for Apache Derby was put in a wrong block which will not get executed for column with integer type. Fixed the problem by removing rename code block to the right place.
Also fixed 'undo rename' problem as described below:
. in the General tab - rename column 'clm_1' to 'clm_1_new',
. click the Preview tab - correct SQL generated for renaming 'clm_1',
. go back to the General tab - rename 'clm_1_new' back to 'clm_1'
. click the Preview tab again - a single 'GO' statement generated (should be NO Changes)
Changes checked into SVN as #7537 of trunk/ADS.
Column rename related code for Apache Derby was put in a wrong block which will not get executed for column with integer type. Fixed the problem by removing rename code block to the right place.
Also fixed 'undo rename' problem as described below:
. in the General tab - rename column 'clm_1' to 'clm_1_new',
. click the Preview tab - correct SQL generated for renaming 'clm_1',
. go back to the General tab - rename 'clm_1_new' back to 'clm_1'
. click the Preview tab again - a single 'GO' statement generated (should be NO Changes)
Changes checked into SVN as #7537 of trunk/ADS.
Issue #2225 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Apache Derby APP schema
Table fancy_table. Rename Column col1 which is an integer field. ADS displays error