Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 65822 invoked from network); 27 Aug 2008 21:04:09 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 27 Aug 2008 21:04:09 -0000 Received: (qmail 74745 invoked by uid 500); 27 Aug 2008 21:04:03 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 74718 invoked by uid 500); 27 Aug 2008 21:04:03 -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 74706 invoked by uid 99); 27 Aug 2008 21:04:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2008 14:04:03 -0700 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.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 27 Aug 2008 21:03:14 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6ADB7234C1C2 for ; Wed, 27 Aug 2008 14:03:44 -0700 (PDT) Message-ID: <1871660097.1219871024436.JavaMail.jira@brutus> Date: Wed, 27 Aug 2008 14:03:44 -0700 (PDT) From: "Kim Haase (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3855) The Tuning guide should mention that LIKE transformations/optimizations are disabled when using territory-based collations In-Reply-To: <1170349535.1219774964359.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kim Haase updated DERBY-3855: ----------------------------- Attachment: rtuntransform208.html DERBY-3855.diff This seems like a fairly simple fix, Rick, with all the information you provided. Attaching DERBY-3855.diff and rtuntransform208.html, which I hope are correct. I added a cross-reference to the main information about territory-based collation in the Dev Guide. > The Tuning guide should mention that LIKE transformations/optimizations are disabled when using territory-based collations > -------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-3855 > URL: https://issues.apache.org/jira/browse/DERBY-3855 > Project: Derby > Issue Type: Improvement > Affects Versions: 10.3.3.0, 10.4.1.3, 10.5.0.0 > Reporter: Rick Hillegas > Assignee: Kim Haase > Attachments: DERBY-3855.diff, rtuntransform208.html > > > The Tuning Guide section titled "LIKE transformations" describes transformations and optimizations which Derby performs on LIKE expressions in order to avoid full table scans. These transformations/optimizations are disabled when using territory-based collations. See DERBY-3854. The Tuning Guide does not mention this fact but it is likely that this information would be very useful to customers and tech support engineers. The "LIKE transformations" section in the Tuning Guide should be changed to mention that LIKE transformations/optimizations are disabled when using territory-based collations. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.