Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 12709 invoked from network); 27 Mar 2007 21:38:38 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 27 Mar 2007 21:38:38 -0000 Received: (qmail 56785 invoked by uid 500); 27 Mar 2007 21:38:45 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 56756 invoked by uid 500); 27 Mar 2007 21:38:45 -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 56747 invoked by uid 99); 27 Mar 2007 21:38:44 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Mar 2007 14:38:44 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UNPARSEABLE_RELAY X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy) Received: from [192.18.1.36] (HELO gmp-ea-fw-1.sun.com) (192.18.1.36) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 27 Mar 2007 14:38:36 -0700 Received: from d1-emea-09.sun.com (d1-emea-09.sun.com [192.18.2.119]) by gmp-ea-fw-1.sun.com (8.13.6+Sun/8.12.9) with ESMTP id l2RLcFJH002580 for ; Tue, 27 Mar 2007 21:38:15 GMT Received: from conversion-daemon.d1-emea-09.sun.com by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) id <0JFL00401016BE00@d1-emea-09.sun.com> (original mail from Dag.Wanvik@Sun.COM) for derby-dev@db.apache.org; Tue, 27 Mar 2007 22:38:15 +0100 (BST) Received: from khepri05.norway.sun.com ([129.159.112.194]) by d1-emea-09.sun.com (Sun Java System Messaging Server 6.2-6.01 (built Apr 3 2006)) with ESMTPSA id <0JFL003UR03QQI50@d1-emea-09.sun.com> for derby-dev@db.apache.org; Tue, 27 Mar 2007 22:38:15 +0100 (BST) Date: Tue, 27 Mar 2007 23:38:14 +0200 From: Dag.Wanvik@Sun.COM (Dag H. Wanvik) Subject: Re: [jira] Commented: (DERBY-1949) locate function returns invalid value when first parameter is empty string In-reply-to: <27025569.1175029772735.JavaMail.jira@brutus> Sender: Dag.Wanvik@Sun.COM To: derby-dev@db.apache.org Message-id: MIME-version: 1.0 Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT References: <27025569.1175029772735.JavaMail.jira@brutus> User-Agent: Gnus/5.1008 (Gnus v5.10.8) Emacs/22.0.50 (usg-unix-v) X-Virus-Checked: Checked by ClamAV on apache.org "Bryan Pendleton (JIRA)" writes: > [ https://issues.apache.org/jira/browse/DERBY-1949?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12484594 ] > > Bryan Pendleton commented on DERBY-1949: > ---------------------------------------- > >> which operand is which > > Thanks Army, I believe you are exactly right. The documentation does not make it clear > which operand is which, and other databases appear to take the arguments in the other > order. For example, here's a reference to Sybase which appears to process the arguments > in the opposite order from Derby: > http://manuals.sybase.com/onlinebooks/group-iq/iqg1250e/iqref/@Generic__BookTextView/34859;pt=33287 > > It's also interesting that the Sybase documentation explicitly says: > "Searching for a zero-length string will return 1." > > I propose to update the documentation to make it clear which argument is which in > the LOCATE function, and also to note that searching for a zero-length string returns 1. This seems right to me, including in the ('', '') case. +1 Dag