You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Deepa Remesh (JIRA)" <de...@db.apache.org> on 2005/10/15 01:12:48 UTC

[jira] Created: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Documentation needs to be updated with correct return type for COUNT functions
------------------------------------------------------------------------------

         Key: DERBY-627
         URL: http://issues.apache.org/jira/browse/DERBY-627
     Project: Derby
        Type: Bug
  Components: Documentation  
    Versions: 10.2.0.0    
    Reporter: Deepa Remesh
    Priority: Minor


Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 


-- 
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

[jira] Updated: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-627?page=all ]

Jean T. Anderson updated DERBY-627:
-----------------------------------

    Other Info:   (was: [Patch available])

Patch was committed so am marking it unavailable to aid Jira searches.

> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.2.0.0
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Updated: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-627?page=all ]

Jeff Levitt updated DERBY-627:
------------------------------

    Other Info: [Patch available]

> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Priority: Minor
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Commented: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-627?page=comments#action_12368415 ] 

Deepa Remesh commented on DERBY-627:
------------------------------------

Thanks for making the changes. I took a look at the attached html files and they cover what I describe. Patch looks good to me.

> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Priority: Minor
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Resolved: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Jean T. Anderson (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-627?page=all ]
     
Jean T. Anderson resolved DERBY-627:
------------------------------------

    Fix Version: 10.2.0.0
     Resolution: Fixed
      Assign To: Jeff Levitt

Committed patch derby627.diff, revision 382282. Modified files:
$ svn commit
Sending        trunk/src/ref/rrefbuiltinteger.dita
Sending        trunk/src/ref/rrefsqlj38716.dita
Sending        trunk/src/ref/rrefsqlj66113.dita


> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.2.0.0
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Updated: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-627?page=all ]

Jeff Levitt updated DERBY-627:
------------------------------

    Attachment: derby627.diff
                rrefsqlj38716.html
                rrefsqlj66113.html

Attached patch changes the indicated datatype to INTEGER in both files.  HTML output included for review.

> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Priority: Minor
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Commented: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Jeff Levitt (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-627?page=comments#action_12368406 ] 

Jeff Levitt commented on DERBY-627:
-----------------------------------

Could someone possibly review this patch please?

> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Priority: Minor
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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

[jira] Closed: (DERBY-627) Documentation needs to be updated with correct return type for COUNT functions

Posted by "Deepa Remesh (JIRA)" <de...@db.apache.org>.
     [ http://issues.apache.org/jira/browse/DERBY-627?page=all ]
     
Deepa Remesh closed DERBY-627:
------------------------------


> Documentation needs to be updated with correct return type for COUNT functions
> ------------------------------------------------------------------------------
>
>          Key: DERBY-627
>          URL: http://issues.apache.org/jira/browse/DERBY-627
>      Project: Derby
>         Type: Bug

>   Components: Documentation
>     Versions: 10.2.0.0
>     Reporter: Deepa Remesh
>     Assignee: Jeff Levitt
>     Priority: Minor
>      Fix For: 10.2.0.0
>  Attachments: derby627.diff, rrefsqlj38716.html, rrefsqlj66113.html
>
> Derby Reference manual (Section 'Built-in functions', pg80-81) specifies the resulting data type of COUNT and COUNT(*) functions as BIGINT. Whereas, Derby returns INTEGER type for these functions. 

-- 
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