July 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3220) Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3220?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3220. --------------------------------- > Datafederation quick start needs materialization teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT changed to match docs > ----------------------------------------------------------------------------------------------------------- > > Key: TEIID-3220 > URL: https://issues.jboss.org/browse/TEIID-3220 > Project: Teiid > Issue Type: Enhancement > Components: Quick Starts > Affects Versions: 8.7.1, 8.10 > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Minor > Fix For: 8.10 > > > The data federation quick start does not demonstrate the same way of loading in the materialized table by executing multiple statements when "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" is performed, as the doc's do (based on the latest changes). > It should now use the following to work like the doc's prescribe: > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute accounts.native(''ALTER TABLE h2_stock_mat RENAME TO h2_stock_mat_temp'');execute accounts.native(''ALTER TABLE mat_stock_staging RENAME TO h2_stock_mat'');execute accounts.native(''ALTER TABLE h2_stock_mat_temp RENAME TO mat_stock_staging'');', > -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3147) Add information about the amount of data (in bytes) returned by each query

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3147?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3147. --------------------------------- > Add information about the amount of data (in bytes) returned by each query > -------------------------------------------------------------------------- > > Key: TEIID-3147 > URL: https://issues.jboss.org/browse/TEIID-3147 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Joao Viragine > Assignee: Steven Hawkins > Fix For: 8.9 > > > It would be nice if we had the information about the amount of data (in bytes) returned by each query. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2988) MongoDB: Function substring - starting index and number of arguments

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-2988?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-2988. --------------------------------- > MongoDB: Function substring - starting index and number of arguments > -------------------------------------------------------------------- > > Key: TEIID-2988 > URL: https://issues.jboss.org/browse/TEIID-2988 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.4.1 > Reporter: Filip Elias > Assignee: Ramesh Reddy > Labels: Beta1 > Fix For: 8.8, 8.7.1, 8.10 > > > Two minor bugs in function substring() > Mongo's function $substr takes only 3 arguments so this query fails: > {code} > SELECT intkey, SUBSTRING(BQT1.SmallA.stringkey, 1) FROM BQT1.SmallA ORDER BY intkey > {code} > {code} > Exception:13:18:48,220 ERROR [org.teiid.CONNECTOR] (Worker38_QueryProcessorQueue345) Connector worker process failed for atomic-request=omsmHP0o16Sa.40.0.86: com.mongodb.CommandFailureException: { "serverUsed" : "localhost/127.0.0.1:27017" , "errmsg" : "exception: the $substr operator requires 3 operand(s)" , "code" : 16020 , "ok" : 0.0} > at com.mongodb.CommandResult.getException(CommandResult.java:71) > at com.mongodb.CommandResult.throwOnError(CommandResult.java:110) > at com.mongodb.DBCollection.aggregate(DBCollection.java:1308) > {code} > Generated mongo command: > {code} > { aggregate: "smalla", pipeline: [ { $project: { c_0: "$INTKEY", c_1: { $substr: [ "$STRINGKEY", 1 ] } } }, { $sort: { c_0: 1 } } ] } > {code} > Mongo's $substr function second argument represents number of bytes to skip, not the starting index. The function substring(StringKey,1,1) returns the second letter, but it should return the first letter. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3561) Support HTTP Basic Digest mode in Web Service connector

by Ramesh Reddy (JIRA)

