November 2017 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-5160) Quickstarts undocumented projects and artifacts

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5160: ---------------------------------- Summary: Quickstarts undocumented projects and artifacts Key: TEIID-5160 URL: https://issues.jboss.org/browse/TEIID-5160 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Priority: Blocker There are two undocumented projects: JDG 6.x projects (still valid) * jdg-remote-cache * jdg-remote-cache-materialization And in dynamicvdb-materialization there is undocumented vdb for internal materialization: * portfolio-intermat-vdb.xml -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5159) Quickstart hibernate-on-top-of-teiid usability issues

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5159: ---------------------------------- Summary: Quickstart hibernate-on-top-of-teiid usability issues Key: TEIID-5159 URL: https://issues.jboss.org/browse/TEIID-5159 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert There are two usability issues: 1. we're reusing Portfolio vdb. The thing is, that if user performed also dynamicvdb-dataroles quickstart, the Portfolio vdb will have limitations on data access. So it is crucial, for the functionality of hibernate qs for user to provide correct credentials. It has to be credentials allowing read access for the example query in the end. 2. mvn package is enough, no need for mvn install when building WAR file -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5158) Quickstart dynamicvdb-dataroles assuming invalid user password

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5158: ---------------------------------- Summary: Quickstart dynamicvdb-dataroles assuming invalid user password Key: TEIID-5158 URL: https://issues.jboss.org/browse/TEIID-5158 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Priority: Critical dynamicvdb-dataroles * provide a user with which we should perform the query * we can't count on a user/user credentials present on server, as add-user.sh limits passwords used * neither portfolio/portfolio is a valid combination -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5157) Quickstart dynamicvdb-dataroles need to force deploy vdb

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5157: ---------------------------------- Summary: Quickstart dynamicvdb-dataroles need to force deploy vdb Key: TEIID-5157 URL: https://issues.jboss.org/browse/TEIID-5157 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Priority: Blocker if dynamicvdb-datafederation run first, need to add force redeploy during vdb deploy: {code} deploy ../quickstarts/dynamicvdb-dataroles/src/vdb/portfolio-vdb.xml {code} vs. {code} deploy --force ../quickstarts/dynamicvdb-dataroles/src/vdb/portfolio-vdb.xml {code} Otherwise the vdb is not redeployed and user works with the old one. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5156) Quickstarts unify simpleclient instructions

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5156: ---------------------------------- Summary: Quickstarts unify simpleclient instructions Key: TEIID-5156 URL: https://issues.jboss.org/browse/TEIID-5156 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Unify simpleclient instructions {code} ==== Using the simpleclient example ==== 1) Change your working directory to ${JBOSS_HOME}/quickstarts/simpleclient" 2) Use the simpleclient example to run the following queries: Example: mvn exec:java -Dvdb="portfolio" -Dsql="example query" -Dusername="xx" -Dpassword="xx" {code} vs. {code} ==== Using the simpleclient example ==== 1. Change your working directory to "<quickstart.install.dir>/simpleclient" 2. Use the simpleclient example to run the following queries: Example: mvn exec:java -Dvdb="portfolio" -Dsql="example query" {code} * the location of simpleclient project is different each time -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5155) Quickstart dynamicvdb-materialization error in cli

by Jan Stastny (JIRA)

Jan Stastny created TEIID-5155: ---------------------------------- Summary: Quickstart dynamicvdb-materialization error in cli Key: TEIID-5155 URL: https://issues.jboss.org/browse/TEIID-5155 Project: Teiid Issue Type: Bug Components: Quick Starts Affects Versions: 8.12.x-6.4 Reporter: Jan Stastny Assignee: Van Halbert Priority: Blocker typo in dynamicvdb-materialization/src/scripts/deploy_vdb.cli: {code} deploy ../quickstarts/dynamicvdb-materializaton/src/vdb/portfolio-mat-vdb.xml {code} vs. {code} deploy ../quickstarts/dynamicvdb-materialization/src/vdb/portfolio-mat-vdb.xml {code} -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5153) RAND function gives same results in view

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5153?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5153: --------------------------------------- Yes it can be added where ever it seems to be missing. > RAND function gives same results in view > ---------------------------------------- > > Key: TEIID-5153 > URL: https://issues.jboss.org/browse/TEIID-5153 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3.4 > Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.3.5, 10.1, 10.0.1 > > > When using patched PostgreSQLExecutionFactory class to push down RAND function it starts to give the same values in a view. I wanted to push down RAND function in PostgreSQL for a while and noticed the bug related to identical values when using RAND function through a select in a view. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5153) RAND function gives same results in view

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5153?page=com.atlassian.jira.plugin... ] dalex dalex edited comment on TEIID-5153 at 11/17/17 1:01 PM: -------------------------------------------------------------- [~shawkins] yes, I want, but I would offer to add also the support for MySQL, MSSQL and Oracle. What do you think? For MySQL and MSSQL it would be rand() function, for Oracle accordingly DBMS_RANDOM.VALUE. was (Author: dalex005): yes, I want, but I would offer to add also the support for MySQL, MSSQL and Oracle. What do you think? For MySQL and MSSQL it would be rand() function, for Oracle accordingly DBMS_RANDOM.VALUE. > RAND function gives same results in view > ---------------------------------------- > > Key: TEIID-5153 > URL: https://issues.jboss.org/browse/TEIID-5153 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3.4 > Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.3.5, 10.1, 10.0.1 > > > When using patched PostgreSQLExecutionFactory class to push down RAND function it starts to give the same values in a view. I wanted to push down RAND function in PostgreSQL for a while and noticed the bug related to identical values when using RAND function through a select in a view. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5153) RAND function gives same results in view

by dalex dalex (JIRA)

[ https://issues.jboss.org/browse/TEIID-5153?page=com.atlassian.jira.plugin... ] dalex dalex commented on TEIID-5153: ------------------------------------ yes, I want, but I would offer to add also the support for MySQL, MSSQL and Oracle. What do you think? For MySQL and MSSQL it would be rand() function, for Oracle accordingly DBMS_RANDOM.VALUE. > RAND function gives same results in view > ---------------------------------------- > > Key: TEIID-5153 > URL: https://issues.jboss.org/browse/TEIID-5153 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3.4 > Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.3.5, 10.1, 10.0.1 > > > When using patched PostgreSQLExecutionFactory class to push down RAND function it starts to give the same values in a view. I wanted to push down RAND function in PostgreSQL for a while and noticed the bug related to identical values when using RAND function through a select in a view. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-5153) RAND function gives same results in view

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-5153?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5153: --------------------------------------- Yes, if you want to have the random pushdown support built-in. > RAND function gives same results in view > ---------------------------------------- > > Key: TEIID-5153 > URL: https://issues.jboss.org/browse/TEIID-5153 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 9.3.4 > Environment: teiid-9.3.4 on WildFly Full 10.0.0.Final (WildFly Core 2.0.10.Final) > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.3.5, 10.1, 10.0.1 > > > When using patched PostgreSQLExecutionFactory class to push down RAND function it starts to give the same values in a view. I wanted to push down RAND function in PostgreSQL for a while and noticed the bug related to identical values when using RAND function through a select in a view. -- This message was sent by Atlassian JIRA (v7.5.0#75005)

7 years, 1 month

1
0
0 / 0

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2017