[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ]
Matus Makovy reassigned TEIIDDES-2771:
--------------------------------------
Assignee: Barry LaFond
> Cannot edit Native Type extension property for procedure parameter with OUT direction
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2771
> URL: https://issues.jboss.org/browse/TEIIDDES-2771
> Project: Teiid Designer
> Issue Type: Bug
> Components: Extension Framework, Modeling
> Affects Versions: 9.0.5
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 9.0.6, 10.0.1, 9.2.1
>
>
> Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set.
> Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction
by Matus Makovy (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ]
Matus Makovy reassigned TEIIDDES-2771:
--------------------------------------
Assignee: Matus Makovy (was: Barry LaFond)
> Cannot edit Native Type extension property for procedure parameter with OUT direction
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2771
> URL: https://issues.jboss.org/browse/TEIIDDES-2771
> Project: Teiid Designer
> Issue Type: Bug
> Components: Extension Framework, Modeling
> Affects Versions: 9.0.5
> Reporter: Barry LaFond
> Assignee: Matus Makovy
> Priority: Critical
> Fix For: 9.0.6, 10.0.1, 9.2.1
>
>
> Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set.
> Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2772) Error during import from REST(JSON) with parameters and HTTP Basic authentication
by Matus Makovy (JIRA)
Matus Makovy created TEIIDDES-2772:
--------------------------------------
Summary: Error during import from REST(JSON) with parameters and HTTP Basic authentication
Key: TEIIDDES-2772
URL: https://issues.jboss.org/browse/TEIIDDES-2772
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.0.5
Environment: MAC
Reporter: Matus Makovy
When I try to import from REST WS with response type JSON and using basic http authentication querying the resulting procedure fails with exception.
There are two different exceptions that occur when I submit a query like:
{code:sql}
exec procedureName();
{code}
The first one is:
{code}
09:24:29,984 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue5) TEIID30019 Unexpected exception for request VybxGbwVwPKO.0: java.lang.ArrayIndexOutOfBoundsException
at java.lang.System.arraycopy(Native Method) [rt.jar:1.8.0_71]
at java.io.PushbackInputStream.unread(PushbackInputStream.java:235) [rt.jar:1.8.0_71]
at org.teiid.query.function.source.XMLSystemFunctions.getJsonReader(XMLSystemFunctions.java:919) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:909) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71]
{code}
and the second one:
{code}
09:24:33,648 ERROR [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue8) TEIID30019 Unexpected exception for request vuGT8dEIISNy.0: org.teiid.core.TeiidRuntimeException: Unexpected character (<) at position 0.
at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:380) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.peek(XMLSystemFunctions.java:368) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at javax.xml.transform.stax.StAXSource.<init>(StAXSource.java:111) [rt.jar:1.8.0_71]
at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:959) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.function.source.XMLSystemFunctions.jsonToXml(XMLSystemFunctions.java:910) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.eval.Evaluator.evaluateParameter(Evaluator.java:1079) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.eval.Evaluator.evaluateParameters(Evaluator.java:1055) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.XMLTableNode.evaluate(XMLTableNode.java:229) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.XMLTableNode.nextBatchDirect(XMLTableNode.java:179) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.NestedTableJoinStrategy.process(NestedTableJoinStrategy.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:211) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.common.buffer.AbstractTupleSource.hasNext(AbstractTupleSource.java:92) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.executePlan(ProcedurePlan.java:568) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.CreateCursorResultSetInstruction.process(CreateCursorResultSetInstruction.java:68) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.processProcedure(ProcedurePlan.java:360) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatchDirect(ProcedurePlan.java:287) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.proc.ProcedurePlan.nextBatch(ProcedurePlan.java:261) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.PlanExecutionNode.nextBatchDirect(PlanExecutionNode.java:118) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:146) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:278) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:136) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:151) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:159) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:141) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:444) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:326) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:254) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_71]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_71]
at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_71]
Caused by: javax.xml.stream.XMLStreamException: Unexpected character (<) at position 0.
at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:354) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.next(XMLSystemFunctions.java:378) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
... 49 more
Caused by: Unexpected character (<) at position 0.
at org.teiid.json.simple.Yylex.yylex(Yylex.java:612) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.json.simple.JSONParser.nextToken(JSONParser.java:125) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.json.simple.JSONParser.parse(JSONParser.java:185) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
at org.teiid.query.function.source.XMLSystemFunctions$JsonToXmlContentHandler.nextEvent(XMLSystemFunctions.java:350) [teiid-engine-8.7.1.6_2-redhat-6.jar:8.7.1.6_2-redhat-6]
... 50 more
{code}
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ]
Barry LaFond updated TEIIDDES-2771:
-----------------------------------
Fix Version/s: 9.0.6
> Cannot edit Native Type extension property for procedure parameter with OUT direction
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2771
> URL: https://issues.jboss.org/browse/TEIIDDES-2771
> Project: Teiid Designer
> Issue Type: Bug
> Components: Extension Framework, Modeling
> Affects Versions: 9.0.5
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 9.0.6, 10.0.1, 9.2.1
>
>
> Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set.
> Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2771?page=com.atlassian.jira.plu... ]
Barry LaFond reassigned TEIIDDES-2771:
--------------------------------------
Assignee: Barry LaFond
> Cannot edit Native Type extension property for procedure parameter with OUT direction
> -------------------------------------------------------------------------------------
>
> Key: TEIIDDES-2771
> URL: https://issues.jboss.org/browse/TEIIDDES-2771
> Project: Teiid Designer
> Issue Type: Bug
> Components: Extension Framework, Modeling
> Affects Versions: 9.0.5
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Priority: Critical
> Fix For: 10.0.1, 9.2.1
>
>
> Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set.
> Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2771) Cannot edit Native Type extension property for procedure parameter with OUT direction
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2771:
--------------------------------------
Summary: Cannot edit Native Type extension property for procedure parameter with OUT direction
Key: TEIIDDES-2771
URL: https://issues.jboss.org/browse/TEIIDDES-2771
Project: Teiid Designer
Issue Type: Bug
Components: Extension Framework, Modeling
Affects Versions: 9.0.5
Reporter: Barry LaFond
Priority: Critical
Fix For: 10.0.1, 9.2.1
Selecting an OUT parameter and editing the string ends up with empty string, so it's not getting set.
Found that RelationalModelExtensionAssistant.setPropertyValue() wasn't properly checking for NATIVE_TYPE property, so the value was never getting set. Should be simple fix. Verified that once enabled, this property is getting indexed correctly in RuntimeAdapter.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2660) Add support in Designer for foreign keys cross models
by Van Halbert (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2660?page=com.atlassian.jira.plu... ]
Van Halbert updated TEIIDDES-2660:
----------------------------------
Fix Version/s: 10.0.2
> Add support in Designer for foreign keys cross models
> -----------------------------------------------------
>
> Key: TEIIDDES-2660
> URL: https://issues.jboss.org/browse/TEIIDDES-2660
> Project: Teiid Designer
> Issue Type: Feature Request
> Components: Modeling
> Reporter: Van Halbert
> Assignee: Barry LaFond
> Fix For: 10.0.2
>
>
> Add support in Designer for foreign keys cross models.
> In Designer you cannot have a FK cross models. That is not a limitation with DDL metadata in Teiid. It's a misstatement to relate that to optimization. If the PK/FK is present we'll use that information just as we would in a single source - we do not however enforce the FK. That can be done through the use of an update procedure though.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2770) Illegal argument exception opening function builder with projected "constant"
by Barry LaFond (JIRA)
[ https://issues.jboss.org/browse/TEIIDDES-2770?page=com.atlassian.jira.plu... ]
Barry LaFond resolved TEIIDDES-2770.
------------------------------------
Resolution: Done
master: https://github.com/Teiid-Designer/teiid-designer/commit/03adb04fb77b44074...
> Illegal argument exception opening function builder with projected "constant"
> -----------------------------------------------------------------------------
>
> Key: TEIIDDES-2770
> URL: https://issues.jboss.org/browse/TEIIDDES-2770
> Project: Teiid Designer
> Issue Type: Bug
> Affects Versions: 9.2, 9.0.5
> Reporter: Barry LaFond
> Assignee: Barry LaFond
> Fix For: 10.0.1, 9.2.1
>
>
> Simple SQL = SELECT 'abc' as b
> Ttrows illegal arg check (below). Need to do check annotations on the DataTypeName for valid version via AnnotationUtils.isApplicable() method.
> java.lang.IllegalArgumentException: Type not applicable for this teiid version (version=8.7.1, type=GEOMETRY)
> at org.teiid.core.util.ArgCheck.isTrue(ArgCheck.java:53)
> at org.teiid.core.types.DataTypeManagerService.getDefaultDataType(DataTypeManagerService.java:565)
> at org.teiid.query.ui.builder.util.BuilderUtils.isValidType(BuilderUtils.java:311)
> at org.teiid.query.ui.builder.util.BuilderUtils.isConversionType(BuilderUtils.java:180)
> at org.teiid.query.ui.builder.model.ConstantEditorModel.setConstant(ConstantEditorModel.java:358)
> at org.teiid.query.ui.builder.model.ConstantEditorModel.setLanguageObject(ConstantEditorModel.java:419)
> at org.teiid.query.ui.builder.model.CompositeLanguageObjectEditorModel.setLanguageObject(CompositeLanguageObjectEditorModel.java:203)
> at org.teiid.designer.transformation.ui.builder.AbstractCompositeLanguageObjectEditor.setLanguageObject(AbstractCompositeLanguageObjectEditor.java:202)
> at org.teiid.designer.transformation.ui.builder.AbstractCompositeExpressionEditor.setLanguageObject(AbstractCompositeExpressionEditor.java:236)
> at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.setEditorLanguageObject(AbstractLanguageObjectBuilder.java:466)
> at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.handleTreeSelection(AbstractLanguageObjectBuilder.java:439)
> at org.teiid.designer.transformation.ui.builder.ExpressionBuilder.handleTreeSelection(ExpressionBuilder.java:85)
> at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder$5.selectionChanged(AbstractLanguageObjectBuilder.java:280)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months
[JBoss JIRA] (TEIIDDES-2770) Illegal argument exception opening function builder with projected "constant"
by Barry LaFond (JIRA)
Barry LaFond created TEIIDDES-2770:
--------------------------------------
Summary: Illegal argument exception opening function builder with projected "constant"
Key: TEIIDDES-2770
URL: https://issues.jboss.org/browse/TEIIDDES-2770
Project: Teiid Designer
Issue Type: Bug
Affects Versions: 9.2, 9.0.5
Reporter: Barry LaFond
Assignee: Barry LaFond
Fix For: 10.0.1, 9.2.1
Simple SQL = SELECT 'abc' as b
Ttrows illegal arg check (below). Need to do check annotations on the DataTypeName for valid version via AnnotationUtils.isApplicable() method.
java.lang.IllegalArgumentException: Type not applicable for this teiid version (version=8.7.1, type=GEOMETRY)
at org.teiid.core.util.ArgCheck.isTrue(ArgCheck.java:53)
at org.teiid.core.types.DataTypeManagerService.getDefaultDataType(DataTypeManagerService.java:565)
at org.teiid.query.ui.builder.util.BuilderUtils.isValidType(BuilderUtils.java:311)
at org.teiid.query.ui.builder.util.BuilderUtils.isConversionType(BuilderUtils.java:180)
at org.teiid.query.ui.builder.model.ConstantEditorModel.setConstant(ConstantEditorModel.java:358)
at org.teiid.query.ui.builder.model.ConstantEditorModel.setLanguageObject(ConstantEditorModel.java:419)
at org.teiid.query.ui.builder.model.CompositeLanguageObjectEditorModel.setLanguageObject(CompositeLanguageObjectEditorModel.java:203)
at org.teiid.designer.transformation.ui.builder.AbstractCompositeLanguageObjectEditor.setLanguageObject(AbstractCompositeLanguageObjectEditor.java:202)
at org.teiid.designer.transformation.ui.builder.AbstractCompositeExpressionEditor.setLanguageObject(AbstractCompositeExpressionEditor.java:236)
at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.setEditorLanguageObject(AbstractLanguageObjectBuilder.java:466)
at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder.handleTreeSelection(AbstractLanguageObjectBuilder.java:439)
at org.teiid.designer.transformation.ui.builder.ExpressionBuilder.handleTreeSelection(ExpressionBuilder.java:85)
at org.teiid.designer.transformation.ui.builder.AbstractLanguageObjectBuilder$5.selectionChanged(AbstractLanguageObjectBuilder.java:280)
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)
8 years, 5 months