August 2014 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3101) Assertion failed with UNION then EXCEPT

by Tom Arnold (JIRA)

Tom Arnold created TEIID-3101: --------------------------------- Summary: Assertion failed with UNION then EXCEPT Key: TEIID-3101 URL: https://issues.jboss.org/browse/TEIID-3101 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Query Engine Affects Versions: 8.9 Reporter: Tom Arnold Assignee: Steven Hawkins Ran into this when playing with set operations. Teiid 8.9.0.Alpha2 from Git. Query: {code:sql} (select 'a' union select 'b') except select 'c'; {code} Trace: {code} 03:18:45,467 DEBUG [org.teiid.COMMAND_LOG] (New I/O worker #12) WEI32e8Ynv+s START USER COMMAND: startTime=2014-08-27 03:18:45.467 requestID=WEI32e8Ynv+s.70 txID=null sessionID=WEI32e8Ynv+s applicationName=JDBCprincipal=user@teiid-security vdbName=Foo vdbVersion=1 sql=(select 'a' union select 'b') except select 'c' 03:18:45,470 INFO [org.teiid.PLANNER] (Worker13_QueryProcessorQueue748) WEI32e8Ynv+s ============================================================================ USER COMMAND: SELECT 'a' UNION SELECT 'b' EXCEPT SELECT 'c' ---------------------------------------------------------------------------- OPTIMIZE: SELECT 'a' UNION SELECT 'b' EXCEPT SELECT 'c' ---------------------------------------------------------------------------- GENERATE CANONICAL: SELECT 'a' UNION SELECT 'b' EXCEPT SELECT 'c' CANONICAL PLAN: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[], props={PROJECT_COLS=['a']}) Project(groups=[], props={PROJECT_COLS=['b']}) Project(groups=[], props={PROJECT_COLS=['c']}) ============================================================================ EXECUTING PlaceAccess AFTER: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=false}) Project(groups=[], props={PROJECT_COLS=['a']}) Project(groups=[], props={PROJECT_COLS=['b']}) Project(groups=[], props={PROJECT_COLS=['c']}) ============================================================================ EXECUTING PlanUnions AFTER: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true}) Project(groups=[]) Project(groups=[]) Project(groups=[]) ============================================================================ EXECUTING RaiseAccess AFTER: SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[]) Project(groups=[]) Project(groups=[]) ============================================================================ EXECUTING AssignOutputElements AFTER: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false, OUTPUT_COLS=['a']}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=['a']}) Project(groups=[], props={PROJECT_COLS=['a'], OUTPUT_COLS=['a']}) Project(groups=[], props={PROJECT_COLS=['b'], OUTPUT_COLS=['b']}) Project(groups=[], props={PROJECT_COLS=['c'], OUTPUT_COLS=['c']}) ============================================================================ EXECUTING CalculateCost AFTER: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false, OUTPUT_COLS=['a'], EST_CARDINALITY=1.0, EST_COL_STATS={'a'=[1.0, 1.0]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=['a'], EST_CARDINALITY=2.0, EST_COL_STATS={'a'=[1.5, 0.0]}}) Project(groups=[], props={PROJECT_COLS=['a'], OUTPUT_COLS=['a'], EST_CARDINALITY=1.0, EST_COL_STATS={'a'=[1.0, 0.0]}}) Project(groups=[], props={PROJECT_COLS=['b'], OUTPUT_COLS=['b'], EST_CARDINALITY=1.0, EST_COL_STATS={'b'=[1.0, 0.0]}}) Project(groups=[], props={PROJECT_COLS=['c'], OUTPUT_COLS=['c'], EST_CARDINALITY=1.0, EST_COL_STATS={'c'=[1.0, 0.0]}}) ============================================================================ EXECUTING PlanSorts AFTER: SetOperation(groups=[], props={SET_OPERATION=EXCEPT, USE_ALL=false, OUTPUT_COLS=['a'], EST_CARDINALITY=1.0, EST_COL_STATS={'a'=[1.0, 1.0]}}) SetOperation(groups=[], props={SET_OPERATION=UNION, USE_ALL=true, OUTPUT_COLS=['a'], EST_CARDINALITY=2.0, EST_COL_STATS={'a'=[1.5, 0.0]}}) Project(groups=[]) Project(groups=[]) Project(groups=[]) ============================================================================ EXECUTING CollapseSource AFTER: SetOperation(groups=[]) SetOperation(groups=[]) Project(groups=[]) Project(groups=[]) Project(groups=[]) ============================================================================ CONVERTING PLAN TREE TO PROCESS TREE PROCESS PLAN = JoinNode(0) [MERGE JOIN (SORT_DISTINCT/SORT_DISTINCT)] [ANTI SEMI JOIN] criteria=['a'='c'] output=['a'] ProjectNode(2) output=['a'] ['a'] ProjectNode(3) output=['b'] ['b'] ProjectNode(4) output=['c'] ['c'] ============================================================================ ---------------------------------------------------------------------------- OPTIMIZATION COMPLETE: PROCESSOR PLAN: JoinNode(0) [MERGE JOIN (SORT_DISTINCT/SORT_DISTINCT)] [ANTI SEMI JOIN] criteria=['a'='c'] output=['a'] ProjectNode(2) output=['a'] ['a'] ProjectNode(3) output=['b'] ['b'] ProjectNode(4) output=['c'] ['c'] ============================================================================ 03:18:45,473 DEBUG [org.teiid.COMMAND_LOG] (Worker13_QueryProcessorQueue748) WEI32e8Ynv+s ERROR USER COMMAND: endTime=2014-08-27 03:18:45.472 requestID=WEI32e8Ynv+s.70 txID=null sessionID=WEI32e8Ynv+s principal=user@teiid-security vdbName=Foo vdbVersion=1 finalRowCount=null 03:18:45,473 ERROR [org.teiid.PROCESSOR] (Worker13_QueryProcessorQueue748) WEI32e8Ynv+s TEIID30019 Unexpected exception for request WEI32e8Ynv+s.70: java.lang.AssertionError: Assertion failed. at org.teiid.core.util.Assertion.failed(Assertion.java:73) [teiid-common-core-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.core.util.Assertion.assertTrue(Assertion.java:68) [teiid-common-core-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.core.util.Assertion.assertTrue(Assertion.java:60) [teiid-common-core-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:158) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.SortUtility.<init>(SortUtility.java:194) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.SourceState.sort(SourceState.java:287) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.MergeJoinStrategy.loadRight(MergeJoinStrategy.java:359) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:208) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:214) [teiid-engine-8.9.0.Alpha2-SNAPSHOT.jar:8.9.0.Alpha2-SNAPSHOT] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110) [rt.jar:1.7.0_02] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603) [rt.jar:1.7.0_02] at java.lang.Thread.run(Thread.java:722) [rt.jar:1.7.0_02] {code} -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3019) Change SYSADMIN.refreshMatViewRow to support a list of rows instead of just one

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3019?page=com.atlassian.jira.plugin... ] Work on TEIID-3019 started by Steven Hawkins. --------------------------------------------- > Change SYSADMIN.refreshMatViewRow to support a list of rows instead of just one > ------------------------------------------------------------------------------- > > Key: TEIID-3019 > URL: https://issues.jboss.org/browse/TEIID-3019 > Project: Teiid > Issue Type: Feature Request > Security Level: Public(Everyone can see) > Components: Server > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 8.9 > > > Currently SYSADMIN.refreshMatViewRow supports only passing one key value so it will be nice to be able to pass multiple values or array of values for bulk updates. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3060) Additional cassandra type handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3060?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-3060 at 8/26/14 1:13 PM: ---------------------------------------------------------------- Added import support for custom/blob->varbinary. The execution logic was already returning the actual bytes. Also updated the literal format for varbinary. And ensured uuids will be formatted correctly. It would be good to use variable references to avoid the literal formats for list, set, map, etc. but that is not supported until Cassandra 2, so we can look to optionally add that or just address it when we remove support for older Cassandra instances. was (Author: shawkins): Added import support for custom/blob->varbinary. The execution logic was already returning the actual bytes. Also updated the literal format for varbinary. There is nothing that we can do for uuids at this time as the constants will already > Additional cassandra type handling > ---------------------------------- > > Key: TEIID-3060 > URL: https://issues.jboss.org/browse/TEIID-3060 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.9 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should have support for cassandra blobs/custom as varbinary (converting from bytebuffer to byte[]), list (as an array type), and better uuid handling for uuid/timeuuid support. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3060) Additional cassandra type handling

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3060?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3060. ----------------------------------- Assignee: Steven Hawkins Resolution: Done Added import support for custom/blob->varbinary. The execution logic was already returning the actual bytes. Also updated the literal format for varbinary. There is nothing that we can do for uuids at this time as the constants will already > Additional cassandra type handling > ---------------------------------- > > Key: TEIID-3060 > URL: https://issues.jboss.org/browse/TEIID-3060 > Project: Teiid > Issue Type: Enhancement > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.9 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.9 > > > We should have support for cassandra blobs/custom as varbinary (converting from bytebuffer to byte[]), list (as an array type), and better uuid handling for uuid/timeuuid support. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3100) SOLR: Connector ignores CoreName property

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3100?page=com.atlassian.jira.plugin... ] Ramesh Reddy reassigned TEIID-3100: ----------------------------------- Assignee: Ramesh Reddy (was: Steven Hawkins) > SOLR: Connector ignores CoreName property > ----------------------------------------- > > Key: TEIID-3100 > URL: https://issues.jboss.org/browse/TEIID-3100 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Fix For: 8.7.1, 8.9 > > > SOLR connector ignores CoreName property. It uses first or active core (by default "collection1"). CoreName should be appended to the Solr Server's baseUrl. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3100) SOLR: Connector ignores CoreName property

