March 2017 - teiid-issues - Jboss List Archives

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

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4802?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4802. ----------------------------------- Resolution: Rejected > Could the null value be causing this? Yes, that is exactly the issue. "x NOT IN (values)" is the same as "NOT (x IN (values))", which is the same as "NOT (x = v1 OR x = v2 OR ...)". "x = null" evaluates to UNKNOWN, then UNKNOWN OR false evaluates to UNKNOWN, which leave you eventually with NOT(UNKNOWN), which is again just UNKNOWN. So the tuple will not pass the predicate. > 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 28 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-4803) Mandatory property for external materialization is not listed properly

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4803?page=com.atlassian.jira.plugin... ] Ramesh Reddy commented on TEIID-4803: ------------------------------------- oh, we have backward compatible support, but it is deprecated to be removed. We do not want anyone using this anymore thus removed. Perhaps I need to reconsider. > 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-4803) Mandatory property for external materialization is not listed properly

by Juraj Duráni (JIRA)

[ https://issues.jboss.org/browse/TEIID-4803?page=com.atlassian.jira.plugin... ] Juraj Duráni commented on TEIID-4803: ------------------------------------- OK, it's not mandatory anymore. But, has it been removed/deprecated? I.e. it is not listed in the table of supported properties. Shouldn't it be there even it's not mandatory? > 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-4804) External materialization documentation - Maria DB example DDL contains OPTIONS

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4804?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4804. --------------------------------- Resolution: Done corrected the document > External materialization documentation - Maria DB example DDL contains OPTIONS > ------------------------------------------------------------------------------ > > Key: TEIID-4804 > URL: https://issues.jboss.org/browse/TEIID-4804 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > MariaDB sample DDL for status table contains OPTIONS. This is teiid-specific. I do not think it's recognized by MariaDB. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4805) External materialization documentation - status table needs to be UPDATABLE

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4805?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4805: -------------------------------- Affects Version/s: 9.2 > External materialization documentation - status table needs to be UPDATABLE > --------------------------------------------------------------------------- > > Key: TEIID-4805 > URL: https://issues.jboss.org/browse/TEIID-4805 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL: https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > Status table for external materialization needs to be have option *updatable* set to *true*. It makes sense. But there is no such information in the documentation. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4805) External materialization documentation - status table needs to be UPDATABLE

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4805?page=com.atlassian.jira.plugin... ] Ramesh Reddy resolved TEIID-4805. --------------------------------- Fix Version/s: 9.3 Resolution: Done corrected the document > External materialization documentation - status table needs to be UPDATABLE > --------------------------------------------------------------------------- > > Key: TEIID-4805 > URL: https://issues.jboss.org/browse/TEIID-4805 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL: https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > Status table for external materialization needs to be have option *updatable* set to *true*. It makes sense. But there is no such information in the documentation. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4805) External materialization documentation - status table needs to be UPDATABLE

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4805?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-4805: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > External materialization documentation - status table needs to be UPDATABLE > --------------------------------------------------------------------------- > > Key: TEIID-4805 > URL: https://issues.jboss.org/browse/TEIID-4805 > Project: Teiid > Issue Type: Bug > Components: Documentation > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > > URL: https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > Status table for external materialization needs to be have option *updatable* set to *true*. It makes sense. But there is no such information in the documentation. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4804) External materialization documentation - Maria DB example DDL contains OPTIONS

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4804?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4804: -------------------------------- Affects Version/s: 9.2 > External materialization documentation - Maria DB example DDL contains OPTIONS > ------------------------------------------------------------------------------ > > Key: TEIID-4804 > URL: https://issues.jboss.org/browse/TEIID-4804 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > MariaDB sample DDL for status table contains OPTIONS. This is teiid-specific. I do not think it's recognized by MariaDB. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4804) External materialization documentation - Maria DB example DDL contains OPTIONS

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4804?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-4804: -------------------------------- Fix Version/s: 9.3 > External materialization documentation - Maria DB example DDL contains OPTIONS > ------------------------------------------------------------------------------ > > Key: TEIID-4804 > URL: https://issues.jboss.org/browse/TEIID-4804 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > MariaDB sample DDL for status table contains OPTIONS. This is teiid-specific. I do not think it's recognized by MariaDB. -- This message was sent by Atlassian JIRA (v7.2.3#72005)

7 years, 10 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4804) External materialization documentation - Maria DB example DDL contains OPTIONS

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-4804?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-4804: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > External materialization documentation - Maria DB example DDL contains OPTIONS > ------------------------------------------------------------------------------ > > Key: TEIID-4804 > URL: https://issues.jboss.org/browse/TEIID-4804 > Project: Teiid > Issue Type: Bug > Components: Documentation > Affects Versions: 9.2 > Reporter: Juraj Duráni > Assignee: Ramesh Reddy > Fix For: 9.3 > > > URL https://teiid.gitbooks.io/documents/content/caching/External_Materializat... > MariaDB sample DDL for status table contains OPTIONS. This is teiid-specific. I do not think it's recognized by MariaDB. -- 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