[mdb-dev] Possible bug: incorrectly returned Date/Time fields

[Mindaugas K. <Min...@ha...>]

Hello,
=20
I don't know if such situation was reported, but recently I noticed that
data in mysql database differ from ms access, particulary Date/Time
fields (format in access db - General Date). During replication process
almost half of data was damaged (Date/Time was short by one second), and
there is no rule which data damaged. This is really serious problem to
me because when operating with huge databases it causes big differences
in duration and so on...
=20
Tried to select data via mdb-sql to make sure this is mdbtools problem
and this is what I got:
1 =3D> select * from IVR_Calls_NoDet where Start_Date < '01/02/04
00:00:00';
2 =3D> go
Calling mdb_test_sarg on unknown type.  Add code to mdb_test_sarg() for
type 8
( my data .... )
Calling mdb_test_sarg on unknown type.  Add code to mdb_test_sarg() for
type 8
...
...
=20
Where clause was ignored, and data from Date/Time fields was shorter in
1 second.
=20
If it is not a bug so please explain what I am doing wrong. I tried
various Date/Time formats, JET3 and JET4 engines but always get the same
result.
=20
It is really urgent to me, so please respond
=20
Thanks in advance