Time datatype cosmetic error

Bug #743783 reported by Marcus Eriksson
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Fix Released
Low
Brian Aker

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)

Related branches

Brian Aker (brianaker)
Changed in drizzle:
status: New → Confirmed
assignee: nobody → Brian Aker (brianaker)
importance: Undecided → Low
Brian Aker (brianaker)
Changed in drizzle:
status: Confirmed → Fix Committed
Vijay Samuel (vjsamuel)
Changed in drizzle:
status: Fix Committed → Fix Released
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.