linux-traipu team mailing list archive

[Daniël van Eeden <launchpad@xxxxxxxxx>]

Public bug reported:

drizzle> insert into t1(t) values ('00:05:10');
Query OK, 1 row affected (0.001717 sec)

drizzle> select t,t*1.5 from t1;
+----------+-------+
| t        | t*1.5 |
+----------+-------+
| 00:05:10 |   465 | 
+----------+-------+
1 row in set (0.000691 sec)


This differs from the SQL standard and behaviour from MySQL, PostgreSQL and SQLite.

If I understand it correctly the standards compliant behaviour should be
to throw an error. The expected behaviour (PostgreSQL does this) is to
return 00:07:45.

** Affects: drizzle
     Importance: Undecided
         Status: New

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

Title:
  Using the * operation on time gives unexpected results

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

Bug description:
  drizzle> insert into t1(t) values ('00:05:10');
  Query OK, 1 row affected (0.001717 sec)

  drizzle> select t,t*1.5 from t1;
  +----------+-------+
  | t        | t*1.5 |
  +----------+-------+
  | 00:05:10 |   465 | 
  +----------+-------+
  1 row in set (0.000691 sec)

  
  This differs from the SQL standard and behaviour from MySQL, PostgreSQL and SQLite.

  If I understand it correctly the standards compliant behaviour should
  be to throw an error. The expected behaviour (PostgreSQL does this) is
  to return 00:07:45.

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