[Libreoffice-bugs] [Bug 40575] New: Error in date handling in BASE

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40575

           Summary: Error in date handling in BASE
           Product: LibreOffice
           Version: LibO 3.3.4 release
          Platform: x86-64 (AMD64)
        OS/Version: Mac OS X (All)
            Status: NEW
          Severity: critical
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: alex.thurgood at gmail.com


Created an attachment (id=50839)
 --> (https://bugs.freedesktop.org/attachment.cgi?id=50839)
testdb to reproduce behaviour

Steps to reproduce :



1) Create a simple HSQLDB database containing 2 fields :

ID : INT autovalue = YES
bday : DATE (DD/MM/YYYY) formatting

save.

2) Open table for entering data. In the date field enter 01/06/9957. Displayed
date is 01/06/9957.

3) Now in next tuple, enter 01/06/9958 :
- expected display is 01/06/9958
- actual display is 31/12/9999

4) Wrong behaviour : all dates with years from 9958 and onwards are displayed
as 31/12/9999 irrespective of the date entered.


This is a quite significant reduction in the number of years available for date
management within a database.


Alex

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.