teiid-designer-issues May 2015

teiid-designer-issues@lists.jboss.org

1 participants
424 discussions

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ] Tom Johnston edited comment on TEIIDDES-2502 at 5/1/15 1:08 PM: ---------------------------------------------------------------- copy/paste seems to loose the asterisk.. it should be proj.<asterisk> and act.<asterisk> was (Author: virtualdatabase): copy/paste seems to loose the asterisk.. this is the query to start: SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year > Incorrect transformation reconciliation > --------------------------------------- > > Key: TEIIDDES-2502 > URL: https://issues.jboss.org/browse/TEIIDDES-2502 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 9.0.1 > Environment: 9.0.1.Final-v20150211-1407-B643 > JBDS / Designer on Windows > Reporter: Tom Johnston > > SELECT > proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > "resolves" > to: > SELECT > FIDO.v_USCorn_Projected_PollDates AS proj.*, > FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, > f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN > FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) > LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN > FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > with error: > ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at > line 2, column 54. > Was expecting one of: > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > <ID> ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ] Tom Johnston commented on TEIIDDES-2502: ---------------------------------------- copy/paste seems to loose the asterisk.. this is the query to start: SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year > Incorrect transformation reconciliation > --------------------------------------- > > Key: TEIIDDES-2502 > URL: https://issues.jboss.org/browse/TEIIDDES-2502 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 9.0.1 > Environment: 9.0.1.Final-v20150211-1407-B643 > JBDS / Designer on Windows > Reporter: Tom Johnston > > SELECT > proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > "resolves" > to: > SELECT > FIDO.v_USCorn_Projected_PollDates AS proj.*, > FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, > f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN > FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) > LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN > FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > with error: > ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at > line 2, column 54. > Was expecting one of: > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > <ID> ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Tom Johnston (JIRA)

