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 "John H. Embretsen (JIRA)" <de...@db.apache.org> on 2005/12/12 09:58:46 UTC

[jira] Created: (DERBY-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
----------------------------------------------------------------------------------------------------------

         Key: DERBY-752
         URL: http://issues.apache.org/jira/browse/DERBY-752
     Project: Derby
        Type: Bug
  Components: Documentation  
    Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.2.0.0, 10.1.2.0, 10.1.1.1, 10.1.1.2, 10.1.2.1    
 Environment: All
    Reporter: John H. Embretsen
    Priority: Trivial


While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...

On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :

----------- QUOTE START -----------

ij> VALUES CURRENT_DATE;
1
----------
2001-08-06
1 row selected
ij> localizeddisplay on;
ij> VALUES CURRENT_DATE;
1
------------------
September 6, 2001
1 row selected

----------- QUOTE END -----------

I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...

I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
From: 2001-08-06
To: 2001-09-06



-- 
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-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

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

    Resolution: Fixed

Committed revision 377900.

> Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-752
>          URL: http://issues.apache.org/jira/browse/DERBY-752
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0
>  Environment: All
>     Reporter: John H. Embretsen
>     Assignee: John H. Embretsen
>     Priority: Trivial
>      Fix For: 10.2.0.0
>  Attachments: DERBY-752.diff, ctoolsijtools90477.html
>
> While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...
> On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :
> ----------- QUOTE START -----------
> ij> VALUES CURRENT_DATE;
> 1
> ----------
> 2001-08-06
> 1 row selected
> ij> localizeddisplay on;
> ij> VALUES CURRENT_DATE;
> 1
> ------------------
> September 6, 2001
> 1 row selected
> ----------- QUOTE END -----------
> I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
> Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...
> I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
> From: 2001-08-06
> To: 2001-09-06

-- 
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-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

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

John H. Embretsen updated DERBY-752:
------------------------------------

    Fix Version: 10.2.0.0
     Other Info: [Patch available]

> Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-752
>          URL: http://issues.apache.org/jira/browse/DERBY-752
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0
>  Environment: All
>     Reporter: John H. Embretsen
>     Assignee: John H. Embretsen
>     Priority: Trivial
>      Fix For: 10.2.0.0
>  Attachments: DERBY-752.diff, ctoolsijtools90477.html
>
> While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...
> On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :
> ----------- QUOTE START -----------
> ij> VALUES CURRENT_DATE;
> 1
> ----------
> 2001-08-06
> 1 row selected
> ij> localizeddisplay on;
> ij> VALUES CURRENT_DATE;
> 1
> ------------------
> September 6, 2001
> 1 row selected
> ----------- QUOTE END -----------
> I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
> Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...
> I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
> From: 2001-08-06
> To: 2001-09-06

-- 
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] Assigned: (DERBY-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

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

John H. Embretsen reassigned DERBY-752:
---------------------------------------

    Assign To: John H. Embretsen

> Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-752
>          URL: http://issues.apache.org/jira/browse/DERBY-752
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0
>  Environment: All
>     Reporter: John H. Embretsen
>     Assignee: John H. Embretsen
>     Priority: Trivial

>
> While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...
> On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :
> ----------- QUOTE START -----------
> ij> VALUES CURRENT_DATE;
> 1
> ----------
> 2001-08-06
> 1 row selected
> ij> localizeddisplay on;
> ij> VALUES CURRENT_DATE;
> 1
> ------------------
> September 6, 2001
> 1 row selected
> ----------- QUOTE END -----------
> I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
> Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...
> I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
> From: 2001-08-06
> To: 2001-09-06

-- 
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-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

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

John H. Embretsen updated DERBY-752:
------------------------------------

    Attachment: DERBY-752.diff
                ctoolsijtools90477.html

Uploading trivial patch to fix this issue. I hope it will make it into the next release...
Also included generated html file (ctoolsijtools90477.html) for review.

Changed source:  src/tools/ctoolsijtools90477.dita



> Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-752
>          URL: http://issues.apache.org/jira/browse/DERBY-752
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0
>  Environment: All
>     Reporter: John H. Embretsen
>     Assignee: John H. Embretsen
>     Priority: Trivial
>  Attachments: DERBY-752.diff, ctoolsijtools90477.html
>
> While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...
> On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :
> ----------- QUOTE START -----------
> ij> VALUES CURRENT_DATE;
> 1
> ----------
> 2001-08-06
> 1 row selected
> ij> localizeddisplay on;
> ij> VALUES CURRENT_DATE;
> 1
> ------------------
> September 6, 2001
> 1 row selected
> ----------- QUOTE END -----------
> I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
> Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...
> I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
> From: 2001-08-06
> To: 2001-09-06

-- 
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-752) Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)

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


Thanks for committing!

> Example of formatting display of locale-sensitive data yields incorrect result (Tools and Utilities guide)
> ----------------------------------------------------------------------------------------------------------
>
>          Key: DERBY-752
>          URL: http://issues.apache.org/jira/browse/DERBY-752
>      Project: Derby
>         Type: Bug
>   Components: Documentation
>     Versions: 10.0.2.0, 10.0.2.1, 10.1.1.0, 10.1.1.1, 10.1.1.2, 10.1.2.0, 10.1.2.1, 10.2.0.0
>  Environment: All
>     Reporter: John H. Embretsen
>     Assignee: John H. Embretsen
>     Priority: Trivial
>      Fix For: 10.2.0.0
>  Attachments: DERBY-752.diff, ctoolsijtools90477.html
>
> While browsing through the "HTML Files" version of the Tools and Utilities Guide in connection with DERBY-391, I discovered a small, but rather silly bug...
> On the page entitled "Formatting display of locale-sensitive data", http://db.apache.org/derby/docs/dev/tools/ctoolsijtools90477.html, there is an example showing how "localizeddisplay on;" affects the display format of "VALUES CURRENT_DATE;" in ij (in an en_US locale) :
> ----------- QUOTE START -----------
> ij> VALUES CURRENT_DATE;
> 1
> ----------
> 2001-08-06
> 1 row selected
> ij> localizeddisplay on;
> ij> VALUES CURRENT_DATE;
> 1
> ------------------
> September 6, 2001
> 1 row selected
> ----------- QUOTE END -----------
> I don't know how "2001-08-06" ended up as "September 6, 2001", but I hope this is just a Doc bug ;) (The result should obviously be "August 6, 2001").
> Certainly, "2005-12-12" correctly ends up as "December 12, 2005", using ij version 10.1.2.1...
> I guess a committer who has checked out the doc repository could easily fix this by changing one character only:
> From: 2001-08-06
> To: 2001-09-06

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