2 Replies Latest reply on Nov 8, 2017 5:15 AM by sameer P

    JsonToXml function with _x in element tag return wrong result

    sameer P Newbie

      On doing such queries on latest Teiid:

      select jsontoxml('root', '{ "my_xvar" : "my_value"}');;


      Would return  an XML:


      <?xml version='1.0' encoding='UTF-8'?><root xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><my_u005F_xvar>my_value</my_u005F_xvar></root>


      . Is this expected? Or is there any other way to avoid it?