# BUG: code comments for sql formated files disappers

**URL:** <https://forum.liquibase.org/t/bug-code-comments-for-sql-formated-files-disappers/3235>\
**Category:** General Discussion\
**Created:** [June 2, 2015, 9:38pm UTC](https://forum.liquibase.org/t/bug-code-comments-for-sql-formated-files-disappers/3235 "2015-06-02T21:38:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![RastiBarzan](https://avatars.discourse-cdn.com/v4/letter/r/3ec8ea/32.png) [@RastiBarzan](https://forum.liquibase.org/u/RastiBarzan)\
**Post date:** [June 2, 2015, 9:38pm UTC](https://forum.liquibase.org/t/bug-code-comments-for-sql-formated-files-disappers/3235/1 "2015-06-02T21:38:00Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![un1434035135322r7id](https://avatars.discourse-cdn.com/v4/letter/u/87869e/32.png) [@un1434035135322r7id](https://forum.liquibase.org/u/un1434035135322r7id)\
**Post date:** [June 2, 2015, 9:38pm UTC](https://forum.liquibase.org/t/bug-code-comments-for-sql-formated-files-disappers/3235/2 "2015-06-02T21:38:00Z")

</div>

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](http://www.liquibase.org/documentation/sql_format.html "Liquibase Formatted SQL Documentation")

---

<div class="post-metadata">

**Author:** ![un1433253436981r3id](https://avatars.discourse-cdn.com/v4/letter/u/7993a0/32.png) [@un1433253436981r3id](https://forum.liquibase.org/u/un1433253436981r3id)\
**Post date:** [June 2, 2015, 9:38pm UTC](https://forum.liquibase.org/t/bug-code-comments-for-sql-formated-files-disappers/3235/3 "2015-06-02T21:38:00Z")

</div>

thanks for the answer, this will definetly solve the problem I have,just for your information I created an liquibase jira ([CORE-2383](https://liquibase.jira.com/browse/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 .
