[
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)