[JBoss JIRA] (TEIID-3116) Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-3116?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-3116:
------------------------------------------------
David Le Sage <dlesage(a)redhat.com> changed the Status of [bug 1138679|https://bugzilla.redhat.com/show_bug.cgi?id=1138679] from ASSIGNED to ON_QA
> Teiid Partial Results Mode: unavailability of datasource causes error (which is not masked)
> -------------------------------------------------------------------------------------------
>
> Key: TEIID-3116
> URL: https://issues.jboss.org/browse/TEIID-3116
> Project: Teiid
> Issue Type: Bug
> Components: Server
> Affects Versions: 8.7.1
> Reporter: Van Halbert
> Assignee: Steven Hawkins
> Priority: Minor
>
> Description of problem:
> Querying a vdb-table which is formed as union of two tables from different datasources. Even though "set partialresultsmode true" is run as initial query, instead of retreiving 0 rows from a datasources that is down, exception is promoted.
> Version-Release number of selected component (if applicable):
> DV 6.1 ER1
> How reproducible:
> Every time
> Steps to Reproduce:
> 1. Define one valid and one invalid datasource(invalid connection-url).
> 2. Create vdb which maps tables from both datasources.
> 3. Set partialresultsmode to true
> 4. Execute query on the given vdb-table
> Actual results:
> TeiidSQLException
> TEIID30498 Remote org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for ORBQT were not avaialable. The command could not be planned properly.
> Expected results:
> 0 rows from invalid datasource.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months
[JBoss JIRA] (TEIID-2730) Cannot query Sybase database with jconn3.jar
by RH Bugzilla Integration (JIRA)
[ https://issues.jboss.org/browse/TEIID-2730?page=com.atlassian.jira.plugin... ]
RH Bugzilla Integration commented on TEIID-2730:
------------------------------------------------
David Le Sage <dlesage(a)redhat.com> changed the Status of [bug 1028380|https://bugzilla.redhat.com/show_bug.cgi?id=1028380] from ASSIGNED to ON_QA
> Cannot query Sybase database with jconn3.jar
> --------------------------------------------
>
> Key: TEIID-2730
> URL: https://issues.jboss.org/browse/TEIID-2730
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.4
> Environment: java oracle 1.7, Teiid 8.4.1-redhat4 in DV 6.0.0.ER3, Teiid Designer 8.3.beta3
> Reporter: Lucie Fabrikova
> Assignee: Steven Hawkins
> Fix For: 8.6
>
> Attachments: bqtHNB.vdb, bqt_HNB.xmi, jconn3.jar
>
>
> In teiid designer, I created a connection profile to Sybase database with URL jdbc:sybase:Tds:vmg07.mw.lab.eng.bos.redhat.com:5000/bqt2 and driver jconn3.jar.
> I created a relational source model from the jdbc connection and VDB with the source model. Then I deployed the VDB and executed query select * from "bqt_HNB"."g1" which resulted in this error message:
> TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 bqt_HNB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0]
> Console:
> OPTIMIZATION COMPLETE:
> PROCESSOR PLAN:
> AccessNode(0) output=[bqt_HNB.g1.e1, bqt_HNB.g1.e2] SELECT g_0.e1, g_0.e2 FROM bqt_HNB.g1 AS g_0
> ============================================================================
> 10:55:07,362 INFO [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) SybaseExecutionFactory Commit=true;DatabaseProductName=Adaptive Server Enterprise;DatabaseProductVersion=Adaptive Server Enterprise/15.0.3/EBF 16549 ESD#1/P/x86_64/Enterprise Linux/ase1503/2681/64-bit/FBO/Mon Mar 9 04:10:47 2009;DriverMajorVersion=6;DriverMajorVersion=0;DriverName=jConnect (TM) for JDBC (TM);DriverVersion=jConnect (TM) for JDBC(TM)/6.05(Build 26564)/P/EBF16903/JDK14/Sun May 31 1:05:35 2009;IsolationLevel=2
> 10:55:07,555 WARN [org.teiid.CONNECTOR] (Worker1_QueryProcessorQueue1) Connector worker process failed for atomic-request=dg2FpIhALlUI.0.0.0: org.teiid.translator.jdbc.JDBCExecutionException: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0]
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
> at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:254) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:444) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:157) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:154) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_45]
> at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_45]
> at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:269) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.4.1-redhat-2.jar:8.4.1-redhat-2]
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:895) [rt.jar:1.6.0_45]
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:918) [rt.jar:1.6.0_45]
> at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_45]
> Caused by: com.sybase.jdbc3.jdbc.SybSQLException: Incorrect syntax near 'e1'.
> at com.sybase.jdbc3.tds.Tds.a(Unknown Source)
> at com.sybase.jdbc3.tds.Tds.nextResult(Unknown Source)
> at com.sybase.jdbc3.jdbc.ResultGetter.nextResult(Unknown Source)
> at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
> at com.sybase.jdbc3.jdbc.SybStatement.nextResult(Unknown Source)
> at com.sybase.jdbc3.jdbc.SybStatement.queryLoop(Unknown Source)
> at com.sybase.jdbc3.jdbc.SybStatement.executeQuery(Unknown Source)
> at com.sybase.jdbc3.jdbc.SybPreparedStatement.executeQuery(Unknown Source)
> at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
> at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
> ... 13 more
> 10:55:07,568 WARN [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue2) TEIID30020 Processing exception for request dg2FpIhALlUI.0 'TEIID30504 bqt_HNB: 102 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."e1", g_0."e2" FROM "bqt2"."dbo"."g1" g_0]'. Originally TeiidProcessingException 'Incorrect syntax near 'e1'.
> ' com.sybase.jdbc3.tds.Tds.a(Unknown Source). Enable more detailed logging to see the entire stacktrace.
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months
[JBoss JIRA] (TEIID-3265) Incorrect result if multiple aggregate functions used
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3265?page=com.atlassian.jira.plugin... ]
Steven Hawkins resolved TEIID-3265.
-----------------------------------
Resolution: Duplicate Issue
Duplicate of TEIID-3263
> Incorrect result if multiple aggregate functions used
> -----------------------------------------------------
>
> Key: TEIID-3265
> URL: https://issues.jboss.org/browse/TEIID-3265
> Project: Teiid
> Issue Type: Bug
> Components: Embedded
> Affects Versions: 8.9
> Reporter: Renat Zhilkibaev
> Assignee: Steven Hawkins
>
> When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
> With data looking like this:
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> and this query:
> select symbol, max(price), min(price) from mytable group by symbol
> result looks like this:
> GE, 20.45,20.45
> Note the last value is 20.45 which is not a correct value (10.45).
> To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
> replace content of examples/embedded-portfolio/data/marketdata-price.txt with
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> Then change the query at
> examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
> Then execute examples/embedded-portfolio/run.sh
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months
[JBoss JIRA] (TEIID-3265) Incorrect result if multiple aggregate functions used
by Renat Zhilkibaev (JIRA)
[ https://issues.jboss.org/browse/TEIID-3265?page=com.atlassian.jira.plugin... ]
Renat Zhilkibaev updated TEIID-3265:
------------------------------------
Description:
When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
replace content of examples/embedded-portfolio/data/marketdata-price.txt with
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
Then change the query at
examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
Then execute examples/embedded-portfolio/run.sh
was:
When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
replace content of examples/embedded-portfolio/data/marketdata-price.txt with
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
Then change the query at
examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
> Incorrect result if multiple aggregate functions used
> -----------------------------------------------------
>
> Key: TEIID-3265
> URL: https://issues.jboss.org/browse/TEIID-3265
> Project: Teiid
> Issue Type: Bug
> Components: Embedded
> Affects Versions: 8.9
> Reporter: Renat Zhilkibaev
> Assignee: Steven Hawkins
>
> When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
> With data looking like this:
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> and this query:
> select symbol, max(price), min(price) from mytable group by symbol
> result looks like this:
> GE, 20.45,20.45
> Note the last value is 20.45 which is not a correct value (10.45).
> To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
> replace content of examples/embedded-portfolio/data/marketdata-price.txt with
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> Then change the query at
> examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
> Then execute examples/embedded-portfolio/run.sh
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months
[JBoss JIRA] (TEIID-3265) Incorrect result if multiple aggregate functions used
by Renat Zhilkibaev (JIRA)
[ https://issues.jboss.org/browse/TEIID-3265?page=com.atlassian.jira.plugin... ]
Renat Zhilkibaev updated TEIID-3265:
------------------------------------
Description:
When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
replace content of examples/embedded-portfolio/data/marketdata-price.txt with
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
Then change the query at
examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
was:
When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
Attached is incorrect-result-if-multiple-aggregate-functions-used.tar.gz which is modified (changed query and text table data) embedded quick start example.
To reproduce execute examples/embedded-portfolio/run.sh
> Incorrect result if multiple aggregate functions used
> -----------------------------------------------------
>
> Key: TEIID-3265
> URL: https://issues.jboss.org/browse/TEIID-3265
> Project: Teiid
> Issue Type: Bug
> Components: Embedded
> Affects Versions: 8.9
> Reporter: Renat Zhilkibaev
> Assignee: Steven Hawkins
>
> When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
> With data looking like this:
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> and this query:
> select symbol, max(price), min(price) from mytable group by symbol
> result looks like this:
> GE, 20.45,20.45
> Note the last value is 20.45 which is not a correct value (10.45).
> To reproduce download teiid-8.9.0.Final-embedded-dist.zip from http://sourceforge.net/projects/teiid/files/teiid-8.9.0.Final-embedded-di...
> replace content of examples/embedded-portfolio/data/marketdata-price.txt with
> SYMBOL,PRICE
> GE,10.45
> GE,15.45
> GE,20.45
> Then change the query at
> examples/embedded-portfolio/src/org/teiid/example/TeiidEmbeddedPortfolio.java line 186 to be "select symbol, max(price), min(price) from MyView.portfolio group by symbol"
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months
[JBoss JIRA] (TEIID-3265) Incorrect result if multiple aggregate functions used
by Renat Zhilkibaev (JIRA)
Renat Zhilkibaev created TEIID-3265:
---------------------------------------
Summary: Incorrect result if multiple aggregate functions used
Key: TEIID-3265
URL: https://issues.jboss.org/browse/TEIID-3265
Project: Teiid
Issue Type: Bug
Components: Embedded
Affects Versions: 8.9
Reporter: Renat Zhilkibaev
Assignee: Steven Hawkins
When using multiple aggregate functions the value returned by the first one is used as a result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
Attached is incorrect-result-if-multiple-aggregate-functions-used.tar.gz which is modified (changed query and text table data) embedded quick start example.
To reproduce execute examples/embedded-portfolio/run.sh
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)
9 years, 5 months