[OFBIZ-9496] MySql Database related warning related to DATETIME filed

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Assignee: Deepak Dixit
• Reporter: Deepak Dixit
• Created: 18/Jul/17 07:02
• Updated: 28/Jul/17 07:59

Description

Here are the following warnings that we are getting for all the datetime related filed.
this is due to incorrect handling of database filed type comparison in DatabaseUtil.java

2017-07-18 12:30:19,137 |OFBiz-batch-2        |DatabaseUtil                  |W| Column [LAST_UPDATED_TX_STAMP] of table [RUNTIME_DATA] of entity [RuntimeData] has a column size of [19] in the database, but is defined to have a column size of [3] in the entity definition.

Issue Links

• is related to: OFBIZ-9337 Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values