Comments Removed?

[BrandonC]

I threw some code in the tool yesterday morning, and had a huge chunk of comments go missing.  It might have something to do with a collect statement or the fact that the comments were a create table that was not necessary at the time, but left in the code in case it might be needed in the future.  I don’t think that’s too uncommon.  Here’s the original (simplified):

• SEL * FROM VOL_TABLE
• COLLECT STATISTICS COLUMN (DATE) ON VOL_TABLE;
• 30 lines of commented out code
• DELETE TABLE2
• INSERT INTO TABLE2…

The output has:

• SELECT * FROM PUBLIC.VOL_TABLE
• A single new line
• DELETE FROM ;
• INSERT INTO PUBLIC.TABLE2

Is that Collect statement throwing things off?  Or just too many comments?   I think the output is still functionally the same.  Just curious as to why that would happen during the transformation.

Thanks.

[ovasquez]

Hi Brandon,

Thanks for the feedback

This is a known issue and we're working towards a general solution for preserving comments in all conversions. Current target for the solution is Q1 of this year.

Regards,
Oscar Vasquez