July 2011 - teiid-designer-issues

[JBoss JIRA] Updated: (TEIIDDES-998) Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system"

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-998?page=com.atlassian.jira.plug... ] Barry LaFond updated TEIIDDES-998: ---------------------------------- Fix Version/s: 7.5 > Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system" > --------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-998 > URL: https://issues.jboss.org/browse/TEIIDDES-998 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 7.1.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Fix For: 7.5 > > Attachments: TEIIDDES-998-MPS.zip > > > Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system" > When importing virtual procedure definitions it appears that its dependencies are not resolved. Given a file that contains: VProc1, "CREATE VIRTUAL PROCEDURE BEGIN SELECT * FROM ABC.DEF.MJA; END", "Some other description" They're treated as if the dependency doesn't exist, so one gets errors such as: Group does not exist: ABD.DEF.MJA The Base Table must reference 1 or more columns; there are none Cleaning the project doesn't appear to fix the problem. > Currently to resolve the above problem, you must "Validate Transformations", then "Build Imports", Save and Build All to have the errors resolved. The importer should do all of this, the customer should not have to perform these other manual steps -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-229) Textual Metadata Importer fails to create simple virtual table transformations

by Paul Nittel (JIRA)

Textual Metadata Importer fails to create simple virtual table transformations ------------------------------------------------------------------------------ Key: TEIIDDES-229 URL: https://jira.jboss.org/jira/browse/TEIIDDES-229 Project: Teiid Designer Issue Type: Bug Components: Import/Export Affects Versions: 6.2.0 Environment: Fedora 10, Designer build 20090922 Reporter: Paul Nittel Importing the attached file into the VQT model of the attached model project set concludes wit mixed results. Some of the transformations are success while others fail. Even the simplest fail. The results appear to be very consistent as I've tried this a few time with the same outcome. 1 - Start Designer 2 - Import model project set 3 - Select VQT model 4 - Right-click VQT > Import > Metadata from Text 5 - Follow the Wizard 6 - Navigate to, and choose, the VqtTransformationSqlForTextImport.txt file 7 - Select the VQT model 8 - Finish In my case, the MAPPING tables (1 - 4) each have null transformations. Copying and pasting in the transformations specified in the file all work. -- 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

12 years, 11 months

2
5
0 / 0

[JBoss JIRA] Resolved: (TEIIDDES-998) Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system"

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-998?page=com.atlassian.jira.plug... ] Barry LaFond resolved TEIIDDES-998. ----------------------------------- Resolution: Cannot Reproduce Bug Can't reproduce given the attached project. > Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system" > --------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-998 > URL: https://issues.jboss.org/browse/TEIIDDES-998 > Project: Teiid Designer > Issue Type: Feature Request > Components: Import/Export > Affects Versions: 7.1.1 > Reporter: Debbie Steigner > Assignee: Barry LaFond > Attachments: TEIIDDES-998-MPS.zip > > > Requesting more seamlessness in the Teiid Designer "Import Metadata from Text files on file system" > When importing virtual procedure definitions it appears that its dependencies are not resolved. Given a file that contains: VProc1, "CREATE VIRTUAL PROCEDURE BEGIN SELECT * FROM ABC.DEF.MJA; END", "Some other description" They're treated as if the dependency doesn't exist, so one gets errors such as: Group does not exist: ABD.DEF.MJA The Base Table must reference 1 or more columns; there are none Cleaning the project doesn't appear to fix the problem. > Currently to resolve the above problem, you must "Validate Transformations", then "Build Imports", Save and Build All to have the errors resolved. The importer should do all of this, the customer should not have to perform these other manual steps -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Created: (TEIIDDES-1001) Merge the "Transformations - Import/Export SQL " actions with the Import Text Files > Relational Virtual Tables feature

by Barry LaFond (JIRA)

Merge the "Transformations - Import/Export SQL " actions with the Import Text Files > Relational Virtual Tables feature ----------------------------------------------------------------------------------------------------------------------- Key: TEIIDDES-1001 URL: https://issues.jboss.org/browse/TEIIDDES-1001 Project: Teiid Designer Issue Type: Enhancement Components: Import/Export, Transformations Affects Versions: 7.5 Reporter: Barry LaFond Fix For: 8.0 The Text file importer contains a "Relational Virtual Tables" option. There is also a "Transformations - Import SQL" action which performs basically the same function but has a different format. We'd like to merge these concepts into one and make it clearer to the user what's going on and be more flexible about format -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIIDDES-996) Create Web Service fails if the model contains 2 schemas with the same tablenames underneath

