[ 
https://issues.apache.org/jira/browse/DERBY-2794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12505049
 ] 

Myrna van Lunteren commented on DERBY-2794:
-------------------------------------------

Now I *have* tested the examples, and the two examples using 'NULL' return an 
error for me with ij:

ij> VALUES TRIM(NULL from '  derby ');
ERROR 42X01: Syntax error: Encountered "NULL" at line 1, column 13.
ij> VALUES TRIM(' ' from NULL);
ERROR 42X01: Syntax error: Encountered "NULL" at line 1, column 22.

Is that a bug in the example & text or in the functionality?

> Document ansi trim functionality
> --------------------------------
>
>                 Key: DERBY-2794
>                 URL: https://issues.apache.org/jira/browse/DERBY-2794
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>            Reporter: Manish Khettry
>            Assignee: Manish Khettry
>         Attachments: DERBY-2794.diff, ref-single.html, rreftrimfunc.html, 
> trim_doc
>
>
> Several examples can be found in the junit test (AnsiTrimTest). The unit test 
> is in java/testing/org/apache/derbyTesting/functionTests/tests/lang.
> There is also the documentation from the ANSI spec which Dag had posted in a 
> comment in DERBY-1623.

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

Reply via email to