[ODBC-38] Cannot insert or update date or timestamp datatype Created: 2016-04-26  Updated: 2016-05-27  Resolved: 2016-05-27

Status: Closed
Project: MariaDB Connector/ODBC
Component/s: None
Affects Version/s: 1.0.6, 2.0.10
Fix Version/s: 2.0.11

Type: Bug Priority: Major
Reporter: Santi H Assignee: Lawrin Novitsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Windows 8 64bit, Ms Access 2013, Ubuntu-Mariadb 10.1.13, Connector 2.0.10


 Description   

Created a table in Mariadb 10.1.13 which has a date field on Ubuntu 14.04.
Created a linked table in MSAccess 2013 pointing to it.
When trying to save a record and specifying a date like 2014-01-01 I get an ODBC error saying that there was an overflow of the interval for a data type (message is in spanish).
Record does not get saved.
If the record already exists (like created manually in the MariaDB console) the date gets correctly loaded into the MSAccess table. However, no updates, nor even delete operations can be carried out on that record, throwing always the same error message.
When I downgraded to the 1.0.6 version of the connector, everything was GO again.

 Comments   
Comment by Lawrin Novitsky [ 2016-04-26 ]

Thank you for your report!
Are you saying that the bug is present in the 2.0.10, and not in 1.0.6? This is really valuable evidence for us, since we thought that those 2 versions are supposed to behave identically on windows. Apparently our understanding was wrong.

Comment by Lawrin Novitsky [ 2016-05-27 ]

The fix and the testcase have been pushed(7622f2c...23ae3e3)
The thing was that connector in SQLColumns gave ODBC3 SQL types for columns, which MS Access later used while binding parameters. But it is ODBC2 application, and DM did not like those types. The fix changed connector to send ODBC2 type codes if application set version to 2

Comment by Lawrin Novitsky [ 2016-05-27 ]

One more thing - the bug is present in 1.0.6 as well

Generated at Thu Feb 08 03:25:46 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.