Microseconds not compared in TIMESTAMP(6)

Bug #760358 reported by Andrew Hutchings
10
This bug affects 2 people
Affects Status Importance Assigned to Milestone
Drizzle
New
Undecided
Prachee Rai

Bug Description

drizzle> select * from t1;
+------+----------------------------+
| a | b |
+------+----------------------------+
| 1 | 2011-04-14 00:18:42.539939 |
| 2 | 2011-04-14 00:18:42.539910 |
+------+----------------------------+
2 rows in set (0.000438 sec)

drizzle> select * from t1 join t1 as t2 on (t1.b=t2.b);
+------+----------------------------+------+----------------------------+
| a | b | a | b |
+------+----------------------------+------+----------------------------+
| 1 | 2011-04-14 00:18:42.539939 | 1 | 2011-04-14 00:18:42.539939 |
| 2 | 2011-04-14 00:18:42.539910 | 1 | 2011-04-14 00:18:42.539939 |
| 1 | 2011-04-14 00:18:42.539939 | 2 | 2011-04-14 00:18:42.539910 |
| 2 | 2011-04-14 00:18:42.539910 | 2 | 2011-04-14 00:18:42.539910 |
+------+----------------------------+------+----------------------------+
4 rows in set (0.000556 sec)

Prachee Rai (prachee)
Changed in drizzle:
assignee: nobody → Prachee Rai (prachee)
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.