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 "Tomohito Nakayama (JIRA)" <ji...@apache.org> on 2007/05/03 10:42:15 UTC
[jira] Created: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Minor erratum in page of VARCHAR in Derby Reference manual
----------------------------------------------------------
Key: DERBY-2603
URL: https://issues.apache.org/jira/browse/DERBY-2603
Project: Derby
Issue Type: Bug
Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
Reporter: Tomohito Nakayama
Priority: Minor
I found next statement in the page through translation into Japanese.
> When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
I think "binary" should be replaced as "boolean".
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493599 ]
Tomohito Nakayama commented on DERBY-2603:
------------------------------------------
Oh. :o
I agree that "binary" in page of "Where dynamic parameters are allowed" is intentional and should not be replaced.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493434 ]
Bryan Pendleton commented on DERBY-2603:
----------------------------------------
Thanks for the clarification; your explanation makes complete sense to me.
I see that there is the following page in the docs, which defines "SQL Boolean Operators":
http://db.apache.org/derby/docs/dev/ref/rrefsqlj23075.html#rrefsqlj23075__sqlj34517
Are these the same operators that are being referred to by the words
"binary comparison operators" in the varchar page for this issue?
http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
If so, then I think it would be completely appropriate to make the change you suggest,
and perhaps also to include a cross-referencing link to the other page.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama resolved DERBY-2603.
--------------------------------------
Resolution: Fixed
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2603:
-------------------------------------
Attachment: DERBY-2603.patch
* Description of the patch
* Replace binary to boolean in pages for CHAR type and VARCHAR type.
* Place hyperlink from pages of CHAR type and VARCHAR type to page of Boolean expressions.
* Test
* Build and read three types of reference manuals and does not found problem.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493530 ]
Kim Haase commented on DERBY-2603:
----------------------------------
There are references to these operators as binary on the following pages:
http://db.apache.org/derby/docs/dev/ref/rrefsqlj13733.html (CHAR data type): same sentence as in http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html (VARCHAR data type)
http://db.apache.org/derby/docs/dev/ref/rrefsqlj1083019.html (Where dynamic parameters are allowed):
"5. For the binary operators +, -, *, /, AND, OR, <, >, =, <>, <=, and >=, use of a dynamic parameter as one operand but not both is permitted. Its type is taken from the other side."
So the use of "binary" to mean "having two operands" is intentional.
But perhaps the word "binary" can simply be removed from rrefsqlj13733 and rrefsqlj41207 -- don't all comparison operators have two operands? If so, "binary" is not necessary to the meaning here.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2603:
-------------------------------------
Attachment: (was: DERBY-2603.patch)
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493725 ]
Bryan Pendleton commented on DERBY-2603:
----------------------------------------
I read the _2 version of the patch, applied, and built the doc and looked at the result.
Everything looks good to me; I think this is a good improvement to the doc.
+1 to commit.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2603:
-------------------------------------
Attachment: DERBY-2603_2.patch
Sorry.
Previous uploaded patch was one which I found problem.
// I found that link to part in a page causes link error in single page html and pdf ....
I upload the patch again.
Description for this is as same as before.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Tomohito Nakayama updated DERBY-2603:
-------------------------------------
Component/s: Documentation
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493432 ]
Tomohito Nakayama commented on DERBY-2603:
------------------------------------------
I think the word "binary" in this statement is mistaken of "boolean".
// Both types concern to concept of 0 and 1.
// Then I think person who is familiar with computer may misuse them.
As you wrote, we can recognize "binary" stands for number of argument here.
But I think it is not good usage of word here and could not believe it is intense of the original writer.
At first, I misunderstood that the two values are compared as binary value !
Again, I can't believe that writer use the word "binary" for that meaning , the number of arguments....
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Kristian Waagan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristian Waagan closed DERBY-2603.
----------------------------------
Assignee: Tomohito Nakayama
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.3.1.4
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Assignee: Tomohito Nakayama
> Priority: Minor
> Fix For: 10.3.1.4
>
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493380 ]
Bryan Pendleton commented on DERBY-2603:
----------------------------------------
Could you expand on why you think that "binary" should be replaced by "boolean"?
I understand "binary" to describe the number of *arguments* that the operator has.
I understand "boolean" to describe the *result* of the operator.
Thus, to me, the two words are not easily interchangeable, so I'm
interested to understand more about the issue as you see it.
Thanks!
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Tomohito Nakayama (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12493729 ]
Tomohito Nakayama commented on DERBY-2603:
------------------------------------------
Committed.
Sending src/ref/rrefsqlj13733.dita
Sending src/ref/rrefsqlj41207.dita
Transmitting file data ..
Committed revision 535313.
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-2603) Minor erratum in page of VARCHAR in
Derby Reference manual
Posted by "Kathey Marsden (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kathey Marsden updated DERBY-2603:
----------------------------------
Affects Version/s: 10.3.0.0
Fix Version/s: 10.3.0.0
> Minor erratum in page of VARCHAR in Derby Reference manual
> ----------------------------------------------------------
>
> Key: DERBY-2603
> URL: https://issues.apache.org/jira/browse/DERBY-2603
> Project: Derby
> Issue Type: Bug
> Components: Documentation
> Affects Versions: 10.3.0.0
> Environment: http://db.apache.org/derby/docs/dev/ref/rrefsqlj41207.html
> Reporter: Tomohito Nakayama
> Priority: Minor
> Fix For: 10.3.0.0
>
> Attachments: DERBY-2603_2.patch
>
>
> I found next statement in the page through translation into Japanese.
> > When binary comparison operators are applied to VARCHARs, the lengths of the operands are not altered, and spaces at the end of the values are ignored.
> I think "binary" should be replaced as "boolean".
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.