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 "Daniel John Debrunner (JIRA)" <de...@db.apache.org> on 2005/12/17 00:48:35 UTC

[jira] Created: (DERBY-769) CLOB and BLOB descriptions do not specify the default length

CLOB and BLOB descriptions do not specify the default length
------------------------------------------------------------

         Key: DERBY-769
         URL: http://issues.apache.org/jira/browse/DERBY-769
     Project: Derby
        Type: Bug
  Components: Documentation  
    Versions: 10.1.1.0    
    Reporter: Daniel John Debrunner
    Priority: Trivial


BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)

http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt updated DERBY-769:
------------------------------

    Attachment: derby769-2.diff
                rrefblob.html
                rrefclob.html

Thanks Dan,

Attached patch (derby769-2.diff) takes care of those syntax errors, and htmlfiles are once again included for review.  Thanks for the quick feedback!  Letme know if everything looks OK.

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt commented on DERBY-769:
-----------------------------------

Can someone take a final look at this so that it can be committed?  Thanks!

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt updated DERBY-769:
------------------------------

    Attachment: derby769.diff
                rrefblob.html
                rrefclob.html

Attached patch (derby769.diff) adds a default section in both topics, each saying that the default length for these types is one megabyte if no length is specified,  See html output files included for review.  Thanks!

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

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

Committed revision 385916.

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Assignee: Jeff Levitt
>     Priority: Trivial
>      Fix For: 10.2.0.0
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt updated DERBY-769:
------------------------------

    Attachment:     (was: rrefclob.html)

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt updated DERBY-769:
------------------------------

    Attachment:     (was: rrefblob.html)

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

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

Jeff Levitt commented on DERBY-769:
-----------------------------------

Can this be committed by a committer please?  Thanks!

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

Posted by "Daniel John Debrunner (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-769?page=comments#action_12368800 ] 

Daniel John Debrunner commented on DERBY-769:
---------------------------------------------

Just noticed that the syntax does not indicate the lengh is optional, and for CLOB has an extra open brace before the K 
and an extra closing paren at the end (as does BLOB). I think this is the correct syntax

{CLOB |CHARACTER LARGE OBJECT} [ (length [ {K |M |G} ] ) ]


{ BLOB | BINARY LARGE OBJECT }  [ ( length [ {K |M |G } ] ) ]

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

-- 
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-769) CLOB and BLOB descriptions do not specify the default length

Posted by "Satheesh Bandaram (JIRA)" <de...@db.apache.org>.
    [ http://issues.apache.org/jira/browse/DERBY-769?page=comments#action_12369560 ] 

Satheesh Bandaram commented on DERBY-769:
-----------------------------------------

I reviewed the changes in version_2. Looks like all reported issues have been fixed... though white space differences seems to show more diffs than there are. 

> CLOB and BLOB descriptions do not specify the default length
> ------------------------------------------------------------
>
>          Key: DERBY-769
>          URL: http://issues.apache.org/jira/browse/DERBY-769
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.1.1.0
>     Reporter: Daniel John Debrunner
>     Priority: Trivial
>  Attachments: derby769-2.diff, derby769.diff, rrefblob.html, rrefclob.html
>
> BLOB without a length  has a default length of 1 mega byte, ie. same as BLOB(1M)
> CLOB without a length  has a default length of 1 mega characters, ie. same as CLOB(1M)
> http://db.apache.org/derby/docs/10.1/ref/rrefblob.html
> http://db.apache.org/derby/docs/10.1/ref/rrefclob.html

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