Description: hierarchyid column type are not present in xml data table and the validation is failing with message:
"T_6.0-2: [ERROR] - Validation against XSD failed. - cvc-complex-type.2.4.b: The content of element 'row' is not complete. One of '{"http://www.admin.ch/xmlns/siard/2/schema1/table1.xsd":c4}' is expected. At line 1, column 292 on content/schema1/table1/table1.xml
Requirements for table data [FAILED]"
Context:
DBPTK Desktop: Windows 2022, SQL 2022, DBPTK 2.9
Steps required to reproduce the bug:
Create table with at least on hierarchyid column, ex:
CREATE TABLE [HR].[Employee](
[Id] [int] IDENTITY(1,1) NOT NULL,
[FirstName] nvarchar NOT NULL,
[LastName] nvarchar NOT NULL,
[hid] [hierarchyid] NOT NULL,
);
INSERT INTO HR.Employee (FirstName, LastName, hid)
VALUES ('John', 'Doe', '/'); -- conversion implicite
INSERT INTO HR.Employee (FirstName, LastName, hid)
VALUES ('John2', 'Doe2', '/1/'); -- conversion implicite
Description: hierarchyid column type are not present in xml data table and the validation is failing with message:
"T_6.0-2: [ERROR] - Validation against XSD failed. - cvc-complex-type.2.4.b: The content of element 'row' is not complete. One of '{"http://www.admin.ch/xmlns/siard/2/schema1/table1.xsd":c4}' is expected. At line 1, column 292 on content/schema1/table1/table1.xml Requirements for table data [FAILED]"
Context:
Steps required to reproduce the bug:
Create table with at least on hierarchyid column, ex: CREATE TABLE [HR].[Employee]( [Id] [int] IDENTITY(1,1) NOT NULL, [FirstName] nvarchar NOT NULL, [LastName] nvarchar NOT NULL, [hid] [hierarchyid] NOT NULL, ); INSERT INTO HR.Employee (FirstName, LastName, hid) VALUES ('John', 'Doe', '/'); -- conversion implicite INSERT INTO HR.Employee (FirstName, LastName, hid) VALUES ('John2', 'Doe2', '/1/'); -- conversion implicite
Create Siard file
Validate and it should fail
Attach any relevant logs below. dbptk-validation-reporter-TestHID-20240423101021491.txt