db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bryan Pendleton (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-1949) locate function returns invalid value when first parameter is empty string
Date Wed, 28 Mar 2007 17:07:25 GMT

     [ https://issues.apache.org/jira/browse/DERBY-1949?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Bryan Pendleton updated DERBY-1949:
-----------------------------------

    Attachment: rrefsqlj61998.html
                docs_v2.diff

Thanks Oleksandr for the review and good examples. And thanks
Kristian for pointing out the code comment that makes it clear
that this is intentional behavior in the code, to match DB2's behavior.

Attached is docs_v2.diff, updated to incorporate Oleksandr's
suggestions and examples, and an updated version of the
HTML-formatted ref page for easier review.


> locate function returns invalid value when first parameter is empty string
> --------------------------------------------------------------------------
>
>                 Key: DERBY-1949
>                 URL: https://issues.apache.org/jira/browse/DERBY-1949
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.1.3.1, 10.2.1.6
>         Environment: N/A
>            Reporter: Oleksandr Alesinskyy
>         Assigned To: Bryan Pendleton
>         Attachments: docs.diff, docs_v2.diff, rrefsqlj61998.html, rrefsqlj61998.html
>
>
> locate function returns false invalid when first parameter is empty string,
> e.g. 
> values(locate('','A')
> results in 1, which is obviously wrong

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message