August 2018 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5437. ----------------------------------- Fix Version/s: 11.1 10.3.4 11.0.2 Resolution: Done The logic was creating an intermediate sort node without the groups assigned so that further pushing was to an inappropriate location. > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: sameer P > Assignee: Steven Hawkins > Priority: Critical > Fix For: 11.1, 10.3.4, 11.0.2 > > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-5437: --------------------------------- Aah yeah that's right. Thanks! > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: sameer P > Assignee: Steven Hawkins > Priority: Critical > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5437: --------------------------------------- This still occurs on master. A missing detail is that it needs to be an ordered limit - x order by col1 limit 100 I should be able to address this shortly. > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: sameer P > Assignee: Steven Hawkins > Priority: Critical > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5438) Update docs to not use teiid.jboss.org and teiid.org

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5438?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-5438. ----------------------------------- Resolution: Done All of the teiid.org links refer to namespace uris, so we'll leave those for now. > Update docs to not use teiid.jboss.org and teiid.org > ---------------------------------------------------- > > Key: TEIID-5438 > URL: https://issues.jboss.org/browse/TEIID-5438 > Project: Teiid > Issue Type: Task > Components: Documentation > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1 > > > Now that we have moved the content the legacy links need to be replaced. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] sameer P commented on TEIID-5437: --------------------------------- [~shawkins] it was on 10.2.1 . As I had a same working copy of that . Should I try the same on latest version? > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: sameer P > Assignee: Steven Hawkins > Priority: Critical > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5438) Update docs to not use teiid.jboss.org and teiid.org

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-5438: ------------------------------------- Summary: Update docs to not use teiid.jboss.org and teiid.org Key: TEIID-5438 URL: https://issues.jboss.org/browse/TEIID-5438 Project: Teiid Issue Type: Task Components: Documentation Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 11.1 Now that we have moved the content the legacy links need to be replaced. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] Steven Hawkins reassigned TEIID-5437: ------------------------------------- Component/s: Query Engine Priority: Critical (was: Blocker) Assignee: Steven Hawkins (was: Barry LaFond) What version of teiid is this? > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: sameer P > Assignee: Steven Hawkins > Priority: Critical > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by sameer P (JIRA)

[ https://issues.jboss.org/browse/TEIID-5437?page=com.atlassian.jira.plugin... ] sameer P updated TEIID-5437: ---------------------------- Component/s: (was: Connector API) (was: Grammar) (was: Query Engine) > ORDER BY combined with UNION/UNION ALL fails on PostgreSQL > ---------------------------------------------------------- > > Key: TEIID-5437 > URL: https://issues.jboss.org/browse/TEIID-5437 > Project: Teiid > Issue Type: Bug > Reporter: sameer P > Assignee: Barry LaFond > Priority: Blocker > > Combining union all and order by does not work when the query is pushed down to PostgreSQL. > The following query with dsp and dwh as postgres datasources, > {code:sql} > select * from ( > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > )x order by col1 > {code} > Fails with the below errors: > {code:java} > Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] > SQLState: 50000 > ErrorCode: 30504 > {code} > Where as the following query works without any problem: > {code:sql} > select b.i as col1, 'def' as col2 from dsp.test_ep_ds a > left join dwh.test_ep_dwh b on b.str=a.str > union all > select 2 as col1, 'abc' as col2 > {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5437) ORDER BY combined with UNION/UNION ALL fails on PostgreSQL

by sameer P (JIRA)

sameer P created TEIID-5437: ------------------------------- Summary: ORDER BY combined with UNION/UNION ALL fails on PostgreSQL Key: TEIID-5437 URL: https://issues.jboss.org/browse/TEIID-5437 Project: Teiid Issue Type: Bug Components: Connector API, Grammar, Query Engine Reporter: sameer P Assignee: Barry LaFond Priority: Blocker Combining union all and order by does not work when the query is pushed down to PostgreSQL. The following query with dsp and dwh as postgres datasources, {code:sql} select * from ( select b.i as col1, 'def' as col2 from dsp.test_ep_ds a left join dwh.test_ep_dwh b on b.str=a.str union all select 2 as col1, 'abc' as col2 )x order by col1 {code} Fails with the below errors: {code:java} Error: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 dsp_VDB_ID_1: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."str" AS c_0 FROM "public"."test_ep_ds" AS g_0 ORDER BY b."i" LIMIT 100] SQLState: 50000 ErrorCode: 30504 {code} Where as the following query works without any problem: {code:sql} select b.i as col1, 'def' as col2 from dsp.test_ep_ds a left join dwh.test_ep_dwh b on b.str=a.str union all select 2 as col1, 'abc' as col2 {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-5394) Define how to utilize multiple vdbs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5394?page=com.atlassian.jira.plugin... ] Work on TEIID-5394 started by Steven Hawkins. --------------------------------------------- > Define how to utilize multiple vdbs > ----------------------------------- > > Key: TEIID-5394 > URL: https://issues.jboss.org/browse/TEIID-5394 > Project: Teiid > Issue Type: Sub-task > Components: Build/Kits > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 11.1 > > > Perhaps to support vdb imports, we should define how a build can incorporate multiple vdbs. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 8 months

1
0
0 / 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2018