Bug #109792 database treview - table column list is incomplete
Submitted: 26 Jan 2023 13:52 Modified: 12 Apr 2023 11:27
Reporter: ROBERT SILVA ROBERT Email Updates:
Status: Can't repeat Impact on me:
None 
Category:Shell VSCode Extension Severity:S2 (Serious)
Version:1.7.0 OS:Windows (WSL2)
Assigned to: CPU Architecture:x86

[26 Jan 2023 13:52] ROBERT SILVA ROBERT 
Description:
Drilldown (database treeview/explorer) is no showing the complete list of columns for the tables. 

How to repeat:
When browsing a database using the treeview, just drilldown and table to column level and the column list does not show all the columns for the selected table.
[26 Jan 2023 14:11] MySQL Verification Team 
Hello ROBERT,

Thank you for the report and feedback.
Verified as described.

regards,
Umesh
[26 Jan 2023 14:13] MySQL Verification Team 
- Sample table 

CREATE TABLE bug109792 (
       c1 CHAR(255),c2 CHAR(255),c3 CHAR(255),
       c4 CHAR(255),c5 CHAR(255),c6 CHAR(255),
       c7 CHAR(255),c8 CHAR(255),c9 CHAR(255),
       c10 CHAR(255),c11 CHAR(255),c12 CHAR(255),
       c13 CHAR(255),c14 CHAR(255),c15 CHAR(255),
       c16 CHAR(255),c17 CHAR(255),c18 CHAR(255),
       c19 CHAR(255),c20 CHAR(255),c21 CHAR(255),
       c22 CHAR(255),c23 CHAR(255),c24 CHAR(255),
       c25 CHAR(255),c26 CHAR(255),c27 CHAR(255),
       c28 CHAR(255),c29 CHAR(255),c30 CHAR(255),
       c31 CHAR(255),c32 CHAR(255),c33 CHAR(255)
       ) ENGINE=InnoDB;

-- VSCode view - only 8 columns are visible(uploading screen shot shortly)
[26 Jan 2023 14:15] MySQL Verification Team 
VSCode 1.7.0 screenshot

Attachment: 109792.jpg (image/jpeg, text), 80.62 KiB.
[12 Apr 2023 9:57] MySQL Verification Team 
I can confirm that this issue is no longer seen with MySQL Shell for VS Code 1.9.1+8.0.32 Preview. All the columns are visible.

VS Code version using :

Version: 1.75.1
Commit: 441438abd1ac652551dbe4d408dfcec8a499b8bf
Date: 2023-02-08T21:32:34.589Z
Electron: 19.1.9
Chromium: 102.0.5005.194
Node.js: 16.14.2
V8: 10.2.154.23-electron.0
OS: Windows_NT x64 10.0.22000
Sandboxed: No
[12 Apr 2023 10:00] MySQL Verification Team 
Screenshot

Attachment: 109792_1.9.1.jpg (image/jpeg, text), 156.21 KiB.
[12 Apr 2023 11:27] Miguel Tadeu Mota 
Posted by developer:
 
Thanks. Closing this one.