Facing Unterminated dollar quote started at position 3 in SQL DO $$ for postgresql migration

相关文章推荐

发怒的红烧肉 · Analysis of movement ...· 1 周前 ·

狂野的荔枝 · How to write an excel ...· 4 月前 ·

风流的火柴 · 在Qt ...· 4 月前 ·

兴奋的玉米 · 在线中文分词_在线关键词抽取_在线文章关键字 ...· 5 月前 ·

豪爽的刺猬 · 调用Python对象时超出了最大递归深度· 8 月前 ·

Hello,

I am struggling with an unterminated dollar quote error when I did a postgresql migration

The SQL is very simple , The below runs well when I connect to Postgresql with UI tool , however when I put in it liquibase I got unterminated dollar quote error. Per the stack trace the error was thrown by postgresql , since it works well on UI I am wondering if liquibase chunk the SQL at the first ; instead of sending everything between $$?

DO $$
DECLARE
var_timeseries_id BIGINT ;
var_constituent_timeseries_id BIGINT ;
BEGIN

END $$;

Caused by: liquibase.exception.DatabaseException: Unterminated dollar quote started at position 3 in SQL DO $$
DECLARE
var_timeseries_id BIGINT. Expected terminating $$ [Failed SQL: (0) DO $$
DECLARE
var_timeseries_id BIGINT]
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:445)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160)
at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1270)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1252)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:702)
… 56 common frames omitted
Caused by: org.postgresql.util.PSQLException: Unterminated dollar quote started at position 3 in SQL DO $$
DECLARE
var_timeseries_id BIGINT. Expected terminating $$
at org.postgresql.core.Parser.checkParsePosition(Parser.java:1443)
at org.postgresql.core.Parser.parseSql(Parser.java:1342)
at org.postgresql.core.Parser.replaceProcessing(Parser.java:1294)
at org.postgresql.core.CachedQueryCreateAction.create(CachedQueryCreateAction.java:43)
at org.postgresql.core.QueryExecutorBase.createQueryByKey(QueryExecutorBase.java:369)
at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:313)
at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:441)
… 61 common frames omitted