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:

TIMESTAMP
----------------
The new document still shows an incorrect example, namely:

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

Here is the correct output:

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

SECOND
------------

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;
1
----------------------
0.0  << these should be null according to the doc, and are 0
0.0
***************************************************************
SUBSTR
------------

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);
1
---------------
ERROR 22011: The second or third argument of the SUBSTR function is out of range
***************************************************************************************

Thanks,

Susan

> 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: 10.2.1.6
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>             Fix For: 10.2.2.0
>
>         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,
derby1839_XML+functions_html2.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

        

Mime
View raw message