February 2010 - teiid-designer-issues

[JBoss JIRA] Moved: (TEIIDDES-361) Feature Request - auto generate primary key for model results

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-361?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-826 to TEIIDDES-361: --------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-361 (was: JBEDSP-826) Component/s: Modeling (was: Designer) Fix Version/s: Future (was: Future Versions) Affects Version/s: (was: 5.5.3) > Feature Request - auto generate primary key for model results > ------------------------------------------------------------- > > Key: TEIIDDES-361 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-361 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Debbie Steigner > Fix For: Future > > > When the results from a Metadata model search, return data that doesn't have a natural row identifier > (e.g. results from a web search, where only text is returned) is there a way to auto generate a simple primary key identifier value, e.g. rowid in oracle -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-363) Add the option in Validation Preferences for 'cross-join'

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-363?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-1067 to TEIIDDES-363: ---------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-363 (was: JBEDSP-1067) Component/s: (was: Designer) Fix Version/s: Future (was: Future Versions) > Add the option in Validation Preferences for 'cross-join' > --------------------------------------------------------- > > Key: TEIIDDES-363 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-363 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: Future > > > Add option to ignore the cross-join warning. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-360) Better Xquery Support

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-360?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-154 to TEIIDDES-360: --------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-360 (was: JBEDSP-154) Component/s: Modeling (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5) > Better Xquery Support > ---------------------- > > Key: TEIIDDES-360 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-360 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Marc Shirley > Priority: Minor > > it would be nice to have the Xquery transformations automated like relational. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-359) Error messages displayed in the transformation editor are often too generic or too long to be useful

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-359?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-1179 to TEIIDDES-359: ---------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-359 (was: JBEDSP-1179) Component/s: (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5) > Error messages displayed in the transformation editor are often too generic or too long to be useful > ---------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-359 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-359 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Michael Walker > Assignee: Barry LaFond > > 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 contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-357) Would like XML Schema as Relational Source Model importer to accept sample XMLs or DTDs as well as XSDs

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-357?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-1177 to TEIIDDES-357: ---------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-357 (was: JBEDSP-1177) Component/s: Modeling (was: Designer) Fix Version/s: (was: Future Versions) > Would like XML Schema as Relational Source Model importer to accept sample XMLs or DTDs as well as XSDs > ------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-357 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-357 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Debbie Steigner > Assignee: Barry LaFond > > The was a complaint that we were unable to build models for use with the XML-Relational connectors directly off their DTD (attached). Instead they had to use an external product to convert the DTD to an XSD, and then use the XSD as input to the importer. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-358) XML Modeling Enhancement - better visualization

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-358?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-68 to TEIIDDES-358: -------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-358 (was: JBEDSP-68) Component/s: Modeling (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5.1) (was: Future Versions) > XML Modeling Enhancement - better visualization > ----------------------------------------------- > > Key: TEIIDDES-358 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-358 > Project: Teiid Designer > Issue Type: Feature Request > Components: Modeling > Reporter: Debbie Steigner > > XML Modeling - would like to have a better visualization of the schema - it is metadata and it is important in XML document modeling -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-356) Request ability to include/create a library file in virtual procedures

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-356?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-631 to TEIIDDES-356: --------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-356 (was: JBEDSP-631) Component/s: (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5.2) > Request ability to include/create a library file in virtual procedures > ---------------------------------------------------------------------- > > Key: TEIIDDES-356 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-356 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Debbie Steigner > Assignee: Barry LaFond > > From Issue Tracker #217199 - Customer requests ability to include/create a library file in virtual procedures. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-355) Designer - Add context sensitive help

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-355?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-613 to TEIIDDES-355: --------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-355 (was: JBEDSP-613) Component/s: (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5.3) > Designer - Add context sensitive help > -------------------------------------- > > Key: TEIIDDES-355 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-355 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Warren Gibson > Assignee: Barry LaFond > > Add context sensitive help to MM Designer -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-354) WSDL to Relational Importer is not modeling attributes correctly.

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-354?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-1176 to TEIIDDES-354: ---------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-354 (was: JBEDSP-1176) Component/s: Import/Export (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5.2) (was: 5.5.3) > WSDL to Relational Importer is not modeling attributes correctly. > ----------------------------------------------------------------- > > Key: TEIIDDES-354 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-354 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Reporter: John Doyle > Assignee: John Doyle > > Import the attached WSDL. In the find service table the generic, businessKey and maxRows columns should all have values in the DataAttributName property. Since they do not they are created as elements in the request. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIIDDES-353) WSDL to Relational Importer is not modeling relationship tables (shared children) correctly.

by Van Halbert (JIRA)

[ https://jira.jboss.org/jira/browse/TEIIDDES-353?page=com.atlassian.jira.p... ] Van Halbert moved JBEDSP-1175 to TEIIDDES-353: ---------------------------------------------- Project: Teiid Designer (was: JBoss Enterprise Data Services Platform) Key: TEIIDDES-353 (was: JBEDSP-1175) Component/s: (was: Designer) Fix Version/s: (was: Future Versions) Affects Version/s: (was: 5.5.2) (was: 5.5.3) > WSDL to Relational Importer is not modeling relationship tables (shared children) correctly. > -------------------------------------------------------------------------------------------- > > Key: TEIIDDES-353 > URL: https://jira.jboss.org/jira/browse/TEIIDDES-353 > Project: Teiid Designer > Issue Type: Bug > Reporter: John Doyle > Assignee: John Doyle > > The WSDL for the attached model defines a operation called find_service. The XSD for this message uses the name type in both the request and response. This shared child relationship should be modeled with a relationship table, but the model created leaves the name type with no keyed relations. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira

14 years, 10 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues February 2010