March 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5298) Release a new version of arche types for Teiid 10.x

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5298?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5298. ----------------------------------- Resolution: Done Added the missing services file for the pre parser and released a 10.0.0 / 9.0.2 to maven central and jboss repositories. > Release a new version of arche types for Teiid 10.x > --------------------------------------------------- > > Key: TEIID-5298 > URL: https://issues.jboss.org/browse/TEIID-5298 > Project: Teiid > Issue Type: Task > Components: Tools > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3 > > > Changes were made for TEIID-4924, but no new release version of the arche types was promoted. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5223) Problem with union aliasing when bind variables used

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5223?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5223. ----------------------------------- Fix Version/s: (was: 10.x) Resolution: Out of Date Thanks for following up Mike. > Problem with union aliasing when bind variables used > ---------------------------------------------------- > > Key: TEIID-5223 > URL: https://issues.jboss.org/browse/TEIID-5223 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3.5 > Reporter: Mike Higgins > Assignee: Steven Hawkins > > When a query with a union, function call, and bind variables is issued in 9.3.5, an alias is not applied correctly. When the same query is run with an explicit constraint list, it works. It works in both cases in Teiid 9.3.4. > Query is: > SELECT Substances."SUB_ID", > NADALM_FUNCS.MOLFILE(Substances."XCTAB") "MOLFILE" > FROM ( > SELECT NADALM.SUBSTANCE."SUB_ID", > NADALM.SUBSTANCE."CTAB" "XCTAB", > NADALM_FUNCS.MOLFILE(NADALM.SUBSTANCE."CTAB") "MOLFILE" > FROM nadalm.substance > UNION ALL > SELECT D360_DC.DESIGN_COMPOUND."DC_ID" "SUB_ID", > D360_DC.DESIGN_COMPOUND."CTAB" "XCTAB", > NADALM_FUNCS.MOLFILE(D360_DC.DESIGN_COMPOUND."CTAB") "MOLFILE" > FROM d360_dc.design_compound) Substances > WHERE (Substances."SUB_ID" in (?, ?, ?, ?, ?, ?, ?,?, ?, ?)) > Generated SQL with error is: > SELECT v_0.SUB_ID, NADAL_CERTARA.MOLFILE(v_0.c_1) FROM > (SELECT g_1."SUB_ID" AS c_0, g_1."CTAB" AS c_1 FROM "NADAL_CERTARA"."SUBSTANCE" g_1 WHERE g_1."SUB_ID" IN (?, ?, ?, ?, ?, ?, ?,?, ?, ?) > UNION ALL > SELECT g_0."DC_ID" AS c_0, g_0."CTAB" AS c_1 FROM "NADAL_CERTARA"."DESIGN_COMPOUND" g_0 WHERE g_0."DC_ID" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) v_0 > Note that top branch references v_0.Sub_id, which is not legal (should be c_0). -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5299) Expose public.postgres_lib_version functions in public schema of vdb

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5299?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5299. ----------------------------------- Resolution: Duplicate Issue Duplicate of TEIID-5230 > Expose public.postgres_lib_version functions in public schema of vdb > -------------------------------------------------------------------- > > Key: TEIID-5299 > URL: https://issues.jboss.org/browse/TEIID-5299 > Project: Teiid > Issue Type: Enhancement > Affects Versions: 8.12.12.6_4 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > > expose public postgres functions in the public schema of the VDB as well out of the box > Steps to Reproduce > 1. Start ArcMap (http://desktop.arcgis.com/en/arcmap/) client from esri. > 2. Define connection to VDB > 3. Validate connection -> error > Actual results: > public.postgres_lib_version() not found -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5299) Expose public.postgres_lib_version functions in public schema of vdb

by Johnathon Lee (JIRA)

Johnathon Lee created TEIID-5299: ------------------------------------ Summary: Expose public.postgres_lib_version functions in public schema of vdb Key: TEIID-5299 URL: https://issues.jboss.org/browse/TEIID-5299 Project: Teiid Issue Type: Enhancement Affects Versions: 8.12.12.6_4 Reporter: Johnathon Lee Assignee: Steven Hawkins expose public postgres functions in the public schema of the VDB as well out of the box Steps to Reproduce 1. Start ArcMap (http://desktop.arcgis.com/en/arcmap/) client from esri. 2. Define connection to VDB 3. Validate connection -> error Actual results: public.postgres_lib_version() not found -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5223) Problem with union aliasing when bind variables used