Ramesh Reddy created TEIID-3561: ----------------------------------- Summary: Support HTTP Basic Digest mode in Web Service connector Key: TEIID-3561 URL: https://issues.jboss.org/browse/TEIID-3561 Project: Teiid Issue Type: Enhancement Components: Misc. Connectors Reporter: Ramesh Reddy Assignee: Ramesh Reddy Currently the the ra.xml configuration does not support "digest" based authentication. The workaround is to define it in the cxf configuration file as {code} <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:cxf="http://cxf.apache.org/core" xmlns:jaxrs="http://cxf.apache.org/jaxrs" xmlns:sec="http://cxf.apache.org/configuration/security" xmlns:http-conf="http://cxf.apache.org/transports/http/configuration" xmlns:jaxws="http://java.sun.com/xml/ns/jaxws" xsi:schemaLocation="http://cxf.apache.org/transports/http/configuration http://cxf.apache.org/schemas/configuration/http-conf.xsd http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://cxf.apache.org/configuration/security http://cxf.apache.org/schemas/configuration/security.xsd http://cxf.apache.org/core http://cxf.apache.org/schemas/core.xsd"> <http-conf:conduit name="*.http-conduit"> <http-conf:client ConnectionTimeout="120000" ReceiveTimeout="240000"/> <http-conf:tlsClientParameters secureSocketProtocol="TLS">  </http-conf:tlsClientParameters> <http-conf:authorization> <sec:UserName>user</sec:UserName> <sec:Password>password</sec:Password> <sec:AuthorizationType>Digest</sec:AuthorizationType> </http-conf:authorization> </http-conf:conduit>  </beans> {code} -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3502) Teiid returns integer/long overflow values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-3502 at 7/6/15 1:54 PM: --------------------------------------------------------------- The fix introduce a hard exception with certain odbc types - bigdecimal, biginteger, float, double that have large precision or scale values. So this will only be partially resolved in 8.11. was (Author: shawkins): The fix introduce a hard exception with certain odbc types - bigdecimal, biginteger, float, double that have large precision or scale values. > Teiid returns integer/long overflow values > ------------------------------------------ > > Key: TEIID-3502 > URL: https://issues.jboss.org/browse/TEIID-3502 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.1 > > > The values from basic math operations, such as: > SELECT abs(-2147483648) > SELECT -2147483648 -1 > SELECT 2147483648 +1 > etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3502) Teiid returns integer/long overflow values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3502: ---------------------------------- Fix Version/s: 8.12 8.11.1 (was: 8.11) > Teiid returns integer/long overflow values > ------------------------------------------ > > Key: TEIID-3502 > URL: https://issues.jboss.org/browse/TEIID-3502 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.12, 8.11.1 > > > The values from basic math operations, such as: > SELECT abs(-2147483648) > SELECT -2147483648 -1 > SELECT 2147483648 +1 > etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3502) Teiid returns integer/long overflow values

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3502?page=com.atlassian.jira.plugin... ] Steven Hawkins reopened TEIID-3502: ----------------------------------- The fix introduce a hard exception with certain odbc types - bigdecimal, biginteger, float, double that have large precision or scale values. > Teiid returns integer/long overflow values > ------------------------------------------ > > Key: TEIID-3502 > URL: https://issues.jboss.org/browse/TEIID-3502 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.1.6_2 > Reporter: Juraj Duráni > Assignee: Steven Hawkins > Fix For: 8.11 > > > The values from basic math operations, such as: > SELECT abs(-2147483648) > SELECT -2147483648 -1 > SELECT 2147483648 +1 > etc. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3560) support common table expression with insert/update/delete

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3560?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3560: --------------------------------------- The insert case can easily be worked around by associating the common table with the query expression. Since the update/delete cases should be rarely needed, this will not be targeted to a release for now. > support common table expression with insert/update/delete > --------------------------------------------------------- > > Key: TEIID-3560 > URL: https://issues.jboss.org/browse/TEIID-3560 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > > We currently have limited our cte support to just query expressions. This should be generalized to more statement types. -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3526) Issues with insert and query expression with a common table expression

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3526?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3526. ----------------------------------- Resolution: Done The logic was not generally correct in the insert case and the with clause was not getting associated. That has been corrected. Also added a new capability to describe if WITH is supported in subqueries. Insert with a query expression and a common table expression is still pushed and it's up to the translator to move the clause to the beginning of the source command - this may be modified by TEIID-3560 > Issues with insert and query expression with a common table expression > ---------------------------------------------------------------------- > > Key: TEIID-3526 > URL: https://issues.jboss.org/browse/TEIID-3526 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > SQL Server will not support a source query of the form: > insert into tbl with ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3526) Issues with insert and query expression with a common table expression

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3526?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3526: ---------------------------------- Summary: Issues with insert and query expression with a common table expression (was: SQL Server does not support insert with query expression and a common table expression) Issue Type: Bug (was: Quality Risk) > Issues with insert and query expression with a common table expression > ---------------------------------------------------------------------- > > Key: TEIID-3526 > URL: https://issues.jboss.org/browse/TEIID-3526 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12 > > > SQL Server will not support a source query of the form: > insert into tbl with ... -- This message was sent by Atlassian JIRA (v6.3.15#6346)

10 years, 9 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 July 2015