Bug #9927 Updating datetime columns
Submitted: 15 Apr 2005 12:19 Modified: 3 Aug 2007 10:11
Reporter: Alexandre Dias Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / ODBC Severity:S3 (Non-critical)
Version:3.51 OS:Windows (Windows 2000)
Assigned to: Jim Winstead CPU Architecture:Any

[15 Apr 2005 12:19] Alexandre Dias
Description:
When Microsoft Access 2000 is linked to a MyISAM table that has more than one datetime column, the last datetime column is not avaible for insert/update.

How to repeat:
mysql> CREATE TABLE teste (
    -> id int(11) NOT NULL auto_increment,
    ->   ident_es varchar(12) default NULL,
    ->   date_in timestamp(14) NULL,
    ->   date_out timestamp(14) NULL,
    ->   date_bug timestamp(14) NULL,
    ->   perceived_severity tinyint(4) default NULL,
    ->   info_ad1 varchar(80) default NULL,
    ->   info_ad2 varchar(80) default NULL,
    ->   permanencia int(10) default NULL,
    -> primary key(id)
    -> ) TYPE=MyISAM;

Link on Windows ODBC, than link on Access. After all, try to insert something on date_bug column.
[29 Apr 2005 1:33] Daniel Kasak
You should only have one 'timestamp' field per table.
You want to use 'datetime' fields instead.
[28 Mar 2007 19:24] Jim Winstead
Multiple timestamp fields in one table should work. This bug needs to get re-verified with the latest release of Connector/ODBC.
[2 Apr 2007 9:45] Tonci Grgin
Verified as described with:
 - MySQL server 5.0.38BK on WinXP Pro SP2 localhost
 - MyODBC 3.51.14 GA
 - MS Access 2003 (11.6566.8122) SP2
 - JET engine: msjet40.dll, 4.00.8618.0 / 2004-04-16
 - Submitted table structure
[26 Jul 2007 17:04] Jim Winstead
Fix TIMESTAMP fields returned by SQLSpecialColumns

Attachment: bug9927.patch (text/plain), 3.32 KiB.

[30 Jul 2007 15:30] Jim Winstead
The fix for this bug has been committed to the source tree, and will be in 3.51.18.

Thanks for the bug report.
[3 Aug 2007 10:11] MC Brown
A note has been added to the 3.51.18 changelog: 

When using a table with multiple TIMESTAMP columns, the final TIMESTAMP column within the table definition would not be updateable.