[JBoss JIRA] (TEIID-3311) Nesting aliases that match the engine recontext logic can lead to naming conflicts
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3311:
-------------------------------------
Summary: Nesting aliases that match the engine recontext logic can lead to naming conflicts
Key: TEIID-3311
URL: https://issues.jboss.org/browse/TEIID-3311
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
A query such as:
select (select e4 from pm1.g1 X__1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X__1, (select distinct e2, e3 from pm3.g1) X__2 where pm1.g1.e3 = X__1.e1 and pm1.g1.e2 = year(X__2.e3)
Will fail to process correctly as the X__1 and X__2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X__1.e1.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 1 month
[JBoss JIRA] (TEIID-3310) Nesting aliases that match the engine recontext logic can lead to naming conflicts
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3310:
-------------------------------------
Summary: Nesting aliases that match the engine recontext logic can lead to naming conflicts
Key: TEIID-3310
URL: https://issues.jboss.org/browse/TEIID-3310
Project: Teiid
Issue Type: Feature Request
Components: Query Engine
Affects Versions: 7.7
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.10
A query such as:
select (select e4 from pm1.g1 X__1), pm1.g1.e2 from pm1.g1, /*+ makeind */ (select e1 from pm2.g1) AS X__1, (select distinct e2, e3 from pm3.g1) X__2 where pm1.g1.e3 = X__1.e1 and pm1.g1.e2 = year(X__2.e3)
Will fail to process correctly as the X__1 and X__2 aliases are already in use, which will cause an AssertionError during processing attempting to reference X__1.e1.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 1 month
[JBoss JIRA] (TEIID-3300) Add SPATIAL_REF_SYS table
by Tom Arnold (JIRA)
[ https://issues.jboss.org/browse/TEIID-3300?page=com.atlassian.jira.plugin... ]
Tom Arnold edited comment on TEIID-3300 at 1/26/15 8:42 PM:
------------------------------------------------------------
I'd appreciate it if you could get it started; I won't be able to spend much time on this (aside from reading issues) until the weekend.
Couple misc notes:
* Need to add PROJ4TEXT (from PostGIS inserts) to the table def. Isn't part of the spec, but that column contains the parameters for the Proj4 library (which is my first choice for ST_Transform / TEIID-3302).
* Need to be able to get access to this table in several places (e.g., system function for ST_Transform).
was (Author: tom9729):
I'd appreciate it if you could get it started; I won't be able to spend much time on this (aside from reading issues) until the weekend.
> Add SPATIAL_REF_SYS table
> -------------------------
>
> Key: TEIID-3300
> URL: https://issues.jboss.org/browse/TEIID-3300
> Project: Teiid
> Issue Type: Feature Request
> Reporter: Tom Arnold
> Assignee: Steven Hawkins
> Labels: spatial
>
> Implement SPATIAL_REF_SYS table (from the OGC Simple Features spec). This table stores metadata about different coordinate systems and how to tranform between them. See [here|http://en.wikipedia.org/wiki/SRID] and [here|http://www.carocoops.org/resources/doc/postgis/x321.html] for details.
> {code}
> CREATE TABLE SPATIAL_REF_SYS
> (
> SRID INTEGER NOT NULL PRIMARY KEY,
> AUTH_NAME CHARACTER VARYING(256),
> AUTH_SRID INTEGER,
> SRTEXT CHARACTER VARYING(2048)
> )
> {code}
> https://raw.githubusercontent.com/postgis/postgis/svn-trunk/spatial_ref_s...
> This would be used in conjunction with the GeoTools referencing module or Proj4J to transform between coordinate systems in Teiid (ST_Transform function).
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
10 years, 1 month