[teiid-issues] [JBoss JIRA] (TEIID-3542) Logging does not print full queries which contain ESCAPE '\u0000' clause

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13080372#comment-13080372 ] 

Steven Hawkins commented on TEIID-3542:
---------------------------------------

I should back off of the previous comment a little.  A partial solution that would fix this specifically for the escape clause and string literals would be to update the sql string visitor logic to use the unicode escapes for control characters.  But that wouldn't be a complete solution as it could still appear in a logged value or other places.

> Logging does not print full queries which contain ESCAPE '\u0000' clause
> ------------------------------------------------------------------------
>
>                 Key: TEIID-3542
>                 URL: https://issues.jboss.org/browse/TEIID-3542
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.10.1
>         Environment: Possibly only happens on Linux.
>            Reporter: Paul Richardson
>            Assignee: Steven Hawkins
>            Priority: Trivial
>
> Queries submitted to Teiid containing the NUL character for the ESCAPE character are not properly printed to jboss logging.
> Seems that the NUL character can be used within java Strings but when the String is printed to the display, it terminates at the first NUL character it reaches. This result in "... ESCAPE '\u0000' ... being printed as "... ESCAPE '".
> See [here|https://gist.github.com/phantomjinx/fef25524e7e9844c4f3d] for an example of a jboss log with such a query.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)