March 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4803) Mandatory property for external materialization is not listed properly

by Juraj Duráni (JIRA)

Juraj Duráni created TEIID-4803: ----------------------------------- Summary: Mandatory property for external materialization is not listed properly Key: TEIID-4803 URL: https://issues.jboss.org/browse/TEIID-4803 Project: Teiid Issue Type: Bug Components: Documentation Reporter: Juraj Duráni Assignee: Steven Hawkins URL: https://teiid.gitbooks.io/documents/content/caching/External_Materializat... For external materialization, there is (among the others) one mandatory property *teiid_rel:MATERIALIZED_STAGE_TABLE* which is not listed in the documentation. Actually, it's listed in second column (Description column) of property *teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT*. It look like formatting issue. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4802) Not in with subquery does not work correctly

by Bram Gadeyne (JIRA)

[ https://issues.jboss.org/browse/TEIID-4802?page=com.atlassian.jira.plugin... ] Bram Gadeyne updated TEIID-4802: -------------------------------- Affects Version/s: 9.0.5 > Not in with subquery does not work correctly > -------------------------------------------- > > Key: TEIID-4802 > URL: https://issues.jboss.org/browse/TEIID-4802 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.0.5, 9.1.4 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Priority: Critical > Attachments: query_plan_not_in.txt > > > Hi, > This query does not return any results where it should. > {code:sql} > select cl.* > from izalert_clientstatus cl > where cl.hostname not in ( > select WSidentifier from prod_U_PV_PClist > ) > {code} > This query is more or less equivalent to the one above but does return 23 results. > {code:sql} > select cl.hostname > from izalert_clientstatus cl > left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier > where pl.WSidentifier is null > {code} > hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4802) Not in with subquery does not work correctly

by Bram Gadeyne (JIRA)

[ https://issues.jboss.org/browse/TEIID-4802?page=com.atlassian.jira.plugin... ] Bram Gadeyne updated TEIID-4802: -------------------------------- Attachment: query_plan_not_in.txt > Not in with subquery does not work correctly > -------------------------------------------- > > Key: TEIID-4802 > URL: https://issues.jboss.org/browse/TEIID-4802 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.4 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Priority: Critical > Attachments: query_plan_not_in.txt > > > Hi, > This query does not return any results where it should. > {code:sql} > select cl.* > from izalert_clientstatus cl > where cl.hostname not in ( > select WSidentifier from prod_U_PV_PClist > ) > {code} > This query is more or less equivalent to the one above but does return 23 results. > {code:sql} > select cl.hostname > from izalert_clientstatus cl > left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier > where pl.WSidentifier is null > {code} > hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4802) Not in with subquery does not work correctly

by Bram Gadeyne (JIRA)

[ https://issues.jboss.org/browse/TEIID-4802?page=com.atlassian.jira.plugin... ] Bram Gadeyne updated TEIID-4802: -------------------------------- Description: Hi, This query does not return any results where it should. {code:sql} select cl.* from izalert_clientstatus cl where cl.hostname not in ( select WSidentifier from prod_U_PV_PClist ) {code} This query is more or less equivalent to the one above but does return 23 results. {code:sql} select cl.hostname from izalert_clientstatus cl left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier where pl.WSidentifier is null {code} hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' was: Hi, This query does not return any results where it should. select cl.* from izalert_clientstatus cl where cl.hostname not in ( select WSidentifier from prod_U_PV_PClist ) This query is more or less equivalent to the one above but does return 23 results. select cl.hostname from izalert_clientstatus cl left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier where pl.WSidentifier is null hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' > Not in with subquery does not work correctly > -------------------------------------------- > > Key: TEIID-4802 > URL: https://issues.jboss.org/browse/TEIID-4802 > Project: Teiid > Issue Type: Bug > Affects Versions: 9.1.4 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > Priority: Critical > > Hi, > This query does not return any results where it should. > {code:sql} > select cl.* > from izalert_clientstatus cl > where cl.hostname not in ( > select WSidentifier from prod_U_PV_PClist > ) > {code} > This query is more or less equivalent to the one above but does return 23 results. > {code:sql} > select cl.hostname > from izalert_clientstatus cl > left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier > where pl.WSidentifier is null > {code} > hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4802) Not in with subquery does not work correctly

by Bram Gadeyne (JIRA)

Bram Gadeyne created TEIID-4802: ----------------------------------- Summary: Not in with subquery does not work correctly Key: TEIID-4802 URL: https://issues.jboss.org/browse/TEIID-4802 Project: Teiid Issue Type: Bug Affects Versions: 9.1.4 Reporter: Bram Gadeyne Assignee: Steven Hawkins Priority: Critical Hi, This query does not return any results where it should. select cl.* from izalert_clientstatus cl where cl.hostname not in ( select WSidentifier from prod_U_PV_PClist ) This query is more or less equivalent to the one above but does return 23 results. select cl.hostname from izalert_clientstatus cl left join prod_U_PV_PClist pl on cl.hostname = pl.WSidentifier where pl.WSidentifier is null hostname and wsidentifier are both String fields. In the clientstatus table it has a length of 255, in the other table 63. The values for hostname and wsidentifier are e.g. 'COSARA4' and 'PC-10360' -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4724) Allow support for vdb.ddl in the .vdb files

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4724?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4724: ------------------------------------- Added a note here [1], let me know if think of any other places we need to expand more. There already note about IMPORT section about DDL-FILE. [1] https://github.com/teiid/teiid-documents/pull/108/files > Allow support for vdb.ddl in the .vdb files > ------------------------------------------- > > Key: TEIID-4724 > URL: https://issues.jboss.org/browse/TEIID-4724 > Project: Teiid > Issue Type: Enhancement > Components: VDB > Reporter: Ramesh Reddy > Assignee: Ramesh Reddy > Labels: Alpaha1 > Fix For: 9.3 > > > With the DDL based metadata, ".vdb" file archive should allow to contain a "vdb.ddl" file that can be deployed. Based on TEIID-4719 this needs to allow to load metadata from INDEX and DDL-FILE metadata repositories. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4523) CXF is not used by Salesforce BulkConnection

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4523?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4523: -------------------------------- Fix Version/s: 10.0 (was: 9.3) > CXF is not used by Salesforce BulkConnection > -------------------------------------------- > > Key: TEIID-4523 > URL: https://issues.jboss.org/browse/TEIID-4523 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 10.0 > > > TEIID-3493 added the CXF transport, but it's not used by the salesforce BulkConnection. In v22 they make use of a static call, so we won't make a change there. With 34 we can extend the SalesforceConnectorConfig createConnection - but a HttpURLConnection is expected so this may not be straight-forward. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4523) CXF is not used by Salesforce BulkConnection

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4523?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-4523: --------------------------------------- Yes, it didn't seem worth it to tackle at this time. > CXF is not used by Salesforce BulkConnection > -------------------------------------------- > > Key: TEIID-4523 > URL: https://issues.jboss.org/browse/TEIID-4523 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 9.3 > > > TEIID-3493 added the CXF transport, but it's not used by the salesforce BulkConnection. In v22 they make use of a static call, so we won't make a change there. With 34 we can extend the SalesforceConnectorConfig createConnection - but a HttpURLConnection is expected so this may not be straight-forward. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4523) CXF is not used by Salesforce BulkConnection

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4523?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4523: ------------------------------------- I am beginning to question whether this is worth the effort. For most of the operations that are batch in Teiid are insert/update/delete. The submission of the operations seemed to be over the configured transport, where are job checking and result fetching done over the HTTPURLConnection. Typically results are small, as these are update counts. In order to use CXF transport, we would need to override and implement HTTPURLConnection, with CXF libraries for connection and communication. On top of it, the abstraction at SF library level seems to go beyond just connection, so we would need to copy some of their code into Teiid (heades, gzip etc). > CXF is not used by Salesforce BulkConnection > -------------------------------------------- > > Key: TEIID-4523 > URL: https://issues.jboss.org/browse/TEIID-4523 > Project: Teiid > Issue Type: Bug > Components: Salesforce Connector > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Ramesh Reddy > Fix For: 9.3 > > > TEIID-3493 added the CXF transport, but it's not used by the salesforce BulkConnection. In v22 they make use of a static call, so we won't make a change there. With 34 we can extend the SalesforceConnectorConfig createConnection - but a HttpURLConnection is expected so this may not be straight-forward. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2167) Permissions should also specify object type

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-2167?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-2167: ------------------------------------- The meta model in Designer already tells you what type of object it is, Teiid is being more explicit in its definition, such that if you have foo table and procedure which one this role applies to. > Permissions should also specify object type > ------------------------------------------- > > Key: TEIID-2167 > URL: https://issues.jboss.org/browse/TEIID-2167 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.3 > > > Teiid permissions only specify a resource name. However it is possible to have to have conflicting schema/table (since we are using non-sql safe unquoted names) or table/procedure names. > Ideally we would use proper sql names (this is true everywhere, not just in permissions) and specify the object type (TABLE, PROCEDURE, SCHEMA, LANGUAGE, FUNCTION, etc.). This would also allow us to have a more standard USAGE permission, rather than something like LANGUAGE, which is used to convey the permission and object type. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 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 2017