Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
0.9.4
-
None
Description
The scenario
stmt->execute("CREATE TABLE concpp62(ts TIMESTAMP(6))");
stmt->execute("INSERT INTO concpp62(ts) values('2015-01-20 16:14:36.709649')");
res.reset(stmt->executeQuery("SELECT ts, TIME(ts) from bug68523"));
ASSERT(res->next());
ASSERT_EQUALS(res->getString(1), "2015-01-20 16:14:36.709649");
ASSERT_EQUALS(res->getString(2), "16:14:36.709649");
The result was nanoseconds instead of microseconds in fractional part in this case.
Both the testcase and fix have been already pushed in the commit 43d72ad