August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3270) Allow UDFs to call Teiid functions

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3270?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3270: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1295461|https://bugzilla.redhat.com/show_bug.cgi?id=1295461] from VERIFIED to CLOSED > Allow UDFs to call Teiid functions > ---------------------------------- > > Key: TEIID-3270 > URL: https://issues.jboss.org/browse/TEIID-3270 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Reporter: Sanjeev Gour > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > Currently custom functions require the implementation on be in Java, there could be an alternative way to allow using Teiid expressions inside the custom functions. The related thread is here- > https://developer.jboss.org/thread/251179 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4255) Transformation exception when parsing time in SAP NW Gateway

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4255?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4255: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1343827|https://bugzilla.redhat.com/show_bug.cgi?id=1343827] from VERIFIED to CLOSED > Transformation exception when parsing time in SAP NW Gateway > ------------------------------------------------------------ > > Key: TEIID-4255 > URL: https://issues.jboss.org/browse/TEIID-4255 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.x > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.12.5 > > > When querying the SAP Sample Flight demo web service using the sap-nw-gateway, the following error is logged when the response contains time value in the form "PT11H00M00S" > {noformat} > org.teiid.jdbc.TeiidSQLException: TEIID10068 Failed to transform String to Time. Expected format = hh:mm:ss for PT11H00M00S at org.jboss.qe.dvqe.reproducers.Teiid3841Test.runTest(Teiid3841Test.java:61) Caused by: org.teiid.core.types.TransformationException: TEIID10068 Failed to transform String to Time. Expected format = hh:mm:ss for PT11H00M00S > {noformat} > This is likely a regression as that query works in DV 6.2 with latest patch. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4003) Vertica and DB2 translators use incorrect push down of WEEK function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4003?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4003: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1312264|https://bugzilla.redhat.com/show_bug.cgi?id=1312264] from VERIFIED to CLOSED > Vertica and DB2 translators use incorrect push down of WEEK function > -------------------------------------------------------------------- > > Key: TEIID-4003 > URL: https://issues.jboss.org/browse/TEIID-4003 > Project: Teiid > Issue Type: Bug > Components: JDBC Connector > Reporter: Andrej Šmigala > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.2 > > > TEIID-3282 changed the semantics of the WEEK function to use the iso behaviour. > The Vertica database has WEEK_ISO function that returns the iso week, but the translator does not have that alias set. > This results in the query (the datevalue in question is 2000-12-31) > {code:sql} > select week(datevalue) from source.largea where intkey = 365 > {code} > to return 54, when the correct value is 52. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3419) Add ability to set a default role across all VDBs

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3419?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3419: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1296115|https://bugzilla.redhat.com/show_bug.cgi?id=1296115] from VERIFIED to CLOSED > Add ability to set a default role across all VDBs > ------------------------------------------------- > > Key: TEIID-3419 > URL: https://issues.jboss.org/browse/TEIID-3419 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Marc Shirley > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > There should be an ability to either set a default role across the server, or to restrict access by default. For example, all VDBs have a default user role that is applied before the VDB specific roles are. Alternatively, there could be a system wide flag that toggles the behavior of VDBs when no roles are defined between accessible to all or denied to all. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4226) HANA translator: boolean type converted to tinyint in each convert

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4226?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4226: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1339652|https://bugzilla.redhat.com/show_bug.cgi?id=1339652] from VERIFIED to CLOSED > HANA translator: boolean type converted to tinyint in each convert > ------------------------------------------------------------------ > > Key: TEIID-4226 > URL: https://issues.jboss.org/browse/TEIID-4226 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Priority: Critical > Fix For: 9.0, 8.12.5, 8.13.5 > > > HANA translator blindly converts boolean values to tinyint when a boolean column is pushed as part of a convert function to datasource. > Example query: > {code:sql} > SELECT CONCAT2(stringNum,booleanvalue) FROM BQT1.SmallA; > {code} > and its DATA SRC COMMAND: > {code:sql} > SELECT CONCAT2(g_0.STRINGNUM, convert(g_0.BOOLEANVALUE, string)) FROM BQT1.SMALLA AS g_0 > {code} > and its SOURCE SRC COMMAND: > {code:sql} > SELECT CASE WHEN g_0."STRINGNUM" IS NULL AND cast(g_0."BOOLEANVALUE" AS tinyint) IS NULL THEN NULL ELSE concat(ifnull(g_0."STRINGNUM", ''), ifnull(cast(g_0."BOOLEANVALUE" AS tinyint), '')) END FROM "BQT1"."SMALLA" AS g_0 > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4277) Infinispan Cache DSL translator: materialization incomplete results during view's loading

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4277?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4277: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1347582|https://bugzilla.redhat.com/show_bug.cgi?id=1347582] from VERIFIED to CLOSED > Infinispan Cache DSL translator: materialization incomplete results during view's loading > ----------------------------------------------------------------------------------------- > > Key: TEIID-4277 > URL: https://issues.jboss.org/browse/TEIID-4277 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 9.x, 8.12.5 > Reporter: Jan Stastny > Assignee: Van Halbert > Priority: Blocker > Fix For: 9.1, 8.12.5 > > Attachments: test.log > > > When user tries to query materialized view in a moment when its loading is in progress, incomplete results are returned. The status of the view in corresponding status table is LOADING. > Vdb used: > {code:xml} > <?xml version="1.0" encoding="UTF-8"?> > <vdb name="jdg-remote" version="1"> > <description>For testing of materialized views</description> > <property name ="lib" value ="org.jboss.qe.jdg.pojos"></property> > <model name="jdgSource"> > <source name="jdgSource" translator-name="jdg-override" > connection-jndi-name="java:/jdg-mat-ds" /> > <metadata type="DDL"><![CDATA[ > CREATE FOREIGN TABLE CustomerReport( > customerId integer not null OPTIONS (SEARCHABLE 'Searchable', NATIVE_TYPE 'int'), > totalAmount integer, > CONSTRAINT PK_ID PRIMARY KEY(customerId) > ) OPTIONS (NAMEINSOURCE '${db.table.prefix}jdg-mat', UPDATABLE TRUE);]]> > </metadata> > </model> > <model name="h2Source"> > <source name="h2Source" translator-name="h2" connection-jndi-name="java:/h2-ds" /> > </model> > <model name="View" type="VIRTUAL"> > <metadata type="DDL"><![CDATA[ > CREATE VIEW external_long_ttl ( > customerId integer NOT NULL, > totalAmount integer > ) OPTIONS (MATERIALIZED 'TRUE', > MATERIALIZED_TABLE 'jdgSource.CustomerReport', > "teiid_rel:ALLOW_MATVIEW_MANAGEMENT" 'true', > "teiid_rel:MATVIEW_LOAD_SCRIPT" 'INSERT INTO jdgSource.CustomerReport(customerId,totalAmount) SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id;', > "teiid_rel:MATVIEW_STATUS_TABLE" 'h2Source.DB.PUBLIC.DV_MATVIEWS_STATUSTABLE', > "teiid_rel:MATVIEW_BEFORE_LOAD_SCRIPT" 'execute jdgSource.native(''truncate cache'');', > "teiid_rel:MATVIEW_AFTER_LOAD_SCRIPT" 'execute jdgSource.native(''swap cache names'');', > "teiid_rel:MATVIEW_ONERROR_ACTION" 'WAIT', > "teiid_rel:MATVIEW_TTL" 10000 > ) > AS SELECT c.id AS customerId, CONVERT(SUM(o.amount),integer) AS totalAmount FROM DV_MATVIEWS_CUSTOMERS c INNER JOIN DV_MATVIEWS_ORDERS o ON c.id = o.customer_id GROUP BY c.id; > ]]> > </metadata> > </model> > <translator name="jdg-override" type="infinispan-cache-dsl"> > <property name="SupportsDirectQueryProcedure" value="true" /> > </translator> > </vdb> > {code} > Resource-adapter used: > {code:xml} > <resource-adapter id="jdg-mat"> > <module slot="main" id="org.jboss.teiid.resource-adapter.infinispan.dsl"/> > <connection-definitions> > <connection-definition class-name="org.teiid.resource.adapter.infinispan.dsl.InfinispanManagedConnectionFactory" jndi-name="java:/jdg-mat-ds" enabled="true" pool-name="jdg-mat"> > <config-property name="ProtobufDefinitionFile"> > /org/jboss/qe/jdg/remote/protobuf/CustomerReport.proto > </config-property> > <config-property name="AliasCacheName"> > ${db.table.prefix}jdg-alias > </config-property> > <config-property name="MessageMarshallers"> > org.jboss.qe.jdg.pojo.CustomerReport:org.jboss.qe.jdg.remote.marshaller.CustomerReportMarshaller > </config-property> > <config-property name="RemoteServerList"> > [remote-server-address]:11322 > </config-property> > <config-property name="StagingCacheName"> > ${db.table.prefix}jdg-mat-stage > </config-property> > <config-property name="CacheTypeMap"> > ${db.table.prefix}jdg-mat:org.jboss.qe.jdg.pojo.CustomerReport;customerId > </config-property> > <config-property name="MessageDescriptor"> > org.jboss.qe.jdg.remote.protobuf.CustomerReport > </config-property> > <config-property name="Module"> > org.jboss.qe.jdg.pojos > </config-property> > </connection-definition> > </connection-definitions> > </resource-adapter> > {code} > Datasource used (tables that the view queries): > {code:xml} > <xa-datasource jndi-name="java:/h2-ds" pool-name="h2-xa-ds" enabled="true"> > <xa-datasource-property name="URL"> > jdbc:h2:tcp://localhost:9292/db;TRACE_LEVEL_FILE=4 > </xa-datasource-property> > <driver>h2</driver> > <security> > <user-name>sa</user-name> > </security> > </xa-datasource> > {code} > Query invoked to check current contents of materialized view: > {code:sql} > SELECT COUNT(*) FROM external_long_ttl; > {code} > And expected result is the same as count of DV_MATVIEWS_CUSTOMERS table from source h2Source. In my case 10. > But when I print out the result I get all numbers from 0 to 10 . See attached log output (search for 'check-count:') -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4050) database logging doesn't add command and audit loggers for domain mode

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4050?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4050: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1314716|https://bugzilla.redhat.com/show_bug.cgi?id=1314716] from VERIFIED to CLOSED > database logging doesn't add command and audit loggers for domain mode > ---------------------------------------------------------------------- > > Key: TEIID-4050 > URL: https://issues.jboss.org/browse/TEIID-4050 > Project: Teiid > Issue Type: Bug > Components: Tooling > Affects Versions: 8.12.x > Reporter: Van Halbert > Assignee: Van Halbert > Priority: Critical > Fix For: 9.0, 8.12.x > > > When installing database logging, than no org.teiid.COMMAND_LOG or org.teiid.AUDIT_LOG category loggers are present in domain.xml for ha and full-ha profile. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3879) Error during state transfer prevents a node from loading later

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3879?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3879: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1305570|https://bugzilla.redhat.com/show_bug.cgi?id=1305570] from VERIFIED to CLOSED > Error during state transfer prevents a node from loading later > -------------------------------------------------------------- > > Key: TEIID-3879 > URL: https://issues.jboss.org/browse/TEIID-3879 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.13, 8.12.4 > > > During an initial transfer or a later transfer after invalidation an error will cause the receiving node to just wait for the next load (which could be indefinite) rather than initiating it's own load. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4221) HANA translator: incorrect pushdown of week function

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4221?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4221: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1339568|https://bugzilla.redhat.com/show_bug.cgi?id=1339568] from VERIFIED to CLOSED > HANA translator: incorrect pushdown of week function > ---------------------------------------------------- > > Key: TEIID-4221 > URL: https://issues.jboss.org/browse/TEIID-4221 > Project: Teiid > Issue Type: Bug > Components: Misc. Connectors > Affects Versions: 8.12.5 > Reporter: Jan Stastny > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.5 > > > Hana translator pushes down function week to SAP HANA datasource as its WEEK function. But it is not in accordance with the ISO8601 rule. > For this standard, HANA has function ISOWEEK, which returns results in following format: > {code:plain} > 2000-W01 for date 'Jan 3, 2000' > {code} > So it should be possible to push Teiid's WEEK function as: > {code:sql} > SUBSTR_REGEXPR('[[:digit:]]{4}\-W([[:digit:]]{2})' IN ISOWEEK(datevalue) GROUP 1) > {code} > where 'datevalue' is column of DATE datatype. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 years, 7 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3950) UDFs aren't found when using old function definitions model

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-3950?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-3950: ------------------------------------------------ Filip Elias <felias(a)redhat.com> changed the Status of [bug 1304743|https://bugzilla.redhat.com/show_bug.cgi?id=1304743] from VERIFIED to CLOSED > UDFs aren't found when using old function definitions model > ----------------------------------------------------------- > > Key: TEIID-3950 > URL: https://issues.jboss.org/browse/TEIID-3950 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.7.2.6_2 > Reporter: Debbie Steigner > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.1, 8.7.3.6_2 > > > When migrating an old VDB that contains the old functiondefinitions model the server sees it as a Function model[1] but the functions are not found [2]when you try to use them. > [1] [org.teiid.RUNTIME] (MSC service thread 1-7) Model udfTokenFunctions in VDB oldUDF skipped being loaded because of its type FUNCTION > [2] [org.teiid.PROCESSOR] (Worker0_QueryProcessorQueue10) org.teiid.api.exception.query.QueryResolverException: TEIID30068 The function 'getToken('125421', '?', 2)' is an unknown form. Check that the function name and number of arguments is correct. Sending error to client 1trCiU5AkzFn.5 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

9 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 2016