db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Susan Cline (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Fri, 06 Oct 2006 18:01:22 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12440567 ] 
Susan Cline commented on DERBY-1839:

I had 5 comments related to this bug, shown below with the html file name and the topic I
commented on.   The zip file I looked in above to see the patch was derby1839_functions1.zip.
 If I missed another zip file which had the patch in it, could you please let me know?

These two files were fixed:

rrefbuiltsmallint	SMALLINT 
rrefsqlj29930	UCASE or UPPER 

But these three were not:

rreftimestampfunc	TIMESTAMP 
rrefsecondfunc	SECOND 
rrefsqlj93082	SUBSTR

Here is why they were not fixed:

The new document still shows an incorrect example, namely:

The following clause returns the value 1998-12-25-
VALUES TIMESTAMP('1998-12-25', '17.12.30')

Here is the correct output:

VALUES TIMESTAMP('1998-12-25', '17.12.30');
1998-12-25 17:12:30.0


I believe that DERBY-908 partially addresses my comments, but it does not address all of them.
 The comment that is not addressed in either DERBY-908 or DERBY-1924 (this bug is mentioned
on the ReferenceManualTenTwo wiki page, but it has nothing to do with time),  is this:

If the argument can be null, the result can be null; if the argument is null, the result is
the null value.

I'm not entirely clear I understand what this means, but here is a test to show that if the
argument is null, the result is NOT null;
ij> create table timestamp_tab (id integer, col2 timestamp);
0 rows inserted/updated/deleted
ij> insert  into timestamp_tab(id) values (1);
1 row inserted/updated/deleted
ij> insert into timestamp_tab values (2, null);
1 row inserted/updated/deleted
ij> select second(col2) from timestamp_tab;
0.0  << these should be null according to the doc, and are 0

SUBSTR({ CharacterExpression },
   StartPosition [, LengthOfString ] )

The updated document says this:

The SUBSTR function returns NULL if the parameter lengthOfString is specified and if the parameter
is less than zero. 

But this is not true based on the example I gave in my comments:

ij> values substr('hello', 1,-2);
ERROR 22011: The second or third argument of the SUBSTR function is out of range



> Doc Review Updates - Ref Manual
> -------------------------------
>                 Key: DERBY-1839
>                 URL: http://issues.apache.org/jira/browse/DERBY-1839
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>             Fix For:
>         Attachments: 1839_SQLstatements.diff, derby1839_functions1.diff, derby1839_functions1.zip,
derby1839_SQLstatement_4.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip,
derby1839_SQLstatements3.diff, derby1839_SQLstatements3_html.zip, derby1839_SQLstatements4_html.zip,
derby1839_SQLstatements_html.zip, derby1839_TANCEILfunctions.diff, derby1839_TANCEILfunctions_html.zip,
derby1839_XML+functions_1.diff, derby1839_XML+functions_2.diff, derby1839_XML+functions_html1.zip,
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review
of the Reference Manual.

This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message