Return-Path: X-Original-To: apmail-db-derby-dev-archive@www.apache.org Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 4810510AC1 for ; Thu, 11 Apr 2013 14:45:16 +0000 (UTC) Received: (qmail 32697 invoked by uid 500); 11 Apr 2013 14:45:16 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 32684 invoked by uid 500); 11 Apr 2013 14:45:16 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 32674 invoked by uid 99); 11 Apr 2013 14:45:16 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Apr 2013 14:45:16 +0000 Date: Thu, 11 Apr 2013 14:45:16 +0000 (UTC) From: "Kim Haase (JIRA)" To: derby-dev@db.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Reopened] (DERBY-6129) Reference Manual gives incorrect datatype for SYSCOLUMNS.COLUMNNAME MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/DERBY-6129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase reopened DERBY-6129: ------------------------------ Reopening to merge to 10.9 branch. > Reference Manual gives incorrect datatype for SYSCOLUMNS.COLUMNNAME > ------------------------------------------------------------------- > > Key: DERBY-6129 > URL: https://issues.apache.org/jira/browse/DERBY-6129 > Project: Derby > Issue Type: Bug > Components: Documentation > Affects Versions: 10.10.1.1 > Reporter: Rick Hillegas > Assignee: Kim Haase > Fix For: 10.10.1.2 > > Attachments: DERBY-6129.diff, DERBY-6129.stat, DERBY-6129.zip, systables.txt > > > The Reference Manual says that SYSCOLUMNS.COLUMNNAME has datatype CHAR(128). It's actual datatype is VARCHAR(128). It's probably worth running the following script to confirm the datatypes of all catalog columns described by the Reference Manual: > connect 'jdbc:derby:memory:db;create=true'; > select cast(t.tablename as varchar( 20 )), cast(c.columnname as varchar(20)), c.columndatatype > from sys.syscolumns c, sys.systables t > where t.tablename like 'SYS%' > and t.tableid = c.referenceid > order by t.tablename, c.columnname; -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira