[JBoss JIRA] (TEIID-3145) GroovyCastException when starting adminshell
by Van Halbert (JIRA)
Van Halbert created TEIID-3145:
----------------------------------
Summary: GroovyCastException when starting adminshell
Key: TEIID-3145
URL: https://issues.jboss.org/browse/TEIID-3145
Project: Teiid
Issue Type: Bug
Components: Tools
Affects Versions: 8.7.1
Reporter: Van Halbert
Assignee: Steven Hawkins
When I run adminshell.sh, admishell will throw following exception:
Exception in thread "main" org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'org.codehaus.groovy.tools.shell.util.HelpFormatter@3004baef' with class 'org.codehaus.groovy.tools.shell.util.HelpFormatter' to class 'org.apache.commons.cli.HelpFormatter'
at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:360)
at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:2394)
at groovy.lang.MetaClassImpl.setProperty(MetaClassImpl.java:3335)
at groovy.lang.MetaClassImpl.setProperties(MetaClassImpl.java:1497)
at org.codehaus.groovy.runtime.callsite.ConstructorSite$NoParamSite.callConstructor(ConstructorSite.java:122)
at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCallConstructor(CallSiteArray.java:57)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:182)
at org.codehaus.groovy.runtime.callsite.AbstractCallSite.callConstructor(AbstractCallSite.java:190)
at org.codehaus.groovy.tools.shell.Main.main(Main.groovy:50)
at org.teiid.adminshell.GroovyAdminShell.main(GroovyAdminShell.java:30)
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3144) Unrelated correlated subquery in order by not working
by Steven Hawkins (JIRA)
Steven Hawkins created TEIID-3144:
-------------------------------------
Summary: Unrelated correlated subquery in order by not working
Key: TEIID-3144
URL: https://issues.jboss.org/browse/TEIID-3144
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.9
A query such as the one below will fail with a low level exception:
{code}
select * from foo order by (select count(*) from x where x.fid = foo.id)
{code}
We should either validate against or update the logic (probably adding an inline view in the rewriter).
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3143) LOOP on UNION leads to java.lang.ClassCastException
by Alex K. (JIRA)
Alex K. created TEIID-3143:
------------------------------
Summary: LOOP on UNION leads to java.lang.ClassCastException
Key: TEIID-3143
URL: https://issues.jboss.org/browse/TEIID-3143
Project: Teiid
Issue Type: Feature Request
Reporter: Alex K.
Assignee: Steven Hawkins
the following query
{code:sql}
begin
LOOP ON (
select a
FROM schema.table
union
select b
FROM schema.table
) as cur
begin
end
end
{code}
results in this exception (Teiid-8.9.0-Beta-1) on my machine
{code:java}
ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue11) H10b/QbWzo4K TEIID30019 Unexpected exception forrequest H10b/QbWzo4K.6: java.lang.ClassCastException: org.teiid.query.sql.lang.SetQuery cannot be casttoorg.teiid.query.sql.lang.Query
at org.teiid.query.sql.proc.LoopStatement.clone(LoopStatement.java:136) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.query.sql.LanguageObject$Util.deepClone(LanguageObject.java:57) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.query.sql.proc.Block.clone(Block.java:147) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.query.sql.proc.CreateProcedureCommand.clone(CreateProcedureCommand.java:116) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:377) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.Request.processRequest(Request.java:437) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:609) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.9.0.Beta1.jar:8.9.0.Beta1]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_51]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_51]
atjava.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_51]
{code}
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ]
Steven Hawkins commented on TEIID-3141:
---------------------------------------
I can confirm this is a sybase issue and it's not one that is particularly easy for us to workaround. Part of the issue is the usage of the bqt mapping layer that introduces a lot of conversion logic to match the virtual layer types - as those are the columns that have missing values. I would defer this issue for now.
> Bad result of query with GROUB BY clause (underlying sybase15 datasource)
> -------------------------------------------------------------------------
>
> Key: TEIID-3141
> URL: https://issues.jboss.org/browse/TEIID-3141
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora20
> arch: x86_64
> java: sun 1.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Description:
> There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
> I am trying to run query against VDB:
> SELECT
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> FROM
> BQT1.SMALLA
> GROUP BY
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> Result is table which misses some values (the other values are OK):
> FloatNum: always 0
> ByteNum: always 0
> DateValue: always 1900-01-01
> TimeValue: always 00:00:00
> BooleanValue: always 'false'
> CharValue: always empty character
> ShortValue: always 0
> BigIntegerValue: always 0
> BigDecimalValue: always 0
> After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).
> ///////////////////
> Table definition
> ///////////////////
> SmallA (sybase) has these columns (name:type):
> IntKey:int -> PRIMARY KEY, HAS INDEX
> StringKey:varchar -> HAS INDEX
> IntNum:int
> StringNum:varchar
> FloatNum:float
> LongNum:numeric
> DoubleNum:float
> ByteNum:real
> DateValue:datetime
> TimeValue:datetime
> TimestampValue:datetime
> BooleanValue:tinyint
> CharValue:char
> ShortValue:numeric
> BigIntegerValue:numeric
> BigDecimalValue:numeric
> ObjectValue:text
> SmallA (VDB) has these columns (name:type):
> IntKey:integer
> StringKey:string
> IntNum:integer
> StringNum:string
> FloatNum:float
> LongNum:long
> DoubleNum:double
> ByteNum:byte
> DateValue:date
> TimeValue:time
> TimestampValue:timestamp
> BooleanValue:boolean
> CharValue:char
> ShortValue:short
> BigIntegerValue:biginteger
> BigDecimalValue:bigdecimal
> ObjectValue:object
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3141) Bad result of query with GROUB BY clause (underlying sybase15 datasource)
by Steven Hawkins (JIRA)
[ https://issues.jboss.org/browse/TEIID-3141?page=com.atlassian.jira.plugin... ]
Steven Hawkins updated TEIID-3141:
----------------------------------
Attachment: (was: Syb.zip)
> Bad result of query with GROUB BY clause (underlying sybase15 datasource)
> -------------------------------------------------------------------------
>
> Key: TEIID-3141
> URL: https://issues.jboss.org/browse/TEIID-3141
> Project: Teiid
> Issue Type: Bug
> Affects Versions: 8.7.1
> Environment: OS: fedora20
> arch: x86_64
> java: sun 1.7
> Reporter: Juraj Duráni
> Assignee: Steven Hawkins
>
> Description:
> There is sybase15 database with table named SmallA and table named SmallA in VDB which is mapped to sybase table (see tables definition below).
> I am trying to run query against VDB:
> SELECT
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> FROM
> BQT1.SMALLA
> GROUP BY
> INTKEY, STRINGKEY, INTNUM, STRINGNUM, FLOATNUM, LONGNUM, DOUBLENUM, BYTENUM, DATEVALUE, TIMEVALUE, TIMESTAMPVALUE, BOOLEANVALUE, CHARVALUE, SHORTVALUE, BIGINTEGERVALUE, BIGDECIMALVALUE
> Result is table which misses some values (the other values are OK):
> FloatNum: always 0
> ByteNum: always 0
> DateValue: always 1900-01-01
> TimeValue: always 00:00:00
> BooleanValue: always 'false'
> CharValue: always empty character
> ShortValue: always 0
> BigIntegerValue: always 0
> BigDecimalValue: always 0
> After removing 'INTKEY' and 'STRINGKEY' from the query is result OK (sybase15 has indices only for these two columns).
> ///////////////////
> Table definition
> ///////////////////
> SmallA (sybase) has these columns (name:type):
> IntKey:int -> PRIMARY KEY, HAS INDEX
> StringKey:varchar -> HAS INDEX
> IntNum:int
> StringNum:varchar
> FloatNum:float
> LongNum:numeric
> DoubleNum:float
> ByteNum:real
> DateValue:datetime
> TimeValue:datetime
> TimestampValue:datetime
> BooleanValue:tinyint
> CharValue:char
> ShortValue:numeric
> BigIntegerValue:numeric
> BigDecimalValue:numeric
> ObjectValue:text
> SmallA (VDB) has these columns (name:type):
> IntKey:integer
> StringKey:string
> IntNum:integer
> StringNum:string
> FloatNum:float
> LongNum:long
> DoubleNum:double
> ByteNum:byte
> DateValue:date
> TimeValue:time
> TimestampValue:timestamp
> BooleanValue:boolean
> CharValue:char
> ShortValue:short
> BigIntegerValue:biginteger
> BigDecimalValue:bigdecimal
> ObjectValue:object
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3121) Teiid Standalone Server
by Ramesh Reddy (JIRA)
[ https://issues.jboss.org/browse/TEIID-3121?page=com.atlassian.jira.plugin... ]
Ramesh Reddy commented on TEIID-3121:
-------------------------------------
Maven build is same as what Teiid does for running arquillian tests in test-integration-common package. The pom.xml should have all the needed code.
I was resisting because additional artifact can cause some confusion and obstruct with any download stats of JBoss EAP. If we want this, may be just build the standalone server and let go what we have currently at least from download page. Another negligible downside is, the size of the download.
> Teiid Standalone Server
> -----------------------
>
> Key: TEIID-3121
> URL: https://issues.jboss.org/browse/TEIID-3121
> Project: Teiid
> Issue Type: Feature Request
> Components: Build/Kits
> Reporter: Tom Arnold
> Fix For: Open To Community
>
>
> Perform the server installation steps as part of the build and add the result to the downloads page. It seems like this is something that everyone who isn't using the embedded kit has to do anyways, and would hopefully eliminate confusion caused by people trying to deploy the runtime in unsupported versions of JBoss.
> * Teiid Runtime
> * Teiid Web Console
> * JBoss EAP 6.1 Alpha
> * Resteasy JAX-RS Patch
> End result would simplify the installation process to:
> 1. Unzip Teiid server.
> 2. Run `bin/add-user.sh` script.
> 3. Deploy custom translators, VDB, etc.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months
[JBoss JIRA] (TEIID-3137) Change infinispan-cache translator to support JDG 6 and no longer support pre 6.0 infinispan
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIID-3137?page=com.atlassian.jira.plugin... ]
Van Halbert edited comment on TEIID-3137 at 9/26/14 8:47 AM:
-------------------------------------------------------------
The commit to 8.9 does the following:
- removes the connector-infinispan resource adapter, which was only supporting Infinispan 5
- upgraded translator-object from supporting Infinispan 5 to 6.
The packaging changes, which will no longer include Infinispan 6 jar's in the kit, will be handled in TEIID-2700.
was (Author: van.halbert):
The commit does the following:
- removes the connector-infinispan resource adapter, which was only supporting Infinispan 5
- upgraded translator-object from supporting Infinispan 5 to 6.
The packaging changes, which will no longer include Infinispan 6 jar's in the kit, will be handled in TEIID-2700.
> Change infinispan-cache translator to support JDG 6 and no longer support pre 6.0 infinispan
> --------------------------------------------------------------------------------------------
>
> Key: TEIID-3137
> URL: https://issues.jboss.org/browse/TEIID-3137
> Project: Teiid
> Issue Type: Enhancement
> Components: Misc. Connectors
> Affects Versions: 8.7.1, 8.9
> Reporter: Van Halbert
> Assignee: Steven Hawkins
>
> Change the infinispan-cache translator to support JDG 6 using library mode. Also, remove support for infinispan v.5.
--
This message was sent by Atlassian JIRA
(v6.3.1#6329)
10 years, 5 months