Bug Report: IBM i Results Panel Doesn't Display Embedded Spaces

Wright4i commented 1 month ago

Description

When the results are shown in the Results panel any embedded spaces in a field are squashed into a single space.

To Reproduce

SELECT 
    firstnme CONCAT ' ' CONCAT midinit CONCAT ' ' CONCAT  lastname AS fullname,
    firstnme CONCAT ' ' CONCAT midinit CONCAT '      ' CONCAT lastname AS extraspaces
FROM 
    sample.employee

Expected behavior

Show every space.

Screenshots

Additional Information

The Trace shows the JSON had the spaces returned so the issue likely lies outside of the data fetching mechanism.

<hr>
<b>[DATASTREAM_OUT]: </b><i>2024-08-07.13.19.58.918</i>
<font color="DarkSlateBlue">
<blockquote>
<pre>
{"id":"query38","has_results":true,"update_count":-1,"metadata":{"column_count":2,"job":"682632/QUSER/QZDASOINIT","columns":[{"name":"FULLNAME","type":"VARCHAR","display_size":28,"label":"FULLNAME"},{"name":"EXTRASPACES","type":"VARCHAR","display_size":34,"label":"EXTRASPACES"}]},"data":[["CHRISTINEIHAAS","CHRISTINEI      HAAS"],["MICHAELLTHOMPSON","MICHAELL      THOMPSON"],["SALLYAKWAN","SALLYA      KWAN"],["JOHNBGEYER","JOHNB      GEYER"],["IRVINGFSTERN","IRVINGF      STERN"],["EVADPULASKI","EVAD      PULASKI"],["EILEENWHENDERSON","EILEENW      HENDERSON"],["THEODOREQSPENSER","THEODOREQ      SPENSER"],["VINCENZOGLUCCHESSI","VINCENZOG      LUCCHESSI"],["SEAN O\u0027CONNELL","SEAN       O\u0027CONNELL"],["DELORESMQUINTANA","DELORESM      QUINTANA"],["HEATHERANICHOLLS","HEATHERA      NICHOLLS"],["BRUCE ADAMSON","BRUCE       ADAMSON"],["ELIZABETHRPIANKA","ELIZABETHR      PIANKA"],["MASATOSHIJYOSHIMURA","MASATOSHIJ      YOSHIMURA"],["MARILYNSSCOUTTEN","MARILYNS      SCOUTTEN"],["JAMESHWALKER","JAMESH      WALKER"],["DAVID BROWN","DAVID       BROWN"],["WILLIAMTJONES","WILLIAMT      JONES"],["JENNIFERKLUTZ","JENNIFERK      LUTZ"],["JAMESJJEFFERSON","JAMESJ      JEFFERSON"],["SALVATOREMMARINO","SALVATOREM      MARINO"],["DANIELSSMITH","DANIELS      SMITH"],["SYBILPJOHNSON","SYBILP      JOHNSON"],["MARIALPEREZ","MARIAL      PEREZ"],["ETHELRSCHNEIDER","ETHELR      SCHNEIDER"],["JOHNRPARKER","JOHNR      PARKER"],["PHILIPXSMITH","PHILIPX      SMITH"],["MAUDEFSETRIGHT","MAUDEF      SETRIGHT"],["RAMLALVMEHTA","RAMLALV      MEHTA"],["WING LEE","WING       LEE"],["JASONRGOUNOT","JASONR      GOUNOT"],["DIANJHEMMINGER","DIANJ      HEMMINGER"],["GREG ORLANDO","GREG       ORLANDO"],["KIMNNATZ","KIMN      NATZ"],["KIYOSHI YAMAMOTO","KIYOSHI       YAMAMOTO"],["REBAKJOHN","REBAK      JOHN"],["ROBERTMMONTEVERDE","ROBERTM      MONTEVERDE"],["EILEENRSCHWARTZ","EILEENR      SCHWARTZ"],["MICHELLEFSPRINGER","MICHELLEF      SPRINGER"],["HELENA WONG","HELENA       WONG"],["ROYRALONZO","ROYR      ALONZO"]],"is_done":true,"success":true}
</pre>
</blockquote>
</font>

Environment

OS: Windows 11 & Mac Sonoma
Extension Version: v1.1.4

worksofliam commented 1 month ago

Thanks for the great report. Should be a simple CSS fix I think. Also, we don't use a monospaced font so it might not look the same as ACS. Nonetheless, we will get it done!

Wright4i commented 1 month ago

Thanks for the great report. Should be a simple CSS fix I think. Also, we don't use a monospaced font so it might not look the same as ACS. Nonetheless, we will get it done!

100% fine not looking like ACS (DB2 for i is better anyway 😜). Not sure this is a CSS/rendering issue because selecting the text and pasting outside results in a single space and not multiple, but I could be wrong.

worksofliam commented 1 month ago

Guessing we need to use &nbsp: https://stackoverflow.com/a/17784809/4763757

codefori / vscode-db2i