BUG: code comments for sql formated files disappers

General Discussion
1

hello!

My name is Raste, i work on a project and it is kind of urgent to fix this bug.

i have comments in my plsql code, but these comments disappear when i deploy via liquibase.

here is my code:

–liquibase formatted sql

–changeset procedure_x_rbg_comment_test:4 (splitStatements:false)

create or replace function x_rbg_comment_test

as

v_sysdate date;

begin

–select into variable

/* select into variable*/

select sysdate

into v_sysdate

from dual ;

end;

the two comments after begin ( --select into variable and /* select into variable*/) disappear in this case, what i see in the database is something like this.

CREATE OR REPLACE function .x_rbg_comment_test

as

v_sysdate date;

begin

select sysdate

into v_sysdate

from dual ;

end;

OBS! i have latest version of liquibase Version: 3.3.5

Regards

Raste

2
By default, the stripComments setting is true, so Liquibase will remove all comments from the SQL before executing it. When defining your changeset, specify "stripComments:false" to prevent this from happening.
--changeset procedure_x_rbg_comment_test:4 splitStatements:false stripComments:false http://www.liquibase.org/documentation/sql_format.html
3

thanks for the answer, this will definetly solve the problem I have,just for your information I created an liquibase jira (CORE-2383 ) at the same time i created this bug report,as a solution to the jira default value to stripComments been changed to false in the newer version of liquibase .