开发者

Formatted SQL With Comment

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