| Bug #85647 | mysqlsh output wrong timestamp | ||
|---|---|---|---|
| Submitted: | 27 Mar 2017 12:28 | Modified: | 27 Mar 2017 12:45 |
| Reporter: | Rudi Broekhuizen | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: Document Store: MySQL Shell | Severity: | S3 (Non-critical) |
| Version: | 1.0.8-rc | OS: | Linux (Ubuntu 16.04.2 LTS) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | mysqlsh mysql-shell json | ||
[27 Mar 2017 12:31]
Rudi Broekhuizen
Using mysql command line: 2017-03-27 12:16:27.065341 | [boot] @ [] | 1 | 0 | Query | SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%partitioned%';
[27 Mar 2017 12:45]
MySQL Verification Team
Hello Rudi Broekhuizen, Thank you for the report. Thanks, Umesh
Description: Ubuntu 16.04.2 LTS MySQL: Ver 14.14 Distrib 5.7.17, for Linux MySQL Shell: Version 1.0.8-rc Using mysqlsh (MySQL Shell): query on general_log gives back wrong timestamp information. Date today is 27-03-2017: echo "select * from general_log;" | mysqlsh --schema=mysql --json=raw --sqlc --uri root@127.0.0.1:3306: {"event_time":{"year":2017,"month":2,"day":27,"hour":0,"minute":0,"second":0},"user_host":"[boot] @ []","thread_id":1,"server_id":0 ,"command_type":"Query","argument":"SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%parti tioned%';"} "month": 2, should be 3 "hour": 0, which is incorrect "minute": 0, which is incorrect "second": 0, which is incorrect --------------------------------------------------------------------------- echo "select * from mysql.general_log;" | mysqlsh --schema=mysql --sql --uri root@127.0.0.1:3306: 2017-03-27 0:00:00 | [boot] @ [] | 1 | 0 | Query | SELECT TABLE_SCHEMA, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE CREATE_OPTIONS LIKE '%partitioned%'; How to repeat: echo "select * from general_log;" | mysqlsh --schema=mysql --json=raw --sqlc --uri root@127.0.0.1:3306 echo "select * from mysql.general_log;" | mysqlsh --schema=mysql --sql --uri root@127.0.0.1:3306