search

OpenInformix / IfxPy

Informix native Python driver for scalable enterprise and IoT solutions.
Other
46 stars 22 forks source link

Bad representation interval values in DataBase #21

Open dardaire opened 5 years ago

dardaire commented 5 years ago

I created a query in StackOverfolw about problems with Interval type data. (https://stackoverflow.com/questions/57474692/informix-interval-datatype-vs-python-timedelta-data-type?noredirect=1#comment101423358_57474692)

I have tested that the intelval types if created from python are stored in the Database in negative if they are positive and in positive if they are negative.

If the data is created from python this is not a problem but if the data is created from another client (JDBC, I4gl, dbaccess ...) when retrieved it is recovered erroneously.

I have tested it with the example of stackOverflow and with the test of the implementation of the interval type. (https://github.com/OpenInformix/IfxPy/pull/5)

Thanks,

jleffler commented 5 years ago

The problem is not in the database — that stores INTERVAL values accurately.

There may be problems somewhere along the line with how Python or the IfxPy driver (or possibly ODBC) handles intervals (I'd nominate IfxPy as the one most likely to have problems), but the database itself stores the values accurately. I've used them extensively for many years, positive and negative values, and I've never found a problem in the database itself. Applications, yes; database, no.

On Tue, Aug 20, 2019 at 2:06 AM dardaire notifications@github.com wrote:

I created a query in StackOverfolw about problems with Interval type data. ( https://stackoverflow.com/questions/57474692/informix-interval-datatype-vs-python-timedelta-data-type?noredirect=1#comment101423358_57474692 )

I have tested that the intelval types if created from python are stored in the Database in negative if they are positive and in positive if they are negative.

If the data is created from python this is not a problem but if the data is created from another client (JDBC, I4gl, dbaccess ...) when retrieved it is recovered erroneously.

I have tested it with the example of stackOverflow and with the test of the implementation of the interval type. (#5 https://github.com/OpenInformix/IfxPy/pull/5)

Thanks,

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/OpenInformix/IfxPy/issues/21?email_source=notifications&email_token=ACCAHBVLZVV2IUXDKSIEJ3DQFOXZRA5CNFSM4INSOYC2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HGF7LGQ, or mute the thread https://github.com/notifications/unsubscribe-auth/ACCAHBX2GELHWVYOJAU4SRTQFOXZRANCNFSM4INSOYCQ .

-- Jonathan Leffler jonathan.leffler@gmail.com #include Guardian of DBD::Informix - v2018.1031 - http://dbi.perl.org "Blessed are we who can laugh at ourselves, for we shall never cease to be amused."