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

Bug #700925 reported by Andrew Hutchings
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
High
Brian Aker
7.0
Fix Released
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  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.