inserting into timestamp(6) with now() not preserving microseconds

Bug #700925 reported by Andrew Hutchings on 2011-01-10
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
High
Brian Aker
7.0
High
Brian Aker

Bug Description

CREATE TABLE `t3` (
  `a` INT DEFAULT NULL,
  `b` TIMESTAMP(6) NULL DEFAULT NULL
);

drizzle> select now()\G
*************************** 1. row ***************************
now(): 2011-01-10 07:37:51.890510
1 row in set (0 sec)

drizzle> insert into t3 values (1, now());
Query OK, 1 row affected (0.08 sec)

drizzle> select * from t3\G
*************************** 1. row ***************************
a: 1
b: 2011-01-10 07:38:18.000000
2 rows in set (0 sec)

Related branches

Changed in drizzle:
assignee: nobody → Brian Aker (brianaker)
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers