Bug #119078 MySQL Shell for VS Code has different output formatting than MySQL Shell

• Submitted: 26 Sep 16:33
• Modified: 29 Sep 17:24
• Reporter: Torsten Lenk
• Status: Verified
• Category: Shell VSCode Extension
• Severity: S3 (Non-critical)
• Version: 1.19.17
• OS: Windows (11 Enterprise)
• CPU Architecture: x86 (11th Gen Intel(R) Core(TM) i7-1165G7 @ 2.80GHz )

[26 Sep 16:33] Torsten Lenk

Description:
Two issues that we found so far:

1) Dates
MySQL Shell for VS Code formats dates as: MM/DD/YYYY
MySQL Shell formats dates as: YYYY-MM-DD
This is confusing when you use string functions like SUBSTR(date,1,4)

2) Tiny Int
MySQL Shell for VS Code formats dates as: boolean
MySQL Shell formats dates as: int
This is confusing when you don't see the actual numbers

I understand the intensions behind it,
however please add a switch in the config to be able to turn this new behaviour off in MySQL Shell for VS Code 

How to repeat:
1) select NOW(), substr(now(),1,4)

2) 
CREATE TABLE tinyint_test (
  `number` tinyint(1) NOT NULL
); 
insert into tinyint_test (number) values (3);
select * from tinyint_test

Suggested fix:
display exactly as MySQL Shell or have a switch in config to display as MySQL Shell

[26 Sep 16:44] Torsten Lenk

(2) should read as...

2) TinyInt(1)
MySQL Shell for VS Code formats TinyInt(1) as: boolean
MySQL Shell formats TinyInt(1) as: int
This is confusing when you don't see the actual numbers

[29 Sep 17:24] MySQL Verification Team

Thank you for the report