Ticket #161 (new enhancement)

Opened 12 months ago

Last modified 5 days ago

Logging to RDBMS in milliseconds

Reported by: fcohen Owned by: llara@…
Priority: minor Milestone:
Version: 5.3 Keywords:
Cc:

Description

Yurly wrote:

Hi.

We've found a trouble with analysis data being saved in DB:

Unfortunately MySQL doesn't support Millisecond DATETIME Resolution (see for details http://feedblog.org/2007/05/26/why-doesnt-mysql-support-millisecond-datetime-resolution/ ), so ,for example, you can't extract milliseconds from the field 'T_Start' of the 'transactions' table to make an analytical chart.

We can solve this bug in this way: Add a supplementary field of BIGINT type into 'transactions' table and fill this field with datetime long value in the format "yyyyMMddHHmmssSS" during saving results in a DB.

Thanks.

Attachments

DatabaseLogger.patch (3.0 kB) - added by fcohen 10 months ago.
Standard_DB_for_logging.patch (0.7 kB) - added by fcohen 10 months ago.

Change History

Changed 10 months ago by fcohen

Changed 10 months ago by fcohen

Changed 10 months ago by fcohen

Frank Cohen wrote:

Thank you, Yuriy for resending me the patches. I attached them to Ticket 161 today. I appreciate your support of the TestMaker project.

-Frank

Changed 7 months ago by fcohen

  • version changed from 5 to 5.2

Changed 6 months ago by fcohen

  • priority changed from major to minor

Changed 5 days ago by fcohen

  • version changed from 5.2 to 5.3
Note: See TracTickets for help on using tickets.