July 2011 - teiid-issues - Jboss List Archives

[JBoss JIRA] Created: (TEIID-1684) Add a native type for InetAddresses

by Caleb Corliss (JIRA)

Add a native type for InetAddresses ------------------------------------ Key: TEIID-1684 URL: https://issues.jboss.org/browse/TEIID-1684 Project: Teiid Issue Type: Feature Request Reporter: Caleb Corliss Assignee: Steven Hawkins Priority: Minor Currently, we are unable to work directly with INET columns (Oracle or PostgreSQL.) It would be nice if there was a native type that could map INET columns to java.net.Inet4Address and java.netInet6Address objects at some time in the near future. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-1651) Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1651?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1651: --------------------------------------- Before closing this, one of the following needs to happen: 1. change the default to true for both 7.4.1 and trunk. This would require a release note to alert users of a behavioral change and the workaround 2. change the trunk default to false and updated the embedded odbc connection to set the property to true. The former change is needed so that we don't have to keep flipping the default in fix branches. The latter change is required for odbc metadata to work properly - as it requires the actual column name to perform a secondary lookup of the oid. > Due to a change in the JDBC spec on how the use of "AS" in the select statement will now be returned in the getColumnLabel of the ResultSetMetadata, Teiid must provide backwards support > ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ > > Key: TEIID-1651 > URL: https://issues.jboss.org/browse/TEIID-1651 > Project: Teiid > Issue Type: Bug > Components: JDBC Driver > Affects Versions: 7.4.1 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Blocker > Fix For: 7.4.1 > > > Teiid has already applied a fix to support the JDBC spec change for when an alias is used in the select clause. The spec change says the "AS" name will now be returned when getColumnLabel() is called, instead of getColumnName(). Unfortunately, this breaks backwards compatibility. To resolve the issue, the JDBC driver, to provide support for backwards compatibility, can allow the user to specify the useJDBC4ColumnNameAndLabelSemantics=true (default is false) property on the url (this is the recommended spec property). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-1674) Need documentation created for JON EDS/teiid plugin

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIID-1674?page=com.atlassian.jira.plugin... ] Ted Jones commented on TEIID-1674: ---------------------------------- We have documentation for 7.40... http://docs.jboss.org/teiid/7.4.0.Final/admin-guide/en-US/html/admin-cons... What more is needed? > Need documentation created for JON EDS/teiid plugin > --------------------------------------------------- > > Key: TEIID-1674 > URL: https://issues.jboss.org/browse/TEIID-1674 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 7.4.1 > Reporter: Marc Shirley > Assignee: Ted Jones > > Need documentation for JON EDS/Teiid plugin describing available connection properties, configuration properties, metrics, operations, etc. for all resource types that the plugin monitors. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Moved: (TEIID-1674) Need documentation created for JON EDS/teiid plugin

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-1674?page=com.atlassian.jira.plugin... ] Van Halbert moved SOA-3183 to TEIID-1674: ----------------------------------------- Project: Teiid (was: JBoss Enterprise SOA Platform) Key: TEIID-1674 (was: SOA-3183) Affects Version/s: 7.4.1 (was: 5.1.0 GA) Component/s: Documentation (was: Documentation) (was: EDS) Security: (was: Public) > Need documentation created for JON EDS/teiid plugin > --------------------------------------------------- > > Key: TEIID-1674 > URL: https://issues.jboss.org/browse/TEIID-1674 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 7.4.1 > Reporter: Marc Shirley > Assignee: Van Halbert > > Need documentation for JON EDS/Teiid plugin describing available connection properties, configuration properties, metrics, operations, etc. for all resource types that the plugin monitors. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Reopened: (TEIID-993) Enhance XML processing to execute relational queries in parallel when possible

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-993?page=com.atlassian.jira.plugin.... ] Van Halbert reopened TEIID-993: ------------------------------- > Enhance XML processing to execute relational queries in parallel when possible > ------------------------------------------------------------------------------ > > Key: TEIID-993 > URL: https://issues.jboss.org/browse/TEIID-993 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Steven Hawkins > > Per feedback from Barry, was reviewing XML processing and because we execute all queries serially in our XML processing. However, conceptually, we could often execute multiple mapping class and/or temp table queries in parallel. When time permits it might be benefitial to investigate this. > All mapping classes at depth "n" in the document model are independent of each other, so they can be executed in parallel. Each mapping class may have input sets to any ancestor mapping class up to depth "n-1", or may select from any temp table up to depth "n" (the same depth). -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1655?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1655. ----------------------------------- Resolution: Done Made the changes outlined in the last comment. > 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. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-1659) Support pagination of LDAP results when retrieving from Active Directory

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1659?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1659: --------------------------------------- Mike, is this something you can cover adding? > Support pagination of LDAP results when retrieving from Active Directory > ------------------------------------------------------------------------ > > Key: TEIID-1659 > URL: https://issues.jboss.org/browse/TEIID-1659 > Project: Teiid > Issue Type: Feature Request > Components: LDAP Connector > Affects Versions: 7.1.1 > Environment: EDS 5.1. LDAP connection factory/translator. Active Directory as LDAP provider. > Reporter: Ken Johnson > Assignee: Steven Hawkins > Fix For: 7.4.1 > > > Active Directory has a setting MaxPageSize that limits the number of records of query results returned in a batch. The EDS LDAP connector/translator should support this setting so it can page through the results and retrieve all results. Not just up to MaxPageSize. Ideally this would be a configurable parameter that the user must set to match the MaxPageSize value on the AD server. For more info: http://support.microsoft.com/kb/315071. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 5 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-1659) Support pagination of LDAP results when retrieving from Active Directory