[ https://issues.jboss.org/browse/TEIIDDES-2502?page=com.atlassian.jira.plu... ] Tom Johnston updated TEIIDDES-2502: ----------------------------------- Description: SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year "resolves" to: SELECT FIDO.v_USCorn_Projected_PollDates AS proj.*, FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year with error: ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at line 2, column 54. Was expecting one of: "instead" ... "enabled" ... "disabled" ... "view" ... "key" ... "serial" ... "textagg" ... "count" ... "row_number" ... "rank" ... "dense_rank" ... "sum" ... "avg" ... "min" ... "max" ... "every" ... "stddev_pop" ... "stddev_samp" ... "var_samp" ... "var_pop" ... "document" ... "content" ... "trim" ... "empty" ... "ordinality" ... "path" ... "first" ... "last" ... "next" ... "substring" ... "extract" ... "to_chars" ... "to_bytes" ... "timestampadd" ... "timestampdiff" ... "querystring" ... "namespace" ... "result" ... "index" ... "accesspattern" ... "auto_increment" ... "wellformed" ... "sql_tsi_frac_second" ... "sql_tsi_second" ... "sql_tsi_minute" ... "sql_tsi_hour" ... "sql_tsi_day" ... "sql_tsi_week" ... "sql_tsi_month" ... "sql_tsi_quarter" ... "sql_tsi_year" ... "texttable" ... "arraytable" ... "selector" ... "skip" ... "width" ... "passing" ... "name" ... "encoding" ... "columns" ... "delimiter" ... "quote" ... "header" ... "nulls" ... "objecttable" ... "version" ... "including" ... "excluding" ... "xmldeclaration" ... "variadic" ... "exception" ... "raise" ... "chain" ... "jsonarray_agg" ... "jsonobject" ... <ID> ... was: SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year "resolves" to: SELECT FIDO.v_USCorn_Projected_PollDates AS proj.*, FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year with error: ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at line 2, column 54. Was expecting one of: "instead" ... "enabled" ... "disabled" ... "view" ... "key" ... "serial" ... "textagg" ... "count" ... "row_number" ... "rank" ... "dense_rank" ... "sum" ... "avg" ... "min" ... "max" ... "every" ... "stddev_pop" ... "stddev_samp" ... "var_samp" ... "var_pop" ... "document" ... "content" ... "trim" ... "empty" ... "ordinality" ... "path" ... "first" ... "last" ... "next" ... "substring" ... "extract" ... "to_chars" ... "to_bytes" ... "timestampadd" ... "timestampdiff" ... "querystring" ... "namespace" ... "result" ... "index" ... "accesspattern" ... "auto_increment" ... "wellformed" ... "sql_tsi_frac_second" ... "sql_tsi_second" ... "sql_tsi_minute" ... "sql_tsi_hour" ... "sql_tsi_day" ... "sql_tsi_week" ... "sql_tsi_month" ... "sql_tsi_quarter" ... "sql_tsi_year" ... "texttable" ... "arraytable" ... "selector" ... "skip" ... "width" ... "passing" ... "name" ... "encoding" ... "columns" ... "delimiter" ... "quote" ... "header" ... "nulls" ... "objecttable" ... "version" ... "including" ... "excluding" ... "xmldeclaration" ... "variadic" ... "exception" ... "raise" ... "chain" ... "jsonarray_agg" ... "jsonobject" ... <ID> ... > Incorrect transformation reconciliation > --------------------------------------- > > Key: TEIIDDES-2502 > URL: https://issues.jboss.org/browse/TEIIDDES-2502 > Project: Teiid Designer > Issue Type: Bug > Components: Transformations > Affects Versions: 9.0.1 > Environment: 9.0.1.Final-v20150211-1407-B643 > JBDS / Designer on Windows > Reporter: Tom Johnston > > SELECT > proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > "resolves" > to: > SELECT > FIDO.v_USCorn_Projected_PollDates AS proj.*, > FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, > f.Plant_Num > FROM > ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN > FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) > LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN > FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID > ORDER BY act.Crop_Year > with error: > ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at > line 2, column 54. > Was expecting one of: > "instead" ... > "enabled" ... > "disabled" ... > "view" ... > "key" ... > "serial" ... > "textagg" ... > "count" ... > "row_number" ... > "rank" ... > "dense_rank" ... > "sum" ... > "avg" ... > "min" ... > "max" ... > "every" ... > "stddev_pop" ... > "stddev_samp" ... > "var_samp" ... > "var_pop" ... > "document" ... > "content" ... > "trim" ... > "empty" ... > "ordinality" ... > "path" ... > "first" ... > "last" ... > "next" ... > "substring" ... > "extract" ... > "to_chars" ... > "to_bytes" ... > "timestampadd" ... > "timestampdiff" ... > "querystring" ... > "namespace" ... > "result" ... > "index" ... > "accesspattern" ... > "auto_increment" ... > "wellformed" ... > "sql_tsi_frac_second" ... > "sql_tsi_second" ... > "sql_tsi_minute" ... > "sql_tsi_hour" ... > "sql_tsi_day" ... > "sql_tsi_week" ... > "sql_tsi_month" ... > "sql_tsi_quarter" ... > "sql_tsi_year" ... > "texttable" ... > "arraytable" ... > "selector" ... > "skip" ... > "width" ... > "passing" ... > "name" ... > "encoding" ... > "columns" ... > "delimiter" ... > "quote" ... > "header" ... > "nulls" ... > "objecttable" ... > "version" ... > "including" ... > "excluding" ... > "xmldeclaration" ... > "variadic" ... > "exception" ... > "raise" ... > "chain" ... > "jsonarray_agg" ... > "jsonobject" ... > <ID> ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years

1
0
0 / 0

[JBoss JIRA] (TEIIDDES-2502) Incorrect transformation reconciliation

by Tom Johnston (JIRA)

Tom Johnston created TEIIDDES-2502: -------------------------------------- Summary: Incorrect transformation reconciliation Key: TEIIDDES-2502 URL: https://issues.jboss.org/browse/TEIIDDES-2502 Project: Teiid Designer Issue Type: Bug Components: Transformations Affects Versions: 9.0.1 Environment: 9.0.1.Final-v20150211-1407-B643 JBDS / Designer on Windows Reporter: Tom Johnston SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year "resolves" to: SELECT FIDO.v_USCorn_Projected_PollDates AS proj.*, FIDO.v_USCorn_Actual_PollDates AS act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num FROM ((FIDO.v_USCorn_Actual_PollDates AS act LEFT OUTER JOIN FIDO.v_USCorn_Projected_PollDates AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN FIDO.Field AS f ON f.Field_ID = act.Field_ID) INNER JOIN FIDO.ContractMaster AS cm ON cm.Contract_ID = f.Contract_ID ORDER BY act.Crop_Year with error: ERROR: Error in parsing of sql - Encountered " <ALL_IN_GROUP> "proj.* "" at line 2, column 54. Was expecting one of: "instead" ... "enabled" ... "disabled" ... "view" ... "key" ... "serial" ... "textagg" ... "count" ... "row_number" ... "rank" ... "dense_rank" ... "sum" ... "avg" ... "min" ... "max" ... "every" ... "stddev_pop" ... "stddev_samp" ... "var_samp" ... "var_pop" ... "document" ... "content" ... "trim" ... "empty" ... "ordinality" ... "path" ... "first" ... "last" ... "next" ... "substring" ... "extract" ... "to_chars" ... "to_bytes" ... "timestampadd" ... "timestampdiff" ... "querystring" ... "namespace" ... "result" ... "index" ... "accesspattern" ... "auto_increment" ... "wellformed" ... "sql_tsi_frac_second" ... "sql_tsi_second" ... "sql_tsi_minute" ... "sql_tsi_hour" ... "sql_tsi_day" ... "sql_tsi_week" ... "sql_tsi_month" ... "sql_tsi_quarter" ... "sql_tsi_year" ... "texttable" ... "arraytable" ... "selector" ... "skip" ... "width" ... "passing" ... "name" ... "encoding" ... "columns" ... "delimiter" ... "quote" ... "header" ... "nulls" ... "objecttable" ... "version" ... "including" ... "excluding" ... "xmldeclaration" ... "variadic" ... "exception" ... "raise" ... "chain" ... "jsonarray_agg" ... "jsonobject" ... <ID> ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

9 years

1
0
0 / 0

← Newer
1
...
40
41
42
43
Older →

Jump to page:

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-designer-issues May 2015