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 "Kristian Waagan (JIRA)" <ji...@apache.org> on 2009/11/17 10:08:39 UTC

[jira] Created: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Clarify reference manual regarding specifying field length of LONG VARCHAR columns
----------------------------------------------------------------------------------

                 Key: DERBY-4446
                 URL: https://issues.apache.org/jira/browse/DERBY-4446
             Project: Derby
          Issue Type: Improvement
          Components: Documentation
    Affects Versions: 10.5.3.0, 10.6.0.0
            Reporter: Kristian Waagan
            Priority: Minor


When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.

>From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
The Derby manual I referred to said "you do not have to specify a maximum
length when creating columns of this type". What they actually meant is "you
cannot specify a maximum length"!

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


[jira] Assigned: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase reassigned DERBY-4446:
--------------------------------

    Assignee: Kim Haase

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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


[jira] Closed: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan closed DERBY-4446.
----------------------------------


Verified in alpha manuals (built on February 8. 2010). Closing.

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4446.diff, rrefsqlj15147.html, rrefsqlj30118.html
>
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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


[jira] Commented: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
    [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12780180#action_12780180 ] 

Bryan Pendleton commented on DERBY-4446:
----------------------------------------

patch and HTML pages look fine to me! +1

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-4446.diff, rrefsqlj15147.html, rrefsqlj30118.html
>
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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


[jira] Updated: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-4446:
-----------------------------

    Issue & fix info: [Newcomer, Patch Available]  (was: [Newcomer])
          Issue Type: Bug  (was: Improvement)

Reclassifying as Bug (it's really an error).

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-4446.diff, rrefsqlj15147.html, rrefsqlj30118.html
>
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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


[jira] Updated: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase updated DERBY-4446:
-----------------------------

    Attachment: DERBY-4446.diff
                rrefsqlj30118.html
                rrefsqlj15147.html

Attaching a patch that fixes the problem in these two topics, with the two output files.

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>         Attachments: DERBY-4446.diff, rrefsqlj15147.html, rrefsqlj30118.html
>
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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


[jira] Resolved: (DERBY-4446) Clarify reference manual regarding specifying field length of LONG VARCHAR columns

Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
     [ https://issues.apache.org/jira/browse/DERBY-4446?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kim Haase resolved DERBY-4446.
------------------------------

          Resolution: Fixed
       Fix Version/s: 10.6.0.0
    Issue & fix info: [Newcomer]  (was: [Patch Available, Newcomer])

Thanks, Bryan!

Committed patch DERBY-4446.diff to documentation trunk at revision 882270.

> Clarify reference manual regarding specifying field length of LONG VARCHAR columns
> ----------------------------------------------------------------------------------
>
>                 Key: DERBY-4446
>                 URL: https://issues.apache.org/jira/browse/DERBY-4446
>             Project: Derby
>          Issue Type: Bug
>          Components: Documentation
>    Affects Versions: 10.5.3.0, 10.6.0.0
>            Reporter: Kristian Waagan
>            Assignee: Kim Haase
>            Priority: Minor
>             Fix For: 10.6.0.0
>
>         Attachments: DERBY-4446.diff, rrefsqlj15147.html, rrefsqlj30118.html
>
>
> When creating columns of type LONG VARCHAR or LONG VARCHAR FOR BIT DATA, you are not allowed to specify the maximum length of the data. The current wording in the reference manual may be read as that you can set the maximum length, but that you don't have to. We should state that specifying the length is not allowed for these two data types.
> From https://bugs.eclipse.org/bugs/show_bug.cgi?id=286206 :
> The Derby manual I referred to said "you do not have to specify a maximum
> length when creating columns of this type". What they actually meant is "you
> cannot specify a maximum length"!

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