[teiid-issues] [JBoss JIRA] (TEIID-1655) CLONE - Error messages displayed in the transformation editor are often too generic or too long to be useful

Thu Feb 23 10:14:38 EST 2012

     [ https://issues.jboss.org/browse/TEIID-1655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins closed TEIID-1655.
---------------------------------


> CLONE - Error messages displayed in the transformation editor are often too generic or too long to be useful
> ------------------------------------------------------------------------------------------------------------
>
>                 Key: TEIID-1655
>                 URL: https://issues.jboss.org/browse/TEIID-1655
>             Project: Teiid
>          Issue Type: Task
>          Components: Query Engine
>    Affects Versions: 7.5
>            Reporter: Michael Walker
>            Assignee: Steven Hawkins
>             Fix For: 7.5
>
>
> Error messages are too long to be readable, and are often not specific enough to be useful. For example, if you mistakenly add a semi-colon to a LOOP statement, you should get an error informing you that there's an invalid semi-colon. The location of the error should be highlighted in a fashion similar to Eclipse's Java editor syntax highlighter. A suggestion ("invalid semi-colon?") could also be provided.
> Instead, you get a generic message that references the wrong location of the error:
> The query is not parsable.
> Parsing error: Encountered "END" at line 1, column 1982.
> Was expecting one of:
>     "from" ...
>     "limit" ...
>     "order" ...
>     ";" ...
>     "union" ...
>     "option" ...
> Here's another example of an error message with a description so long it is useless:
> WARNING <DQP|0> Received exception processing request:
> [QueryParserException]Parsing error: Encountered "case when formattimestamp ( curdate ( ) , \'MMMyy\' ) = formattimestamp ( parsedate ( \'StringValue\' , \'MMMyy\' ) , \'MMMyy\' ) then ( case when ( parsedate ( formattimestamp ( IMED_DM.GRANT_DETAIL.DECISION_DTM , \'MMMyy\' ) , \'MMMyy\' ) > parsedate ( formattimestamp ( timestampadd ( SQL_TSI_MONTH , -1 , curdate ( ) ) , \'MMMyy\' ) , \'MMMyy\' ) or IMED_DM.GRANT_DETAIL.DECISION_DTM is null ) and IMED_DM.GRANT_STATUS_MAPPING.REPORT_STATUS_TXT = \"In Review\" and IMED_DM.GRANT_DETAIL.SUBMITTED_DTM is not null and IMED_DM.GRANT_DETAIL.GRC_REQUIRED_FLAG = \'Y then 1 else 0 end)\r\n\r\nwhen (parsedate(formattimestamp(IMED_DM.GRANT_DETAIL.DECISION_DTM,\' MMMyy" at line 1, column 12.
> Was expecting one of:
> "count" ...
> "sum" ...
> "avg" ...
> "min" ...
> "max" ...
> "distinct" ...
> "false" ...
> "null" ...
> "true" ...
> <VARIABLE> ...
> <DATETYPE> ...
> <TIMETYPE> ...
> <TIMESTAMPTYPE> ...
> <BOOLEANTYPE> ...
> <INTEGERVAL> ...
> <FLOATVAL> ...
> <STRINGVAL> ...
> "(" ...
> "{" ...
> "?" ...
> "convert" ...
> "cast" ...
> "timestampadd" ...
> "timestampdiff" ...
> "left" ...
> "right" ...
> "char" ...
> "insert" ...
> "translate" ...
> "case" "?" ...
> "case" <STRINGVAL> ...
> "case" <INTEGERVAL> ...
> "case" <FLOATVAL> ...
> "case" "false" ...
> "case" "true" ...
> "case" "null" ...
> "case" <BOOLEANTYPE> ...
> "case" <TIMESTAMPTYPE> ...
> "case" <DATETYPE> ...
> "case" <TIMETYPE> ...
> "case" "{" ...
> "case" "count" ...
> "case" "sum" ...
> "case" "avg" ...
> "case" "min" ...
> "case" "max" ...
> "case" "convert" ...
> "case" "cast" ...
> "case" "timestampadd" ...
> "case" "timestampdiff" ...
> "case" "left" ...
> "case" "right" ...
> "case" "char" ...
> "case" "insert" ...
> "case" "translate" ...
> "case" <VARIABLE> ...
> "case" "(" ...
> "case" "case" ...
> "case" "when" "not" ...
> "case" "when" "?" ...
> "case" "when" <STRINGVAL> ...
> "case" "when" <INTEGERVAL> ...
> "case" "when" <FLOATVAL> ...
> "case" "when" "false" ...
> "case" "when" "true" ...
> "case" "when" "null" ...
> "case" "when" <BOOLEANTYPE> ...
> "case" "when" <TIMESTAMPTYPE> ...
> "case" "when" <DATETYPE> ...
> "case" "when" <TIMETYPE> ...
> "case" "when" "{" ...
> "case" "when" "count" ...
> "case" "when" "sum" ...
> "case" "when" "avg" ...
> "case" "when" "min" ...
> "case" "when" "max" ...
> "case" "when" "convert" ...
> "case" "when" "cast" ...
> "case" "when" "timestampadd" ...
> "case" "when" "timestampdiff" ...
> "case" "when" "left" ...
> "case" "when" "right" ...
> "case" "when" "char" ...
> "case" "when" "insert" ...
> "case" "when" "translate" ...
> "case" "when" <VARIABLE> "(" "?" ...
> "case" "when" <VARIABLE> "(" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" "false" ...
> "case" "when" <VARIABLE> "(" "true" ...
> "case" "when" <VARIABLE> "(" "null" ...
> "case" "when" <VARIABLE> "(" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" "{" ...
> "case" "when" <VARIABLE> "(" "count" ...
> "case" "when" <VARIABLE> "(" "sum" ...
> "case" "when" <VARIABLE> "(" "avg" ...
> "case" "when" <VARIABLE> "(" "min" ...
> "case" "when" <VARIABLE> "(" "max" ...
> "case" "when" <VARIABLE> "(" "convert" ...
> "case" "when" <VARIABLE> "(" "cast" ...
> "case" "when" <VARIABLE> "(" "timestampadd" ...
> "case" "when" <VARIABLE> "(" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" "left" ...
> "case" "when" <VARIABLE> "(" "right" ...
> "case" "when" <VARIABLE> "(" "char" ...
> "case" "when" <VARIABLE> "(" "insert" ...
> "case" "when" <VARIABLE> "(" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "{" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "count" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "sum" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "avg" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "min" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "max" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "convert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "cast" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "timestampadd" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "left" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "right" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "char" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "insert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" <VARIABLE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "(" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" "case" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> "," ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "any" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "some" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "all" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "{" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "count" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "sum" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "avg" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "min" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "max" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "convert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "cast" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "timestampadd" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "left" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "right" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "char" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "insert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "{" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "count" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "sum" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "avg" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "min" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "max" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "convert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "cast" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "timestampadd" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "left" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "right" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "char" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "insert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> "," ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> "," ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "*" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "/" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "+" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "-" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "||" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "and" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "or" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "{" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "count" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "sum" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "avg" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "min" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "max" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "convert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "cast" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "timestampadd" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "left" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "right" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "char" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "insert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" <VARIABLE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <TIMESTAMPTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <DATETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <TIMETYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "{" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "count" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "sum" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "avg" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "min" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "max" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "convert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "cast" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "timestampadd" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "timestampdiff" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "left" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "right" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "char" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "insert" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "translate" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" <VARIABLE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "(" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" "?" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" <STRINGVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" <INTEGERVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" <FLOATVAL> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" "false" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" "true" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" "null" ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")" "=" <VARIABLE> "(" <VARIABLE> "(" <STRINGVAL> "," <STRINGVAL> ")" "," <STRINGVAL> ")" "then" "(" "case" <BOOLEANTYPE> ...
> "case" "when" <VARIABLE> "(" <VARIABLE> "(" ")" "," <STRINGVAL> ")"
> [insert another 100K characters here]
> ...
> at
> com.metamatrix.query.parser.QueryParser.convertParserException(QueryParser.java:252)
> at com.metamatrix.query.parser.QueryParser.parseCommandWithParser(QueryParser.java:156)
> at com.metamatrix.query.parser.QueryParser.parseCommand(QueryParser.java:129)
> at com.metamatrix.dqp.internal.process.MetaDataProcessor.obtainMetadataForPreparedSql(MetaDataProcessor.java:217)
> at com.metamatrix.dqp.internal.process.MetaDataProcessor.processMessage(MetaDataProcessor.java:122)
> at com.metamatrix.dqp.internal.process.MessageHandler.process(MessageHandler.java:91)
> at com.metamatrix.dqp.message.MetaDataMessage.process(MetaDataMessage.java:127)
> at com.metamatrix.dqp.internal.process.MessageHandler.processMessage(MessageHandler.java:73)
> at com.metamatrix.dqp.internal.process.DQPCore.process(DQPCore.java:269)
> at com.metamatrix.dqp.internal.application.DQPComponent.processInternal(DQPComponent.java:119)
> at com.metamatrix.dqp.internal.application.DQPComponent.access$000(DQPComponent.java:48)
> at com.metamatrix.dqp.internal.application.DQPComponent$InternalServerListener.receive(DQPComponent.java:196)
> at com.metamatrix.dqp.internal.application.DQPComponent.receive(DQPComponent.java:263)
> at com.metamatrix.server.query.service.QueryServiceEngine.receive(QueryServiceEngine.java:498)
> at com.metamatrix.common.comm.platform.server.FilteringMessageServiceAgent.receive(FilteringMessageServiceAgent.java:40)
> at com.metamatrix.common.comm.platform.server.MessageFilterServiceAgent.receive(MessageFilterServiceAgent.java:81)
> at com.metamatrix.platform.admin.apiimpl.RuntimeStateListenerAgent.receive(RuntimeStateListenerAgent.java:90)
> at com.metamatrix.common.comm.platform.socket.SocketVMController.receive(SocketVMController.java:377)
> at com.metamatrix.common.comm.platform.socket.server.ServerAsynchronousWorkItem.process(ServerAsynchronousWorkItem.java:34)
> at com.metamatrix.common.comm.platform.socket.server.SocketServerWorker.process(SocketServerWorker.java:34)
> at com.metamatrix.common.queue.QueueWorker.run(QueueWorker.java:64)

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira