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 "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2010/01/08 10:31:58 UTC
[jira] Created: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Reference manual is unclear on max length for VARCHAR
-----------------------------------------------------
Key: DERBY-4510
URL: https://issues.apache.org/jira/browse/DERBY-4510
Project: Derby
Issue Type: Bug
Components: Documentation
Affects Versions: 10.5.3.0
Reporter: Knut Anders Hatlen
Priority: Minor
This is what the reference manual says about the length of a VARCHAR:
(http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
,----
| length is an unsigned integer constant, and it must not be greater
| than the constraint of the integer used to specify the length, the
| value java.lang.Integer.MAX_VALUE.
|
| The maximum length for a VARCHAR string is 32,672 characters.
`----
I don't understand why it talks about Integer.MAX_VALUE here, and I
think it would be less confusing if we replaced the above with this:
,----
| length is an unsigned integer constant. The maximum length for a
| VARCHAR string is 32,672 characters.
`----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton updated DERBY-4510:
-----------------------------------
Attachment: docs.diff
rrefsqlj41207.html
That seems like a good simplification, and a much clearer way to describe the data type.
Attached is a docs patch proposal, and the HTML-formatted version of the ref page.
> Reference manual is unclear on max length for VARCHAR
> -----------------------------------------------------
>
> Key: DERBY-4510
> URL: https://issues.apache.org/jira/browse/DERBY-4510
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Knut Anders Hatlen
> Priority: Minor
> Attachments: docs.diff, rrefsqlj41207.html
>
>
> This is what the reference manual says about the length of a VARCHAR:
> (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
> ,----
> | length is an unsigned integer constant, and it must not be greater
> | than the constraint of the integer used to specify the length, the
> | value java.lang.Integer.MAX_VALUE.
> |
> | The maximum length for a VARCHAR string is 32,672 characters.
> `----
> I don't understand why it talks about Integer.MAX_VALUE here, and I
> think it would be less confusing if we replaced the above with this:
> ,----
> | length is an unsigned integer constant. The maximum length for a
> | VARCHAR string is 32,672 characters.
> `----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen closed DERBY-4510.
-------------------------------------
Verified the fix in the alpha manual (http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html). Closing.
> Reference manual is unclear on max length for VARCHAR
> -----------------------------------------------------
>
> Key: DERBY-4510
> URL: https://issues.apache.org/jira/browse/DERBY-4510
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Knut Anders Hatlen
> Assignee: Bryan Pendleton
> Priority: Minor
> Fix For: 10.6.0.0
>
> Attachments: docs.diff, rrefsqlj41207.html
>
>
> This is what the reference manual says about the length of a VARCHAR:
> (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
> ,----
> | length is an unsigned integer constant, and it must not be greater
> | than the constraint of the integer used to specify the length, the
> | value java.lang.Integer.MAX_VALUE.
> |
> | The maximum length for a VARCHAR string is 32,672 characters.
> `----
> I don't understand why it talks about Integer.MAX_VALUE here, and I
> think it would be less confusing if we replaced the above with this:
> ,----
> | length is an unsigned integer constant. The maximum length for a
> | VARCHAR string is 32,672 characters.
> `----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton reassigned DERBY-4510:
--------------------------------------
Assignee: Bryan Pendleton
> Reference manual is unclear on max length for VARCHAR
> -----------------------------------------------------
>
> Key: DERBY-4510
> URL: https://issues.apache.org/jira/browse/DERBY-4510
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Knut Anders Hatlen
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: docs.diff, rrefsqlj41207.html
>
>
> This is what the reference manual says about the length of a VARCHAR:
> (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
> ,----
> | length is an unsigned integer constant, and it must not be greater
> | than the constraint of the integer used to specify the length, the
> | value java.lang.Integer.MAX_VALUE.
> |
> | The maximum length for a VARCHAR string is 32,672 characters.
> `----
> I don't understand why it talks about Integer.MAX_VALUE here, and I
> think it would be less confusing if we replaced the above with this:
> ,----
> | length is an unsigned integer constant. The maximum length for a
> | VARCHAR string is 32,672 characters.
> `----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12804107#action_12804107 ]
Knut Anders Hatlen commented on DERBY-4510:
-------------------------------------------
Thanks Bryan. The patch and the HTML look good to me. +1 to commit.
> Reference manual is unclear on max length for VARCHAR
> -----------------------------------------------------
>
> Key: DERBY-4510
> URL: https://issues.apache.org/jira/browse/DERBY-4510
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Knut Anders Hatlen
> Assignee: Bryan Pendleton
> Priority: Minor
> Attachments: docs.diff, rrefsqlj41207.html
>
>
> This is what the reference manual says about the length of a VARCHAR:
> (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
> ,----
> | length is an unsigned integer constant, and it must not be greater
> | than the constraint of the integer used to specify the length, the
> | value java.lang.Integer.MAX_VALUE.
> |
> | The maximum length for a VARCHAR string is 32,672 characters.
> `----
> I don't understand why it talks about Integer.MAX_VALUE here, and I
> think it would be less confusing if we replaced the above with this:
> ,----
> | length is an unsigned integer constant. The maximum length for a
> | VARCHAR string is 32,672 characters.
> `----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-4510) Reference manual is unclear on max
length for VARCHAR
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-4510?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Bryan Pendleton resolved DERBY-4510.
------------------------------------
Resolution: Fixed
Fix Version/s: 10.6.0.0
Thanks for the timely review, Knut. Committed to the docs trunk as revision 902478.
> Reference manual is unclear on max length for VARCHAR
> -----------------------------------------------------
>
> Key: DERBY-4510
> URL: https://issues.apache.org/jira/browse/DERBY-4510
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.5.3.0
> Reporter: Knut Anders Hatlen
> Assignee: Bryan Pendleton
> Priority: Minor
> Fix For: 10.6.0.0
>
> Attachments: docs.diff, rrefsqlj41207.html
>
>
> This is what the reference manual says about the length of a VARCHAR:
> (http://db.apache.org/derby/docs/10.5/ref/rrefsqlj41207.html)
> ,----
> | length is an unsigned integer constant, and it must not be greater
> | than the constraint of the integer used to specify the length, the
> | value java.lang.Integer.MAX_VALUE.
> |
> | The maximum length for a VARCHAR string is 32,672 characters.
> `----
> I don't understand why it talks about Integer.MAX_VALUE here, and I
> think it would be less confusing if we replaced the above with this:
> ,----
> | length is an unsigned integer constant. The maximum length for a
> | VARCHAR string is 32,672 characters.
> `----
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.