by Michael Walker (JIRA)

[ https://issues.jboss.org/browse/TEIID-1659?page=com.atlassian.jira.plugin... ] Michael Walker commented on TEIID-1659: --------------------------------------- I did follow up on this question from Marc and again from Ken, but maybe it did not make it’s way back to Steve. Here was my response: > The custom connector written for <customer> does not support paging. > It's something <customer> chose not to implement back in 2007 because > the version of Sun's directory server used did not > support it, either. There were some placeholders made in the code > marking where it could be implemented for AD in the future. This is > something that could be implemented by <customer> or by RH professional services. > > As a workaround, they should increase the maxPageSize value in AD. > LDAP admins are usually opposed to doing this across the board; > perhaps this can be done just for a specific user, or only for the > particular subtree they're having issue with, to limit the impact of this change. > > I'm pretty sure this won't work, but one thing they might try out is > to set the "maxBatchSize" property of the LDAP connector to the value > of the maxPageSize property in AD (typically 1000). Since it's so easy > to test, it's worth a try but I don't think it will make a difference. > > Also, it's worth checking to see if the current 5.5.4 LDAP connector > (NOT the one <customer> uses, which is custom) has implemented this > already. I'm having trouble connecting to the old CVS tree to pull > down the code -- do we still store the 5.5.4 codebase there, or is it in SVN? > Do you have the details for connecting to it? I might be able to try > this out later today. Or maybe someone else could quickly peruse the > code for changes in this area. > I think the follow-up was that the 5.5.4 connector did not support it, either. So, it would have to be implemented. > Support pagination of LDAP results when retrieving from Active Directory > ------------------------------------------------------------------------ > > Key: TEIID-1659 > URL: https://issues.jboss.org/browse/TEIID-1659 > Project: Teiid > Issue Type: Feature Request > Components: LDAP Connector > Affects Versions: 7.1.1 > Environment: EDS 5.1. LDAP connection factory/translator. Active Directory as LDAP provider. > Reporter: Ken Johnson > Assignee: Steven Hawkins > Fix For: 7.4.1 > > > Active Directory has a setting MaxPageSize that limits the number of records of query results returned in a batch. The EDS LDAP connector/translator should support this setting so it can page through the results and retrieve all results. Not just up to MaxPageSize. Ideally this would be a configurable parameter that the user must set to match the MaxPageSize value on the AD server. For more info: http://support.microsoft.com/kb/315071. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 6 months

1
0
0 / 0

[JBoss JIRA] Commented: (TEIID-1664) Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1664?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-1664: --------------------------------------- My approach here will be to remove the stringification logic in the translator and update the engine to remove nested widening converts. Any remaining failures can then be re-examined. > Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected BQT results > ----------------------------------------------------------------------------------------------------------------------- > > Key: TEIID-1664 > URL: https://issues.jboss.org/browse/TEIID-1664 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 7.4.1 > Reporter: Warren Gibson > Assignee: Steven Hawkins > Attachments: QT_teradata12_Push.vdb > > > Teiid - Teradata queries containing LTRIM and RTRIM on the BQT booleanvalue column are returning unexpected results. The following query should be returning 22 rows but 0 rows are returned. > SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE LTRIM(BQT1.SmallA.BooleanValue) = 'true' ORDER BY intkey > However, if the LTRIM is removed like (SELECT intkey, booleanvalue FROM BQT1.SmallA WHERE BQT1.SmallA.BooleanValue = 'true' ORDER BY intkey) 22 rows are returned. > This should be logged against Teiid 7.4.1 > VDB attached. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 6 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIID-1670) Query Planner not correctly resolving alias within a group by clause

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-1670?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-1670. ----------------------------------- Resolution: Duplicate Issue dup of TEIID-1571 > Query Planner not correctly resolving alias within a group by clause > -------------------------------------------------------------------- > > Key: TEIID-1670 > URL: https://issues.jboss.org/browse/TEIID-1670 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 7.1.1 > Reporter: Debbie Steigner > Assignee: Van Halbert > > EDS Query Planner not correctly resolving alias within a group by clause. Within the plan a self-join is needed, we assign one alias for the column that is used in a Group by clause, but is never resolved to the correct alias in the Source Query. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

13 years, 6 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues July 2011