Project

General

Profile

Actions

Bug #9271

closed

Invalid DateTime/timestamp conversion in MySQL backend

Added by Steven Köhler about 3 years ago. Updated over 2 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
Start date:
11/01/2021
Due date:
% Done:

100%

Estimated time:

Description

When examining a MySQL/MariaDB database I use in a Wt project I noticed that all timestamps, without a single exception, had the format YYYY-MM-DD HH:MM:SS.000 - the millisecond part was always exactly zero, although the original timestamps definitely had non-zero millisecond parts. The issue occurred when storing WDateTime as well as std::chrono::system_clock::time_point. It turned out that the culprit is an invalid conversion in the MySQL backend.

I fixed the underlying issues and created a pull request (https://github.com/emweb/wt/pull/180) some weeks ago, but it seems to have gotten unnoticed. The pull request contains a more detailed description of the issue/solution. It would be nice if you could take a look at it.

Best regards
Steven

Actions #1

Updated by Roel Standaert about 3 years ago

  • Target version set to 4.7.0
Actions #2

Updated by Korneel Dumon almost 3 years ago

  • Assignee set to Korneel Dumon
Actions #3

Updated by Korneel Dumon almost 3 years ago

  • Status changed from New to InProgress
Actions #4

Updated by Korneel Dumon almost 3 years ago

  • Status changed from InProgress to Review
  • Assignee deleted (Korneel Dumon)
Actions #5

Updated by Roel Standaert over 2 years ago

  • Status changed from Review to Implemented @Emweb
  • Assignee set to Korneel Dumon
Actions #6

Updated by Roel Standaert over 2 years ago

  • % Done changed from 0 to 100
Actions #7

Updated by Roel Standaert over 2 years ago

  • Status changed from Implemented @Emweb to Resolved
Actions #8

Updated by Roel Standaert over 2 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF