linux-traipu team mailing list archive

[Prachee Rai <pracheerai1@xxxxxxxxx>]

** Changed in: drizzle
     Assignee: (unassigned) => Prachee Rai (prachee)

-- 
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/760358

Title:
  Microseconds not compared in TIMESTAMP(6)

Status in A Lightweight SQL Database for Cloud Infrastructure and Web Applications:
  New

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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/760358/+subscriptions