LiquiBase.Exception.DatabaseException:ORA-00911:无效字符[失败的SQL:删除表$Y_USER_NAME}

Question

${MY_USER_NAME}

<?xml version="1.0" encoding="UTF-8"?>
  <databaseChangeLog
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
    xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.4.xsd">

  <include relativeToChangelogFile="true" file="changelogs.xml"/>

<?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.4.xsd">

<property name="MY_USER_NAME" value="LALA"/>
<include relativeToChangelogFile="true" file="TEST.sql"/>


</databaseChangeLog>

drop table ${MY_USER_NAME};

Answer 1

我找到了一个解决问题的方法，为了在sql文件中计算属性，应该包装sql而不包括sql。

所以相反

<include relativeToChangelogFile="true" file="TEST.sql"/>

应该使用这个

<changeSet author="xxx" id="my changeSet" >
<sqlFile  relativeToChangelogFile="true" encoding="utf8" path="TEST.sql"/>
</changeSet>