开发者

Formatted SQL With Comment

开发者 https://www.devze.com 2023-02-15 20:41 出处:网络
I can\'t get my comment added to the liquibase change log table. When I do a updateSQL the generated insert for the log table has a blank string for the comment I added no matter what format of commen

I can't get my comment added to the liquibase change log table. When I do a updateSQL the generated insert for the log table has a blank string for the comment I added no matter what format of comment I try to use. My file looks like the one below.

Any ideas on how to add a comment so it gets inserted into the log table? I also tried adding c开发者_高级运维omment to the brackets with no luck like (comment:Test this out.)

--liquibase formatted sql

    --changeset bob:REL01 (splitStatements:false endDelimiter:;) 
    --comment TESTING OUT A COMMENT

    DROP SCHEMA public;


    --rollback CREATE SCHEMA public
    --rollback  AUTHORIZATION postgres;

    --rollbackGRANT ALL ON SCHEMA public TO postgres;
    --rollbackGRANT ALL ON SCHEMA public TO public;
    --rollbackCOMMENT ON SCHEMA public IS 'standard public schema';


The formatted SQL parser does not support setting comments. It is not that it is trying to set the comments but it is not grabbing the string correctly, it just does not look for a --comment string at all.

Nathan

0

精彩评论

暂无评论...
验证码 换一张
取 消