November 2015 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3462) Add support for semantic versioning of VDBs

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3462?page=com.atlassian.jira.plugin... ] Work on TEIID-3462 started by Steven Hawkins. --------------------------------------------- > Add support for semantic versioning of VDBs > ------------------------------------------- > > Key: TEIID-3462 > URL: https://issues.jboss.org/browse/TEIID-3462 > Project: Teiid > Issue Type: Feature Request > Components: Server > Affects Versions: 8.7 > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 9.0 > > > Semantic versioning [1] should be supported in the VDB versioning in order to be able to easier determine whether there are breaking changes from the client perspective and to more easily establish a link between client software versions and the VDBs they rely upon. > [1] http://semver.org/ -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3823) Issues with fetchsize and local connections

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-3823: ------------------------------------- Summary: Issues with fetchsize and local connections Key: TEIID-3823 URL: https://issues.jboss.org/browse/TEIID-3823 Project: Teiid Issue Type: Bug Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 8.13, 8.12.3 Settting the fetchSize property on localconnections (or if the internal batch size exceeds that of the maximum fetch size, which is unlikely by default) leads to several issues: It can cause an exception or the client may seem to hang (since the logic won't properly save the current batch). -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3796) It is much more slow to get the table record through TEIID from postgresql DB

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3796?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3796. ----------------------------------- Resolution: Cannot Reproduce Bug Tried a similar scenario locally and did not see the same behavior. At the least you should try this without the fetchsize setting. You could also try the select without fetching the text columns. Please reopen if needed. > It is much more slow to get the table record through TEIID from postgresql DB > ----------------------------------------------------------------------------- > > Key: TEIID-3796 > URL: https://issues.jboss.org/browse/TEIID-3796 > Project: Teiid > Issue Type: Bug > Reporter: Xian Liu > Assignee: Steven Hawkins > > There is a table about 1000K+ record > Postgresql Version: server 9.2.7 > Postgresql DB JDBC Driver Version: postgresql-9.3-1103.jdbc4.jar > The table definition: > {code} > | Type | Modifiers > ------------+-----------------------------+------------------------------------------------------------ > | integer | not null > | integer | > | integer | not null > | timestamp without time zone | not null > | integer | not null > | text | > | text | > | bigint | > | bigint | not null > | integer | > {code} > I set driver connection parameter to disableLocalTxn=true;FetchSize=10; > 1. When I make this table available in Mysql, and select * from it in Teiid, It will quickly get the data stream after around 30s. > 2. But when I make this table in Postgresql DB, and query through Teiid, it is so slow and will get about 8min+ client can not get the data stream, > when I try to directly connect this table in Postgresql table, it is much more faster, I do not know the reason. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3682) Add logon properties to audit messages

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3682?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3682: ---------------------------------- Fix Version/s: 8.12.3 (was: 8.12.x) > Add logon properties to audit messages > -------------------------------------- > > Key: TEIID-3682 > URL: https://issues.jboss.org/browse/TEIID-3682 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Affects Versions: 8.12 > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.3 > > > We expanded logon information in 8.12, but did not yet include all logon properties, which can include the client ip address - but there are limitations since the client ip and related fields would only be set for JDBC connections and not yet for local usage through ODBC/web. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3789) Enable setting on SOLR translator for controlling timezone setting for Date and Timestamp columns

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3789?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3789. ----------------------------------- Fix Version/s: (was: 8.12.x) Resolution: Incomplete Description Marking as incomplete description until there is an example what this would do for solr. > Enable setting on SOLR translator for controlling timezone setting for Date and Timestamp columns > ------------------------------------------------------------------------------------------------- > > Key: TEIID-3789 > URL: https://issues.jboss.org/browse/TEIID-3789 > Project: Teiid > Issue Type: Enhancement > Components: Misc. Connectors > Affects Versions: 8.7.1 > Reporter: Van Halbert > > Timezone of DV server has influence on Date and Timestamp columns in some data sources -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3818) Issues with ODBC metadata foreign key queries

