[teiid-issues] [JBoss JIRA] (TEIID-2494) View definition column naming issue
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Mon May 6 16:13:54 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2494?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Steven Hawkins updated TEIID-2494:
----------------------------------
Summary: View definition column naming issue (was: Non-matching)
Description:
View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down.
for example:
SELECT MIN(x.count) FROM agg x
will fail with agg defined as
create foreign table smalla (intkey integer);
create view agg (count integer) as select count(\*) from smalla;
but will function correctly with count(\*) as count
was:View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down.
> View definition column naming issue
> -----------------------------------
>
> Key: TEIID-2494
> URL: https://issues.jboss.org/browse/TEIID-2494
> Project: Teiid
> Issue Type: Bug
> Components: Query Engine
> Affects Versions: 7.7
> Reporter: Steven Hawkins
> Assignee: Steven Hawkins
> Fix For: 8.4
>
>
> View definition columns that do not have names matching the view columns will not be named correctly if the view layer is preserved and pushed down.
> for example:
> SELECT MIN(x.count) FROM agg x
> will fail with agg defined as
> create foreign table smalla (intkey integer);
> create view agg (count integer) as select count(\*) from smalla;
> but will function correctly with count(\*) as count
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
More information about the teiid-issues
mailing list