× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2013-07-17T20:45:01Z  · last modified 2013-07-29T22:52:08Z

import is removing double quotes from user data for Azure XML type


Dev
Jenny Nishimura
JennyNishimura
QA
Nhi Lam
nhilam
Priority Low
Complexity Unknown
Component Tools - Import Tool
Version 14.0
Version: 14.0.0-beta-67
Build #: 33233
Build Date: 2013-Jul-17 11:22:50 AM
 
SQL AZURE
 
When  you try to import XML data, the double quotes from the user data is getting removed and import gives an error. To reproduce,
 
Create below table
 

 

CREATE TABLE [dbo].[TEST_XML_1]  ( 

        [BIGINTS]       bigint NULL,

        [XMLS]          xml NULL 

        )

GO

CREATE CLUSTERED INDEX [inx1]

        ON [dbo].[TEST_XML_1]([BIGINTS])

GO

 
 
Import from the attached file.
 
You get Error: Row: 1 -- XML parsing: line 1, character 21, A string literal was expected

 

     SQL: INSERT INTO [dbo].[TEST_XML_1]([BIGINTS], [XMLS])   VALUES(1, '<customerinfo xmlns=posample.org Cid=1000><name>Kathy Smith</name><addr country=Canada><street>5 Rosewood</street><city>Toronto</city><prov-state>Ontario</prov-state><pcode-zip>M6W 1E6</pcode-zip></addr><phone type=work>416-555-1358</phone></customerinfo>')
 
Error: Row: 2 -- XML parsing: line 1, character 21, A string literal was expected
     SQL: INSERT INTO [dbo].[TEST_XML_1]([BIGINTS], [XMLS])   VALUES(2, '<customerinfo xmlns=posample.org Cid=1000><name>Kathy Smith</name><addr country=Canada><street>5 Rosewood</street><city>Toronto</city><prov-state>Ontario</prov-state><pcode-zip>M6W 1E6</pcode-zip></addr><phone type=work>416-555-1358</phone></customerinfo>')
 
2 attachments
  •  
  •  
  • No shares
  •  
All Comments (3) Change History
Sort 

Issue #9616
Closed
Fixed
Resolved 2013-07-24T18:09:40Z
 
 
Completion
No due date
Fixed Build ADS 14.0.0-beta-74
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017