Bug 369518 - Input and display of Date/Time/Date Time values broken
Summary: Input and display of Date/Time/Date Time values broken
Status: CLOSED FIXED
Alias: None
Product: KEXI
Classification: Applications
Component: Tables (show other bugs)
Version: 3.0 Beta
Platform: Compiled Sources All
: HI major
Target Milestone: ---
Assignee: Jarosław Staniek
URL: https://phabricator.kde.org/T3901
Keywords:
Depends on:
Blocks: 378481
  Show dependency treegraph
 
Reported: 2016-09-29 09:14 UTC by Jarosław Staniek
Modified: 2019-01-07 09:46 UTC (History)
2 users (show)

See Also:
Latest Commit:
Version Fixed In: 3.0.0
Sentry Crash Report:


Attachments
Test db file (36.00 KB, application/x-kexiproject-sqlite2)
2016-09-29 09:19 UTC, Jarosław Staniek
Details
A table showing the format issues (17.14 KB, image/png)
2016-09-29 09:20 UTC, Jarosław Staniek
Details
A form showing the format issues (2.03 KB, image/png)
2016-09-29 09:21 UTC, Jarosław Staniek
Details
Test db file - updated (36.00 KB, application/x-kexiproject-sqlite2)
2019-01-07 09:46 UTC, Jarosław Staniek
Details

Note You need to log in before you can comment on or make changes to this bug.
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