Return-Path: Delivered-To: apmail-db-ddlutils-dev-archive@www.apache.org Received: (qmail 31877 invoked from network); 3 Dec 2010 06:14:37 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 Dec 2010 06:14:37 -0000 Received: (qmail 16572 invoked by uid 500); 3 Dec 2010 06:14:37 -0000 Delivered-To: apmail-db-ddlutils-dev-archive@db.apache.org Received: (qmail 16497 invoked by uid 500); 3 Dec 2010 06:14:35 -0000 Mailing-List: contact ddlutils-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ddlutils-dev@db.apache.org Delivered-To: mailing list ddlutils-dev@db.apache.org Received: (qmail 16489 invoked by uid 99); 3 Dec 2010 06:14:35 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Dec 2010 06:14:34 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.22] (HELO thor.apache.org) (140.211.11.22) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 03 Dec 2010 06:14:32 +0000 Received: from thor (localhost [127.0.0.1]) by thor.apache.org (8.13.8+Sun/8.13.8) with ESMTP id oB36EA8w020965 for ; Fri, 3 Dec 2010 06:14:11 GMT Message-ID: <23417757.89641291356850600.JavaMail.jira@thor> Date: Fri, 3 Dec 2010 01:14:10 -0500 (EST) From: "fengrunlzk (JIRA)" To: ddlutils-dev@db.apache.org Subject: [jira] Created: (DDLUTILS-267) Modify source database a column from nvarchar(1) to nvarchar(10), Platform.alterTables did not modify target database table column. MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org Modify source database a column from nvarchar(1) to nvarchar(10), Platform.= alterTables did not modify target database table column. ---------------------------------------------------------------------------= -------------------------------------------------------- Key: DDLUTILS-267 URL: https://issues.apache.org/jira/browse/DDLUTILS-267 Project: DdlUtils Issue Type: Bug Components: Core - SqlServer Affects Versions: 1.0 Environment: sql server 2000 Reporter: fengrunlzk Assignee: Thomas Dudziak Modify source database a column from nvarchar(1) to nvarchar(10), Platform.= alterTables did not modify target database table column to nvarchar(10) . And remove source database a column that has default value, Platform.alterT= ables target database throw exception : Exception in thread "main" org.apache.ddlutils.DatabaseOperationException: = Error while executing SQL ALTER TABLE acct_analysis_tab DROP COLUMN is_stop =09at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformI= mplBase.java:331) =09at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImp= lBase.java:573) =09at org.apache.ddlutils.platform.PlatformImplBase.alterTables(PlatformImp= lBase.java:507) =09at test.M.main(M.java:36) Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: object 'DF__acc= t_anal__is_st__7E6CC920' depends column 'is_stop'=E3=80=82 =09at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError= (SQLServerException.java:196) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServ= erStatement.java:1454) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQ= LServerStatement.java:786) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute= (SQLServerStatement.java:685) =09at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:4026) =09at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLSe= rverConnection.java:1416) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLSer= verStatement.java:185) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLS= erverStatement.java:160) =09at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServ= erStatement.java:642) =09at org.apache.commons.dbcp.DelegatingStatement.executeUpdate(DelegatingS= tatement.java:225) =09at org.apache.ddlutils.platform.PlatformImplBase.evaluateBatch(PlatformI= mplBase.java:309) --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.