[odb-users] Problems with ODB/MySQL and boost::posix_time recording sub-second values

[Adam Walters]

Hi Boris,
Thanks for getting me a new library so quickly. My tests so far don't show a difference and I wonder if I am missing a vital step? I rebuilt the library from the code you provided and modified the reference in the linker for the executable I am building to use the new library. I even re-ran the ODB compiler on my class for good measure, but still no result. Any suggestions?

Cheers,
Adam

-----Original Message-----
From: Boris Kolpackov [mailto:boris at codesynthesis.com] 
Sent: June-27-13 4:43 AM
To: Adam Walters
Cc: odb-users at codesynthesis.com
Subject: Re: [odb-users] Problems with ODB/MySQL and boost::posix_time recording sub-second values

Hi Adam,

Adam Walters <adam at navigatesurgical.com> writes:

> I was thrilled to note that MySQL has finally decided to support 
> sub-second times in the form of TIMESTAMP(6) and DATETIME(6).
>
> [...]
> 
> When I run my example, however, the fractional time part for each 
> record is stuck at zero.

We just haven't had a chance to update the code yet.

I went ahead and implemented this, however, I haven't had a chance to test it (still waiting for a VM with MySQL 5.6).

If you want to give it a try in the meantime, here is the updated boost profile:

http://www.codesynthesis.com/~boris/tmp/odb/libodb-boost-2.2.2.tar.gz

If you do, please let us know whether it works/doesn't work for you.

Boris