Liquibase在RedShift数据库中的应用问题

Question

我一直试图将这个（https://github.com/liquibase/liquibase-redshift/releases）插件用于我的Redshift数据库，但一直未能使其工作。我主要面临两个问题。

1. 无效操作：“tag”处或附近有语法错误。通过手动创建databasechangelog表，我解决了这个问题。
2. 将记录插入databasechangelog表时出错，原因是LB在insert查询中使用了now（）函数。

我看到这两个问题都被标记为已修复(https://github.com/liquibase/liquibase-redshift/issues/9)，然而，我仍然面临这些问题。由于项目的性质，我不能在jar文件中手动进行任何更改。因此,如果有人能对此提供任何见解,我将不胜感激。我还在changelog.xml文件中使用dbms=“redshift”。

事先谢谢你的帮助。

<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd">
    <changeSet author="devsh0" id="9.9.9.9" logicalFilePath="LOGICALPATH" runOnChange ="true" >
         <sqlFile 
            path="src/main/dbo/app-code.SQL"
            dbms="RedshiftDatabase"
            stripComments="true"
        />
    </changeSet>
</databaseChangeLog>

create table Test_Table
(
  col1   VARCHAR(3) not null,
  col2   VARCHAR(20) not null,
  col3   VARCHAR(50) not null
)

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  <modelVersion>4.0.0</modelVersion>
  <groupId>local_redshift</groupId>
  <artifactId>local_redshift</artifactId>
  <version>0.0.1-SNAPSHOT</version>
<repositories>
    <repository>
      <id>redshift</id>
      <url>https://s3.amazonaws.com/redshift-maven-repository/release</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>org.liquibase</groupId>
        <artifactId>liquibase-core</artifactId>
        <version>3.10.0</version>
    </dependency>
    <dependency>
       <groupId>com.amazon.redshift</groupId>
       <artifactId>redshift-jdbc42</artifactId>
       <version>1.2.43.1067</version>
    </dependency>
    <dependency>
        <groupId>org.liquibase.ext</groupId>
        <artifactId>liquibase-redshift</artifactId>
        <version>3.10.0</version>
    </dependency>
    <!--dependency>
        <groupId>org.yaml</groupId>
        <artifactId>snakeyaml</artifactId>
        <version>1.8</version>
    </dependency>  -->
</dependencies>
 <build>
        <plugins>
            <plugin>
                <groupId>org.liquibase</groupId>
                <artifactId>liquibase-maven-plugin</artifactId>
                <version>3.4.2</version>
                <configuration>
                   <propertyFile>src/main/liquibase.redshift.properties</propertyFile>
                   <changeLogFile>src/main/changelog/changelog-1.0.0.0.1.xml</changeLogFile>
                  <promptOnNonLocalDatabase>false</promptOnNonLocalDatabase>
                </configuration>
            </plugin>
        </plugins>
    </build>
</project>```

Answer 1

在您的changelog.xml中，它是dbms=“redshiftdatabase”-它应该是dbms=“redshift”:

<?xml version="1.1" encoding="UTF-8" standalone="no"?>
<databaseChangeLog xmlns="http://www.liquibase.org/xml/ns/dbchangelog" xmlns:ext="http://www.liquibase.org/xml/ns/dbchangelog-ext" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"  
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog-ext http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-ext.xsd http://www.liquibase.org/xml/ns/dbchangelog
http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.6.xsd">
    <changeSet author="devsh0" id="9.9.9.9" logicalFilePath="LOGICALPATH" runOnChange ="true" >
         <sqlFile 
            path="src/main/dbo/app-code.SQL"
            dbms="redshift"
            stripComments="true"
        />
    </changeSet>
</databaseChangeLog>

由于错误地指定了RedshiftDatabase将不会被使用。