Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
3.0.2
-
None
-
Windows 10
Description
Hello,
I am using the connector version 3.02.
Why do my MariaDB tables not match what I get in MSACCESS?
I will show the top three records here:
MariaDB:
'327', '110', '6704', '2017-10-10 12:53:07', NULL
'326', '110', '6689', '2017-09-28 16:07:55', NULL
'325', '110', '6688', '2017-09-28 16:07:49', NULL
MSAccess:
325 110 6688 28.09.2017 16:07:49
325 110 6688 28.09.2017 16:07:49
325 110 6688 28.09.2017 16:07:49
Please pay attention to the first column.
Here is the create statement for my table on MariaDB:
CREATE TABLE `ctbl_compoundbundles_compounds` (
`BundleCompoundID` int(11) NOT NULL AUTO_INCREMENT,
`CompoundBundleID` int(11) NOT NULL,
`CompoundID` int(11) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`DateTime_ODBCWriteConflict_Fix` datetime DEFAULT NULL,
PRIMARY KEY (`BundleCompoundID`),
UNIQUE KEY `UNIQUE` (`CompoundBundleID`,`CompoundID`),
KEY `INDEX` (`BundleCompoundID`)
) ENGINE=InnoDB AUTO_INCREMENT=328 DEFAULT CHARSET=latin1;
SELECT * FROM crystaltrain.ctbl_compoundbundles_compounds;