Bug #81260 mysqlsh shows TIME columns as boolean values

• Submitted: 1 May 2016 18:05
• Modified: 24 Aug 2016 16:15
• Reporter: Giuseppe Maxia (OCA)
• Status: Closed
• Category: MySQL Server: Document Store: MySQL Shell
• Severity: S2 (Serious)
• Version: 5.7.12
• OS: Any
• CPU Architecture: Any

[1 May 2016 18:05] Giuseppe Maxia

Description:
Create a table that contains a TIME column:

create table t1 (id int not null primary key, t time);
Query OK, 0 rows affected (0.01 sec)

insert into t1 values (1, '10:05:30');
Query OK, 1 row affected (0.00 sec)

select * from t1;
+------+----------+
| id   | t        |
+------+----------+
|    1 | 10:05:30 |
+------+----------+
1 row in set (0.00 sec)

Then, check the contents from mysqlsh
mysql-js> db.t1.select()
+----+------+
| id | t    |
+----+------+
|  1 | true |
+----+------+
1 row in set (0.00 sec)

How to repeat:
See above

[2 May 2016 5:04] MySQL Verification Team

Hello Giuseppe,

Thank you for the report and test case.
Verified as described.

Thanks,
Umesh

[24 Aug 2016 16:15] David Moss

Posted by developer:
 
Thank you for your feedback, this has been fixed in upcoming versions and the following was added to the 1.0.5 changelog:
Columns specified as TIME were being displayed by MySQL Shell as BOOLEAN.