[JBoss JIRA] (TEIIDDES-2505) Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2505?page=com.atlassian.jira.plu... ]
Marc Shirley updated TEIIDDES-2505:
-----------------------------------
Description: When creating/editing connection profile to add/delete a new parameter to a REST service with MacOS, the parameter list is not refreshed properly. Often requires to exit and then reenter the connection profile editor to see the updated parameter list. (was: When creating/editing connection profile to add a new parameter to a REST service, able to enter freeform text in the Type field of the "Add New Parameter" popup dialog. However, the freeform value returns to the previously selected value (Query or URI) when OK is clicked. Either the field should be unable to be modified, or the value entered should be preserved.)
> Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
> ---------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2505
> URL: https://issues.jboss.org/browse/TEIIDDES-2505
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0
> Environment: Mac, Linux
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
>
> When creating/editing connection profile to add/delete a new parameter to a REST service with MacOS, the parameter list is not refreshed properly. Often requires to exit and then reenter the connection profile editor to see the updated parameter list.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2505) Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2505?page=com.atlassian.jira.plu... ]
Marc Shirley updated TEIIDDES-2505:
-----------------------------------
Steps to Reproduce:
1) Import -> Web Service Source >> Source and View Model (REST)
2) New Connection profile using "Web Services Data Source (REST)" profile type
3) Name profile "Sample Posts REST"
4) Use Connection URL value "http://jsonplaceholder.typicode.com/users"
5) Response Type set to "JSON"
6) Add parameter
7) Delete Parameter (it should continue to exist in the parameter list)
8) Exit connection profile
9) Edit connection profile (the deleted parameter should now be gone)
was:
1) Import -> Web Service Source >> Source and View Model (REST)
2) New Connection profile using "Web Services Data Source (REST)" profile type
3) Name profile "Sample Posts REST"
4) Use Connection URL value "http://jsonplaceholder.typicode.com/users"
5) Response Type set to "JSON"
6) Add parameter
7) Click on or tab to Type field and edit value
> Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
> ---------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2505
> URL: https://issues.jboss.org/browse/TEIIDDES-2505
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0
> Environment: Mac, Linux
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
>
> When creating/editing connection profile to add a new parameter to a REST service, able to enter freeform text in the Type field of the "Add New Parameter" popup dialog. However, the freeform value returns to the previously selected value (Query or URI) when OK is clicked. Either the field should be unable to be modified, or the value entered should be preserved.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2505) Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
by Marc Shirley (JIRA)
Marc Shirley created TEIIDDES-2505:
--------------------------------------
Summary: Parameters are not refreshed properly in "Web Services Data Source (REST)" connection profile in MacOS installs
Key: TEIIDDES-2505
URL: https://issues.jboss.org/browse/TEIIDDES-2505
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 9.0
Environment: Mac, Linux
JBDS Version: 8.0.0.GA
Build id: GA-v20141020-1042-B317
Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
Reporter: Marc Shirley
When creating/editing connection profile to add a new parameter to a REST service, able to enter freeform text in the Type field of the "Add New Parameter" popup dialog. However, the freeform value returns to the previously selected value (Query or URI) when OK is clicked. Either the field should be unable to be modified, or the value entered should be preserved.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2504) Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2504?page=com.atlassian.jira.plu... ]
Marc Shirley updated TEIIDDES-2504:
-----------------------------------
Description: When creating/editing connection profile to add a new parameter to a REST service, able to enter freeform text in the Type field of the "Add New Parameter" popup dialog. However, the freeform value returns to the previously selected value (Query or URI) when OK is clicked. Either the field should be unable to be modified, or the value entered should be preserved. (was: When creating/editing connection profile to add a new parameter to a REST service, switching the Type field to URI results in a new "Add New Parameter" popup to appear with the default Type of Query selected again. closing the popup by cancelling or completing returns to the previously opened "Add New Parameter" dialog.)
> Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2504
> URL: https://issues.jboss.org/browse/TEIIDDES-2504
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0
> Environment: Mac, Linux
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
>
> When creating/editing connection profile to add a new parameter to a REST service, able to enter freeform text in the Type field of the "Add New Parameter" popup dialog. However, the freeform value returns to the previously selected value (Query or URI) when OK is clicked. Either the field should be unable to be modified, or the value entered should be preserved.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2504) Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
by Marc Shirley (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2504?page=com.atlassian.jira.plu... ]
Marc Shirley updated TEIIDDES-2504:
-----------------------------------
Steps to Reproduce:
1) Import -> Web Service Source >> Source and View Model (REST)
2) New Connection profile using "Web Services Data Source (REST)" profile type
3) Name profile "Sample Posts REST"
4) Use Connection URL value "http://jsonplaceholder.typicode.com/users"
5) Response Type set to "JSON"
6) Add parameter
7) Click on or tab to Type field and edit value
was:
1) Import -> Web Service Source >> Source and View Model (REST)
2) New Connection profile using "Web Services Data Source (REST)" profile type
3) Name profile "Sample Posts REST"
4) Use Connection URL value "http://jsonplaceholder.typicode.com/users"
5) Response Type set to "JSON"
6) Add parameter
7) Set Type to "URI"
> Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
> --------------------------------------------------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2504
> URL: https://issues.jboss.org/browse/TEIIDDES-2504
> Project: Teiid Designer
> Issue Type: Bug
> Components: Web Services Support
> Affects Versions: 9.0
> Environment: Mac, Linux
> JBDS Version: 8.0.0.GA
> Build id: GA-v20141020-1042-B317
> Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
> Reporter: Marc Shirley
>
> When creating/editing connection profile to add a new parameter to a REST service, switching the Type field to URI results in a new "Add New Parameter" popup to appear with the default Type of Query selected again. closing the popup by cancelling or completing returns to the previously opened "Add New Parameter" dialog.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2504) Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
by Marc Shirley (JIRA)
Marc Shirley created TEIIDDES-2504:
--------------------------------------
Summary: Able to enter freeform input in Type field of "Add new parameter" dialog in "Web Services Data Source (REST)" connection profile
Key: TEIIDDES-2504
URL: https://issues.jboss.org/browse/TEIIDDES-2504
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 9.0
Environment: Mac, Linux
JBDS Version: 8.0.0.GA
Build id: GA-v20141020-1042-B317
Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
Reporter: Marc Shirley
When creating/editing connection profile to add a new parameter to a REST service, switching the Type field to URI results in a new "Add New Parameter" popup to appear with the default Type of Query selected again. closing the popup by cancelling or completing returns to the previously opened "Add New Parameter" dialog.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[JBoss JIRA] (TEIIDDES-2503) Changing parameter type to URI in "Web Services Data Source (REST)" connection profile results in new "Add new parameter" dialog opening
by Marc Shirley (JIRA)
Marc Shirley created TEIIDDES-2503:
--------------------------------------
Summary: Changing parameter type to URI in "Web Services Data Source (REST)" connection profile results in new "Add new parameter" dialog opening
Key: TEIIDDES-2503
URL: https://issues.jboss.org/browse/TEIIDDES-2503
Project: Teiid Designer
Issue Type: Bug
Components: Web Services Support
Affects Versions: 9.0
Environment: Mac, Linux
JBDS Version: 8.0.0.GA
Build id: GA-v20141020-1042-B317
Teiid Designer version: 9.0.1.Final-v20150211-1407-B643
Reporter: Marc Shirley
When creating/editing connection profile to add a new parameter to a REST service, switching the Type field to URI results in a new "Add New Parameter" popup to appear with the default Type of Query selected again. closing the popup by cancelling or completing returns to the previously opened "Add New Parameter" dialog.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
10 years, 5 months
[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:
-----------------------------------
Steps to Reproduce:
create view
add transformation:
SELECT
proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
FROM
((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
ORDER BY act.Crop_Year
VALIDATE
query gets changed and error occurs.
was:
create view
add transformation:
SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
FROM
((Table1 AS act LEFT OUTER JOIN Table3 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table2 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
VALIDATE
query gets changed and error occurs.
> 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
> ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> "resolves"
> to:
> SELECT
> Table2 AS proj.*,
> Table1 AS act.*, cm.Field_Num, cm.Identity_Token,
> f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN
> Table2 AS proj ON proj.Field_ID = act.Field_ID)
> LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
> Table4 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)
10 years, 5 months
[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
((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
ORDER BY act.Crop_Year
"resolves"
to:
SELECT
Table2 AS proj.*,
Table1 AS act.*, cm.Field_Num, cm.Identity_Token,
f.Plant_Num
FROM
((Table1 AS act LEFT OUTER JOIN
Table2 AS proj ON proj.Field_ID = act.Field_ID)
LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
Table4 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
> ((Table1 AS act LEFT OUTER JOIN Table2 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN Table4 AS cm ON cm.Contract_ID = f.Contract_ID
> ORDER BY act.Crop_Year
> "resolves"
> to:
> SELECT
> Table2 AS proj.*,
> Table1 AS act.*, cm.Field_Num, cm.Identity_Token,
> f.Plant_Num
> FROM
> ((Table1 AS act LEFT OUTER JOIN
> Table2 AS proj ON proj.Field_ID = act.Field_ID)
> LEFT OUTER JOIN Table3 AS f ON f.Field_ID = act.Field_ID) INNER JOIN
> Table4 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)
10 years, 5 months
[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:
-----------------------------------
Steps to Reproduce:
create view
add transformation:
SELECT proj.*, act.*, cm.Field_Num, cm.Identity_Token, f.Plant_Num
FROM
((Table1 AS act LEFT OUTER JOIN Table3 AS proj ON proj.Field_ID = act.Field_ID) LEFT OUTER JOIN Table2 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
VALIDATE
query gets changed and error occurs.
was:
create view
add transformation:
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
VALIDATE
query gets changed and error occurs.
> 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)
10 years, 5 months