search

microsoft / azuredatastudio

Azure Data Studio is a data management and development tool with connectivity to popular cloud and on-premises databases. Azure Data Studio supports Windows, macOS, and Linux, with immediate capability to connect to Azure SQL and SQL Server. Browse the extension library for more database support options including MySQL, PostgreSQL, and MongoDB.
https://learn.microsoft.com/sql/azure-data-studio
MIT License
7.58k stars 903 forks source link

Issue: Removes "<ns0: " from xml result #25220

Open pceglie opened 10 months ago

pceglie commented 10 months ago

Steps to Reproduce:

  1. SELECT from a table with an xml field

    select cast('
<ns0:Configuration xmlns:ns0="http://schemas.microsoft.com">
<Moduli>
    <Modulo Id="2E090E44-DD4E-4FCA-9080-1990A20FBA0A" IdForm="E9428962-AFBA-4432-9853-37AD52D20179" Name="Proc1" />
    <Modulo Id="E3D53C7C-3131-4033-B5A2-E1E6C3DEA425" IdForm="F47FF3B3-35E2-4979-BFEF-FD476785778A" Name="Proc2" />
    <Modulo Id="CEF359A3-5E76-4704-81D2-921D05B6B86C" IdForm="B95AE0E3-6C10-47C8-80B6-FC5361237E13" Name="Proc3" />
</Moduli>
</ns0:Configuration>' as xml) as xml_result

  2. Click on xml_result cell. image

As you can see the first part was removed image

SQL Server Management Studio is not affected from that issue. image

image

Does this issue occur when all extensions are disabled?: Yes

Same issue reported here https://github.com/microsoft/azuredatastudio/issues/13037

cheenamalhotra commented 10 months ago

Can confirm this occurs as far as 1.41.. needs RCA

pceglie commented 10 months ago

Yes, as you can see on top of my post the version is the last (1.47.1). Regards