Return-Path: Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: (qmail 66036 invoked from network); 8 Nov 2009 11:36:55 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 8 Nov 2009 11:36:55 -0000 Received: (qmail 45577 invoked by uid 500); 8 Nov 2009 11:36:55 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 45524 invoked by uid 500); 8 Nov 2009 11:36:55 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 45512 invoked by uid 99); 8 Nov 2009 11:36:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 08 Nov 2009 11:36:55 +0000 X-ASF-Spam-Status: No, hits=-10.5 required=5.0 tests=AWL,BAYES_00,RCVD_IN_DNSWL_HI X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 08 Nov 2009 11:36:52 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 5BA57234C045 for ; Sun, 8 Nov 2009 03:36:32 -0800 (PST) Message-ID: <1804713023.1257680192361.JavaMail.jira@brutus> Date: Sun, 8 Nov 2009 11:36:32 +0000 (UTC) From: "Thomas Fischer (JIRA)" To: torque-dev@db.apache.org Subject: [jira] Created: (TORQUE-130) remove the heavyIndexing attribute of the table element MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 remove the heavyIndexing attribute of the table element ------------------------------------------------------- Key: TORQUE-130 URL: https://issues.apache.org/jira/browse/TORQUE-130 Project: Torque Issue Type: Sub-task Components: Generator Affects Versions: 4.0 Reporter: Thomas Fischer >From reading the source code (Table.doHeavyIndexing() in the generator), the heavy-indexing attribute of the table should create an index for every column for a composite primary key. It has the following flaws in 3.3: - It is not documented what the attribute does. - It currently does not work correctly. The first column of the composite primary key is left out (and the comment in the code why this is done is incorrect, because the database will automatically create a composite index for the combined columns, not an index for the first column). - It would be much more transparent to list the indexed columns as . Therefore I propose to remove this attribute from the 4.0 schema without replacement. This would not remove any functionality. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org