linux-traipu team mailing list archive

[Vijay Samuel <743783@xxxxxxxxxxxxxxxxxx>]

** Changed in: drizzle
       Status: Fix Committed => Fix Released

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

Title:
  Time datatype cosmetic error

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

Bug description:
  Using DESC <table>, time columns are shown as VARCHAR:

  drizzle> create table x (t time);
  Query OK, 0 rows affected (0.001454 sec)

  drizzle> show create table x;
  +-------+--------------------------------------------------------------------------------------+
  | Table | Create Table                                                                         |
  +-------+--------------------------------------------------------------------------------------+
  | x     | CREATE TABLE `x` (
    `t` TIME DEFAULT NULL
  ) ENGINE=InnoDB COLLATE = utf8_general_ci | 
  +-------+--------------------------------------------------------------------------------------+
  1 row in set (0.000362 sec)

  
  drizzle> desc x;
  +-------+---------+------+---------+-----------------+-----------+
  | Field | Type    | Null | Default | Default_is_NULL | On_Update |
  +-------+---------+------+---------+-----------------+-----------+
  | t     | VARCHAR | YES  |         | YES             |           | 
  +-------+---------+------+---------+-----------------+-----------+
  1 row in set (0.000347 sec)

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