PyTd icon indicating copy to clipboard operation
PyTd copied to clipboard

teradata.BteqScript is not splitting correctly when semicolons exist inside comments.

Open mikedine opened this issue 9 years ago • 0 comments

I am having problems with bteqsplit() when semicolons are included inside comments.

The bteqsplit is finding the semicolon and producing an invalid sql statement.

Some of the examples I have encounter are:

Bad Example 1 FROM MY_DB.MY_CUSTOM_VIEW --; GROUP BY

Bad Example 2 FROM MY_DB.MY_CUSTOM_VIEW /* Present Insert records ; */ GROUP BY

Bad Example 3 FROM MY_DB.MY_CUSTOM_VIEW --; GROUP BY

Bad Example 4 FROM MY_DB.MY_CUSTOM_VIEW /* ; /* GROUP BY

Thanks, Mike

mikedine avatar Oct 18 '16 06:10 mikedine