如何删除带有格式化.sql changesets的Liquibase includeAll标记错误：找不到元素'database changelog'的声明

Question

<?xml version="1.0" encoding="utf-8"?>
<databaseChangeLog 
        xmlns="https://www.liquibase.org/xml/ns/dbchangelog"
        xmlns:xsi="https://www.w3.org/2001/XMLSchema-instance"
        xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog conf/xsd/dbchangelog-3.8.xsd">
    <includeAll path="***/includeAllScriptsTest/" relativeToChangelogFile="true"/>
</databaseChangeLog>

--liquibase formatted sql
--changeset author:1  dbms:MySQL splitStatements:true endDelimiter://

DROP PROCEDURE IF EXISTS `TESTINCLUDEALL`;//

CREATE PROCEDURE `TESTINCLUDEALL`()

BEGIN

SELECT * FROM TABLE;
END;//

Answer 1

CVC-ELT.1.A:找不到元素“Database Changelog”的声明

此错误是XML解析错误，在XML架构中没有声明指向DatabaseChangelog。

您可以尝试在Changelog中使用以下XSD：

<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog
                      http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.8.xsd">
    <includeAll path="***/includeAllScriptsTest/" relativeToChangelogFile="true"/>
</databaseChangeLog>