by Ted Jones (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-996?page=com.atlassian.jira.plug... ] Ted Jones resolved TEIIDDES-996. -------------------------------- Resolution: Done Confirmed this is resolved by TEIIDDES-968 which will add schema (and catalog, if applicable) to model object names. This causes duplicate table names in multiple schemas to be unique allowing for a separate interface to be generated for each table and avoiding clashes. > Create Web Service fails if the model contains 2 schemas with the same tablenames underneath > -------------------------------------------------------------------------------------------- > > Key: TEIIDDES-996 > URL: https://issues.jboss.org/browse/TEIIDDES-996 > Project: Teiid Designer > Issue Type: Bug > Components: Import/Export > Affects Versions: 7.4 > Reporter: Debbie Steigner > Assignee: Ted Jones > Labels: eds > Fix For: 7.5 > > Attachments: MySQL_Books.xmi > > > In Teiid Designer, if you import a Source Model that contains 2 schemas, each schema contains tables with the same name. Right-click > Modeling > Create Web Service fails: > "The name table_a_OutputView is the same (ignoring case) as 1 other object(s) under the same parent." > The default names for the table Output Views should also contain the schema/folder names, i.e. schemaA_tableA_OutputView. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIIDDES-333) "Update cost statistics" action should indicate a change in the model that requires a save, but it does not do so

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-333?page=com.atlassian.jira.plug... ] Barry LaFond resolved TEIIDDES-333. ----------------------------------- Resolution: Done Added open editor dialog and wrapped in transaction to result in dirty open editor. > "Update cost statistics" action should indicate a change in the model that requires a save, but it does not do so > ----------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-333 > URL: https://issues.jboss.org/browse/TEIIDDES-333 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 7.4 > Reporter: Michael Walker > Assignee: Barry LaFond > Priority: Minor > Fix For: 7.5 > > > Create a source model and save it. Then run "update cost statistics". The cost stat properties will be updated in the model. However, the model will remain "unchanged" in that there's no indication that it needs to be saved. Users can then accidentally close Designer and lose the changes, execute it in a VDB and get unexpected results, etc. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

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

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-359?page=com.atlassian.jira.plug... ] Barry LaFond updated TEIIDDES-359: ---------------------------------- Fix Version/s: 7.5 Affects Version/s: 7.4 > Error messages displayed in the transformation editor are often too generic or too long to be useful > ---------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-359 > URL: https://issues.jboss.org/browse/TEIIDDES-359 > Project: Teiid Designer > Issue Type: Feature Request > Affects Versions: 7.4 > Reporter: Michael Walker > Assignee: Barry LaFond > 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

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Resolved: (TEIIDDES-351) Actions in Designer should be 'view sensitive' - needs review

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-351?page=com.atlassian.jira.plug... ] Barry LaFond resolved TEIIDDES-351. ----------------------------------- Resolution: Out of Date Teiid Designer has the notion of a "Modeling >" submenu which takes care of the view-dependent enablement and availability of actions. This cleans up the user experience considerably. Also the Preview Data action was removed from the diagram toolbar which was the primary culprit. > Actions in Designer should be 'view sensitive' - needs review > ------------------------------------------------------------- > > Key: TEIIDDES-351 > URL: https://issues.jboss.org/browse/TEIIDDES-351 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Mark Drilling > Assignee: Barry LaFond > > This was brought up following the Designer usability demo. The 'Preview' action is used in multiple views in Designer. However it's selection is driven by workspace selection, not just the selection of the view(s) in which it appears. This should be reviewed / discussed. There are other actions that act similarly. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Closed: (TEIIDDES-351) Actions in Designer should be 'view sensitive' - needs review

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-351?page=com.atlassian.jira.plug... ] Barry LaFond closed TEIIDDES-351. --------------------------------- > Actions in Designer should be 'view sensitive' - needs review > ------------------------------------------------------------- > > Key: TEIIDDES-351 > URL: https://issues.jboss.org/browse/TEIIDDES-351 > Project: Teiid Designer > Issue Type: Feature Request > Reporter: Mark Drilling > Assignee: Barry LaFond > > This was brought up following the Designer usability demo. The 'Preview' action is used in multiple views in Designer. However it's selection is driven by workspace selection, not just the selection of the view(s) in which it appears. This should be reviewed / discussed. There are other actions that act similarly. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

[JBoss JIRA] Updated: (TEIIDDES-333) "Update cost statistics" action should indicate a change in the model that requires a save, but it does not do so

by Barry LaFond (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-333?page=com.atlassian.jira.plug... ] Barry LaFond updated TEIIDDES-333: ---------------------------------- Fix Version/s: 7.5 Affects Version/s: 7.4 > "Update cost statistics" action should indicate a change in the model that requires a save, but it does not do so > ----------------------------------------------------------------------------------------------------------------- > > Key: TEIIDDES-333 > URL: https://issues.jboss.org/browse/TEIIDDES-333 > Project: Teiid Designer > Issue Type: Bug > Components: Modeling > Affects Versions: 7.4 > Reporter: Michael Walker > Assignee: Barry LaFond > Priority: Minor > Fix For: 7.5 > > > Create a source model and save it. Then run "update cost statistics". The cost stat properties will be updated in the model. However, the model will remain "unchanged" in that there's no indication that it needs to be saved. Users can then accidentally close Designer and lose the changes, execute it in a VDB and get unexpected results, etc. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira

12 years, 11 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues July 2011