Ingestion Rules for XML

<< Click to Display Table of Contents >>

Navigation:  Integrating SQLstream Blaze with Other Systems > Reading Data into s-Server > Reading from Other Sources  > Input Formats for Reading > Reading XML >

Ingestion Rules for XML

Previous pageReturn to chapter overviewNext page

s-Server applies the following coercion rules when parsing XML data. All missing cells are cast as NULL.

XML source attribute/element

numeric string

non-numeric string

empty cell

BIGINT

DECIMAL

DOUBLE

INT

SMALLINT

REAL

TINYINT

Raise an exception if the number lies beyond the maximum or minimum boundary of the target type. If the number has any decimal digits (including the vacuous .0) and it is being ingested into an integer column, then raise an error.

Raise an error.

Error

(same as '')

BINARY

VARBINARY

Raise an error.

If the string, without quotes, is a valid SQL Standard BINARY literal, then we will ingest it, truncating and 0-filling as necessary. A Standard BINARY literal has the form X'...' where ... is a sequence of (case-insensitive) hex digits.

Error

(same as '')

BOOLEAN

FALSE

If the string is exactly "true", then the result is true. Otherwise, the result is false.

False

(same as '')

CHAR

VARCHAR

Put double-quotes around the number and then ingest subject to the truncation/padding rules for strings.

If the string won't fit in the target SQL character value, then excess trailing characters are discarded. CHAR values are space-padded up to their declared length.

Treat as empty string '', space-padding as necessary.

DATE

TIME

TIMESTAMP

Raise an error.

OK if the string parses as a DATE/TIME/TIMESTAMP. Otherwise, raise an error.

Strings are parsed per ISO standards at https://www.w3.org/TR/NOTE-datetime

Error

(same as '')