inserting into timestamp(6) with now() not preserving microseconds
Bug #700925 reported by
Andrew Hutchings
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
*******
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
*******
a: 1
b: 2011-01-10 07:38:18.000000
2 rows in set (0 sec)
Related branches
lp:~brianaker/drizzle/now-fix
- Drizzle Developers: Pending requested
-
Diff: 124 lines (+43/-8)5 files modifieddrizzled/field/microtime.cc (+15/-0)
drizzled/field/microtime.h (+6/-4)
drizzled/sql_base.cc (+3/-0)
drizzled/type/time.cc (+18/-3)
drizzled/type/time.h (+1/-1)
Changed in drizzle: | |
assignee: | nobody → Brian Aker (brianaker) |
To post a comment you must log in.