db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dag.Wan...@Sun.COM (Dag H. Wanvik)
Subject Re: [jira] Commented: (DERBY-1949) locate function returns invalid value when first parameter is empty string
Date Tue, 27 Mar 2007 21:38:14 GMT
"Bryan Pendleton (JIRA)" <jira@apache.org> 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

Mime
View raw message