Bug 369518

Summary: Input and display of Date/Time/Date Time values broken
Product: [Applications] KEXI Reporter: Jarosław Staniek <staniek>
Component: TablesAssignee: Jarosław Staniek <staniek>
Status: CLOSED FIXED    
Severity: major CC: adam, inksi
Priority: HI    
Version: 3.0 Beta   
Target Milestone: ---   
Platform: Compiled Sources   
OS: All   
URL: https://phabricator.kde.org/T3901
Latest Commit: https://phabricator.kde.org/R71:e43e8e4a9c05bfa5101e4a7ea7c4949c1f9eaab7 Version Fixed In: 3.0.0
Sentry Crash Report:
Bug Depends on:    
Bug Blocks: 378481    
Attachments: Test db file
A table showing the format issues
A form showing the format issues
Test db file - updated

Description Jarosław Staniek 2016-09-29 09:14:08 UTC 
Input and display of Date/Time/Date Time values are broken in both forms and tables.
This is a regression in Kexi 3.

Reproducible: Always

Steps to Reproduce:
1. Create table with Date/Time/Date Time types or use existing table having these types
2. Try to display and enter values


Actual Results:  
No entry of value like 2016-09-29 or time possible. Instead of "-" only "_" works.
Please see the screen shots attached for forms and tables, and the test database file.

Expected Results:  
The functions should work like in Kexi 2.9.

This is possibly a defect in date/time formatters and validators, regression related to porting to Qt 5.
Comment 1 Jarosław Staniek 2016-09-29 09:15:44 UTC 
Similar topic: https://bugs.kde.org/show_bug.cgi?id=299865
Comment 2 Jarosław Staniek 2016-09-29 09:19:17 UTC 
Created attachment 101338 [details]
Test db file
Comment 3 Jarosław Staniek 2016-09-29 09:20:44 UTC 
Created attachment 101339 [details]
A table showing the format issues
Comment 4 Jarosław Staniek 2016-09-29 09:21:03 UTC 
Created attachment 101340 [details]
A form showing the format issues
Comment 5 Jarosław Staniek 2017-11-30 16:29:56 UTC 
Analysis at https://bugs.kde.org/show_bug.cgi?id=378481#c3
Comment 6 Jarosław Staniek 2019-01-03 21:29:10 UTC 
Apparently fixed in 3.0.0 stable already :)

https://phabricator.kde.org/R71:e43e8e4a9c05bfa5101e4a7ea7c4949c1f9eaab7
Comment 7 Jarosław Staniek 2019-01-07 09:46:26 UTC 
Created attachment 117319 [details]
Test db file - updated