by Mike Higgins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5223?page=com.atlassian.jira.plugin... ] Mike Higgins commented on TEIID-5223: ------------------------------------- Please close, I cannot reproduce this in version 10.1. > Problem with union aliasing when bind variables used > ---------------------------------------------------- > > Key: TEIID-5223 > URL: https://issues.jboss.org/browse/TEIID-5223 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.3.5 > Reporter: Mike Higgins > Assignee: Steven Hawkins > Fix For: 10.x > > > When a query with a union, function call, and bind variables is issued in 9.3.5, an alias is not applied correctly. When the same query is run with an explicit constraint list, it works. It works in both cases in Teiid 9.3.4. > Query is: > SELECT Substances."SUB_ID", > NADALM_FUNCS.MOLFILE(Substances."XCTAB") "MOLFILE" > FROM ( > SELECT NADALM.SUBSTANCE."SUB_ID", > NADALM.SUBSTANCE."CTAB" "XCTAB", > NADALM_FUNCS.MOLFILE(NADALM.SUBSTANCE."CTAB") "MOLFILE" > FROM nadalm.substance > UNION ALL > SELECT D360_DC.DESIGN_COMPOUND."DC_ID" "SUB_ID", > D360_DC.DESIGN_COMPOUND."CTAB" "XCTAB", > NADALM_FUNCS.MOLFILE(D360_DC.DESIGN_COMPOUND."CTAB") "MOLFILE" > FROM d360_dc.design_compound) Substances > WHERE (Substances."SUB_ID" in (?, ?, ?, ?, ?, ?, ?,?, ?, ?)) > Generated SQL with error is: > SELECT v_0.SUB_ID, NADAL_CERTARA.MOLFILE(v_0.c_1) FROM > (SELECT g_1."SUB_ID" AS c_0, g_1."CTAB" AS c_1 FROM "NADAL_CERTARA"."SUBSTANCE" g_1 WHERE g_1."SUB_ID" IN (?, ?, ?, ?, ?, ?, ?,?, ?, ?) > UNION ALL > SELECT g_0."DC_ID" AS c_0, g_0."CTAB" AS c_1 FROM "NADAL_CERTARA"."DESIGN_COMPOUND" g_0 WHERE g_0."DC_ID" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?))) v_0 > Note that top branch references v_0.Sub_id, which is not legal (should be c_0). -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5295) Comparisons of timestamps don't work correctly for MongoDB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5295?page=com.atlassian.jira.plugin... ] Work on TEIID-5295 started by Steven Hawkins. --------------------------------------------- > Comparisons of timestamps don't work correctly for MongoDB > ---------------------------------------------------------- > > Key: TEIID-5295 > URL: https://issues.jboss.org/browse/TEIID-5295 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.11.6_4 > Reporter: Jan Martiska > Assignee: Steven Hawkins > > Examples of queries which don't behave as expected when running against MongoDB: > {noformat} > SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue > '17:00:00' > {noformat} > returns ALL timevalues which are not null > {noformat} > SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue < '17:00:00' > {noformat} > returns NO timevalues even though there are some less than 17:00 > {noformat} > SELECT BQT1.SmallA.TimeValue FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue = '15:00:00' > {noformat} > returns nothing > {noformat} > SELECT BQT1.SmallA.IntKey FROM BQT1.SmallA WHERE BQT1.SmallA.TimeValue IN (convert('05:00:00', time), convert('15:00:00', time)) > {noformat} > returns nothing -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5298) Release a new version of arche types for Teiid 10.x

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5298: ------------------------------------- Summary: Release a new version of arche types for Teiid 10.x Key: TEIID-5298 URL: https://issues.jboss.org/browse/TEIID-5298 Project: Teiid Issue Type: Task Components: Tools Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 10.3 Changes were made for TEIID-4924, but no new release version of the arche types was promoted. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5293) Add implicit partitioning of joins to non-multisource partitioning as well

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5293?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5293. ----------------------------------- Fix Version/s: 10.3 10.1.3 10.0.5 10.2.1 Resolution: Done This enhancement enables implicit partition wise join when the virtual model has the property implicit_partition.columnName set to the partitioning column name. This also fixes issues with the partitioning info created after the decomposition, thus it's being checked into the support branches. > Add implicit partitioning of joins to non-multisource partitioning as well > -------------------------------------------------------------------------- > > Key: TEIID-5293 > URL: https://issues.jboss.org/browse/TEIID-5293 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 10.3, 10.1.3, 10.0.5, 10.2.1 > > > Similar to the existing flag controlling multi-source behavior, we should offer the option to make non-multisource partitioned view joins be performed partition-wise implicitly. This could be another flag or even a query hint. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5220) Add support for information_schema namespace

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5220?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5220. ----------------------------------- Fix Version/s: 10.2.1 10.3 (was: 10.2) Resolution: Done Made the correction to the column name. > Add support for information_schema namespace > -------------------------------------------- > > Key: TEIID-5220 > URL: https://issues.jboss.org/browse/TEIID-5220 > Project: Teiid > Issue Type: Bug > Components: ODBC, Query Engine > Reporter: Divyesh Vallabh > Assignee: Steven Hawkins > Fix For: 10.2.1, 10.3 > > > The npgsql provider uses the the infomation_schema namespace to query meta information for tables and views. > Add support for information_schema.tables ( > https://www.postgresql.org/docs/10/static/infoschema-tables.html) to teiid > Add support for information_schema.views ( > https://www.postgresql.org/docs/10/static/infoschema-views.html) to teiid > Add support for information_schema.columns ( > https://www.postgresql.org/docs/10/static/infoschema-columns.html) to teiid -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5297) With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause

by Jan Martiska (JIRA)

Jan Martiska created TEIID-5297: ----------------------------------- Summary: With MongoDB, null is returned from timestamp functions if the same function is part of WHERE clause Key: TEIID-5297 URL: https://issues.jboss.org/browse/TEIID-5297 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.12.11.6_4 Reporter: Jan Martiska Assignee: Steven Hawkins For example: {noformat} SELECT timestampvalue, second(timestampvalue) as sec FROM bqt1.hugeA WHERE second(timestampvalue) >= 0 {noformat} This will correctly select rows where {{second(timestampvalue) >= 0}}, but the {{sec}} column in the result will contain only nulls. If I remove the WHERE clause: {noformat} SELECT timestampvalue, second(timestampvalue) as sec FROM bqt1.hugeA; {noformat} Then the {{sec}} column will be computed correctly. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

6 years, 9 months

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues March 2018