by Dave Nicodemus (JIRA)

[ https://issues.jboss.org/browse/TEIID-3818?page=com.atlassian.jira.plugin... ] Dave Nicodemus commented on TEIID-3818: --------------------------------------- Wow, it must be my lucky day ! Thanks again. > Issues with ODBC metadata foreign key queries > --------------------------------------------- > > Key: TEIID-3818 > URL: https://issues.jboss.org/browse/TEIID-3818 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Environment: Most likely not OS / hardware dependent. > Reporter: Dave Nicodemus > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12.2, 8.13 > > > The current foreign key handling should return imported key, but instead returns exported keys. > When exported keys are asked for an exception is thrown: > While attempting to use Client Microsoft's Power BI desktop using ODBC connecting to Teiid Embedded server using VDB with metadata tags. > Received the following errors : > {code} > [36.864]ERROR from backend during send_query: 'SERROR' > [36.865]ERROR from backend during send_query: 'C50000' > [36.869]ERROR from backend during send_query: 'MTEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [36.875]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [37.397]STATEMENT ERROR: func=PGAPI_ForeignKeys, desc='', errnum=1, errmsg='PGAPI_ForeignKeys query error' > {code} > Due to this query being generated by the BI tool : > {code} > 'select 'ScottTestMart'::name as PKTABLE_CAT, > n2.nspname as PKTABLE_SCHEM, > c2.relname as PKTABLE_NAME, > a2.attname as PKCOLUMN_NAME, > 'ScottTestMart'::name as FKTABLE_CAT, > n1.nspname as FKTABLE_SCHEM, > c1.relname as FKTABLE_NAME, > a1.attname as FKCOLUMN_NAME, > i::int2 as KEY_SEQ, > case ref.confupdtype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as UPDATE_RULE, > case ref.confdeltype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as DELETE_RULE, > ref.conname as FK_NAME, > cn.conname as PK_NAME, > case > when ref.condeferrable then > case > when ref.condeferred then 5::int2 > else 6::int2 > end > else 7::int2 > end as DEFERRABLITY > from > ((((((( (select cn.oid, conrelid, conkey, confrelid, confkey, > generate_series(array_lower(conkey, 1), array_upper(conkey, 1)) as i, > confupdtype, confdeltype, conname, > condeferrable, condeferred > from pg_catalog.pg_constraint cn, > pg_catalog.pg_class c, > pg_catalog.pg_namespace n > where contype = 'f' > and confrelid = c.oid > and relname = 'Categories' > and n.oid = c.relnamespace > and n.nspname = 'ScottTestMart' > ) ref > inner join pg_catalog.pg_class c1 > on c1.oid = ref.conrelid) > inner join pg_catalog.pg_namespace n1 > on n1.oid = c1.relnamespace) > inner join pg_catalog.pg_attribute a1 > on a1.attrelid = c1.oid > and a1.attnum = conkey[i]) > inner join pg_catalog.pg_class c2 > on c2.oid = ref.confrelid) > inner join pg_catalog.pg_namespace n2 > on n2.oid = c2.relnamespace) > inner join pg_catalog.pg_attribute a2 > on a2.attrelid = c2.oid > and a2.attnum = confkey[i]) > left outer join pg_catalog.pg_constraint cn > on cn.conrelid = ref.confrelid > and cn.contype = 'p') > order by ref.oid, ref.i' > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3818) Issues with ODBC metadata foreign key queries

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3818?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-3818: --------------------------------------- 8.12.2 was just made available, which includes the fix - http://teiid.blogspot.com/2015/11/teiid-8122-available.html > Issues with ODBC metadata foreign key queries > --------------------------------------------- > > Key: TEIID-3818 > URL: https://issues.jboss.org/browse/TEIID-3818 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Environment: Most likely not OS / hardware dependent. > Reporter: Dave Nicodemus > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12.2, 8.13 > > > The current foreign key handling should return imported key, but instead returns exported keys. > When exported keys are asked for an exception is thrown: > While attempting to use Client Microsoft's Power BI desktop using ODBC connecting to Teiid Embedded server using VDB with metadata tags. > Received the following errors : > {code} > [36.864]ERROR from backend during send_query: 'SERROR' > [36.865]ERROR from backend during send_query: 'C50000' > [36.869]ERROR from backend during send_query: 'MTEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [36.875]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [37.397]STATEMENT ERROR: func=PGAPI_ForeignKeys, desc='', errnum=1, errmsg='PGAPI_ForeignKeys query error' > {code} > Due to this query being generated by the BI tool : > {code} > 'select 'ScottTestMart'::name as PKTABLE_CAT, > n2.nspname as PKTABLE_SCHEM, > c2.relname as PKTABLE_NAME, > a2.attname as PKCOLUMN_NAME, > 'ScottTestMart'::name as FKTABLE_CAT, > n1.nspname as FKTABLE_SCHEM, > c1.relname as FKTABLE_NAME, > a1.attname as FKCOLUMN_NAME, > i::int2 as KEY_SEQ, > case ref.confupdtype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as UPDATE_RULE, > case ref.confdeltype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as DELETE_RULE, > ref.conname as FK_NAME, > cn.conname as PK_NAME, > case > when ref.condeferrable then > case > when ref.condeferred then 5::int2 > else 6::int2 > end > else 7::int2 > end as DEFERRABLITY > from > ((((((( (select cn.oid, conrelid, conkey, confrelid, confkey, > generate_series(array_lower(conkey, 1), array_upper(conkey, 1)) as i, > confupdtype, confdeltype, conname, > condeferrable, condeferred > from pg_catalog.pg_constraint cn, > pg_catalog.pg_class c, > pg_catalog.pg_namespace n > where contype = 'f' > and confrelid = c.oid > and relname = 'Categories' > and n.oid = c.relnamespace > and n.nspname = 'ScottTestMart' > ) ref > inner join pg_catalog.pg_class c1 > on c1.oid = ref.conrelid) > inner join pg_catalog.pg_namespace n1 > on n1.oid = c1.relnamespace) > inner join pg_catalog.pg_attribute a1 > on a1.attrelid = c1.oid > and a1.attnum = conkey[i]) > inner join pg_catalog.pg_class c2 > on c2.oid = ref.confrelid) > inner join pg_catalog.pg_namespace n2 > on n2.oid = c2.relnamespace) > inner join pg_catalog.pg_attribute a2 > on a2.attrelid = c2.oid > and a2.attnum = confkey[i]) > left outer join pg_catalog.pg_constraint cn > on cn.conrelid = ref.confrelid > and cn.contype = 'p') > order by ref.oid, ref.i' > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3818) Issues with ODBC metadata foreign key queries

by Dave Nicodemus (JIRA)

[ https://issues.jboss.org/browse/TEIID-3818?page=com.atlassian.jira.plugin... ] Dave Nicodemus commented on TEIID-3818: --------------------------------------- Great, thanks Steven ! How can I get the fix ? > Issues with ODBC metadata foreign key queries > --------------------------------------------- > > Key: TEIID-3818 > URL: https://issues.jboss.org/browse/TEIID-3818 > Project: Teiid > Issue Type: Bug > Components: ODBC > Affects Versions: 8.4 > Environment: Most likely not OS / hardware dependent. > Reporter: Dave Nicodemus > Assignee: Steven Hawkins > Priority: Critical > Fix For: 8.12.2, 8.13 > > > The current foreign key handling should return imported key, but instead returns exported keys. > When exported keys are asked for an exception is thrown: > While attempting to use Client Microsoft's Power BI desktop using ODBC connecting to Teiid Embedded server using VDB with metadata tags. > Received the following errors : > {code} > [36.864]ERROR from backend during send_query: 'SERROR' > [36.865]ERROR from backend during send_query: 'C50000' > [36.869]ERROR from backend during send_query: 'MTEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [36.875]ERROR from backend during send_query: 'Dorg.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "('ScottTestMart' AS [*]name[*]) as" at line 1, column 33. > Was expecting: "string" | "varbinary" | "varchar" | "boolean" | "byte" | "tinyint" | "short" | "smallint" | "char" | "integer" ...' > [37.397]STATEMENT ERROR: func=PGAPI_ForeignKeys, desc='', errnum=1, errmsg='PGAPI_ForeignKeys query error' > {code} > Due to this query being generated by the BI tool : > {code} > 'select 'ScottTestMart'::name as PKTABLE_CAT, > n2.nspname as PKTABLE_SCHEM, > c2.relname as PKTABLE_NAME, > a2.attname as PKCOLUMN_NAME, > 'ScottTestMart'::name as FKTABLE_CAT, > n1.nspname as FKTABLE_SCHEM, > c1.relname as FKTABLE_NAME, > a1.attname as FKCOLUMN_NAME, > i::int2 as KEY_SEQ, > case ref.confupdtype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as UPDATE_RULE, > case ref.confdeltype > when 'c' then 0::int2 > when 'n' then 2::int2 > when 'd' then 4::int2 > when 'r' then 1::int2 > else 3::int2 > end as DELETE_RULE, > ref.conname as FK_NAME, > cn.conname as PK_NAME, > case > when ref.condeferrable then > case > when ref.condeferred then 5::int2 > else 6::int2 > end > else 7::int2 > end as DEFERRABLITY > from > ((((((( (select cn.oid, conrelid, conkey, confrelid, confkey, > generate_series(array_lower(conkey, 1), array_upper(conkey, 1)) as i, > confupdtype, confdeltype, conname, > condeferrable, condeferred > from pg_catalog.pg_constraint cn, > pg_catalog.pg_class c, > pg_catalog.pg_namespace n > where contype = 'f' > and confrelid = c.oid > and relname = 'Categories' > and n.oid = c.relnamespace > and n.nspname = 'ScottTestMart' > ) ref > inner join pg_catalog.pg_class c1 > on c1.oid = ref.conrelid) > inner join pg_catalog.pg_namespace n1 > on n1.oid = c1.relnamespace) > inner join pg_catalog.pg_attribute a1 > on a1.attrelid = c1.oid > and a1.attnum = conkey[i]) > inner join pg_catalog.pg_class c2 > on c2.oid = ref.confrelid) > inner join pg_catalog.pg_namespace n2 > on n2.oid = c2.relnamespace) > inner join pg_catalog.pg_attribute a2 > on a2.attrelid = c2.oid > and a2.attnum = confkey[i]) > left outer join pg_catalog.pg_constraint cn > on cn.conrelid = ref.confrelid > and cn.contype = 'p') > order by ref.oid, ref.i' > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3717) Enable SNI (Server Name Indication) support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3717?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-3717. ----------------------------------- Resolution: Done Marking as complete for 8.12.2 as the JDBC client should now support SNI by using different methods to get the socket. ODBC SNI support may need to be investigated as well. Server support will be tracked by a sub-task. > Enable SNI (Server Name Indication) support > ------------------------------------------- > > Key: TEIID-3717 > URL: https://issues.jboss.org/browse/TEIID-3717 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2 > > > Enable SNI support -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

[JBoss JIRA] (TEIID-3717) Enable SNI (Server Name Indication) support

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3717?page=com.atlassian.jira.plugin... ] Steven Hawkins updated TEIID-3717: ---------------------------------- Component/s: JDBC Driver Server > Enable SNI (Server Name Indication) support > ------------------------------------------- > > Key: TEIID-3717 > URL: https://issues.jboss.org/browse/TEIID-3717 > Project: Teiid > Issue Type: Feature Request > Components: JDBC Driver, Server > Reporter: Van Halbert > Assignee: Steven Hawkins > Fix For: 8.12.2 > > > Enable SNI support -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 1 month

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues November 2015