by Ramesh Reddy (JIRA)

[ https://issues.jboss.org/browse/TEIID-3100?page=com.atlassian.jira.plugin... ] Ramesh Reddy updated TEIID-3100: -------------------------------- Fix Version/s: 8.7.1 8.9 > SOLR: Connector ignores CoreName property > ----------------------------------------- > > Key: TEIID-3100 > URL: https://issues.jboss.org/browse/TEIID-3100 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Fix For: 8.7.1, 8.9 > > > SOLR connector ignores CoreName property. It uses first or active core (by default "collection1"). CoreName should be appended to the Solr Server's baseUrl. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2978) using LIKE on columns causes no results though they indeed exist

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2978?page=com.atlassian.jira.plugin... ] Van Halbert resolved TEIID-2978. -------------------------------- Resolution: Rejected The issue is resolved by the fixes in ModeShape > using LIKE on columns causes no results though they indeed exist > ---------------------------------------------------------------- > > Key: TEIID-2978 > URL: https://issues.jboss.org/browse/TEIID-2978 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Tom Johnston > Assignee: Van Halbert > Labels: modeshape, teiid > > Use of LIKE doesn't appear to work when querying modeshape through JDBC. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2978) using LIKE on columns causes no results though they indeed exist

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-2978?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-2978: ------------------------------------ Testing the latest 3.8 fixes in modeshape. And the resolution of the swapping of columns appears to fixed this issue. > using LIKE on columns causes no results though they indeed exist > ---------------------------------------------------------------- > > Key: TEIID-2978 > URL: https://issues.jboss.org/browse/TEIID-2978 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Tom Johnston > Assignee: Van Halbert > Labels: modeshape, teiid > > Use of LIKE doesn't appear to work when querying modeshape through JDBC. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3100) SOLR: Connector ignores CoreName property

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3100?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration updated TEIID-3100: ------------------------------------------- Bugzilla Update: Perform Bugzilla References: https://bugzilla.redhat.com/show_bug.cgi?id=1133848 > SOLR: Connector ignores CoreName property > ----------------------------------------- > > Key: TEIID-3100 > URL: https://issues.jboss.org/browse/TEIID-3100 > Project: Teiid > Issue Type: Bug > Security Level: Public(Everyone can see) > Components: Connector API > Affects Versions: 8.7 > Reporter: Filip Elias > Assignee: Steven Hawkins > > SOLR connector ignores CoreName property. It uses first or active core (by default "collection1"). CoreName should be appended to the Solr Server's baseUrl. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3100) SOLR: Connector ignores CoreName property

by Filip Elias (JIRA)

Filip Elias created TEIID-3100: ---------------------------------- Summary: SOLR: Connector ignores CoreName property Key: TEIID-3100 URL: https://issues.jboss.org/browse/TEIID-3100 Project: Teiid Issue Type: Bug Security Level: Public (Everyone can see) Components: Connector API Affects Versions: 8.7 Reporter: Filip Elias Assignee: Steven Hawkins SOLR connector ignores CoreName property. It uses first or active core (by default "collection1"). CoreName should be appended to the Solr Server's baseUrl. -- This message was sent by Atlassian JIRA (v6.3.1#6329)

11 years, 7 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 2014