June 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-4259) "TEIID30259 Cannot introduce new expressions" when using formattimestamp

by Bram Gadeyne (JIRA)

[ https://issues.jboss.org/browse/TEIID-4259?page=com.atlassian.jira.plugin... ] Bram Gadeyne commented on TEIID-4259: ------------------------------------- I can confirm that this is resolved in 9.0.0 > "TEIID30259 Cannot introduce new expressions" when using formattimestamp > ------------------------------------------------------------------------ > > Key: TEIID-4259 > URL: https://issues.jboss.org/browse/TEIID-4259 > Project: Teiid > Issue Type: Bug > Affects Versions: 8.11.3 > Reporter: Bram Gadeyne > Assignee: Steven Hawkins > > A certain query executes fine when using the normal timestamp column (w.valuetime). When this is changed to formattimestamp(w.valuetime, 'dd/MM/yyyy HH:mm') we get an exception complaining about a case statement that is part of the select a few columns after the particular valuetime column. > 14:00:00,055 WARN [org.teiid.PROCESSOR] (Worker17615_QueryProcessorQueue95374) 7OLMH/JCvk3W TEIID30020 Processing exception for request 7OLMH/JCvk3W.48 'TEIID30259 Cannot introduce new expressions [CASE WHEN convert(anon_grp2.agg2, date) = convert(timestampadd(SQL_TSI_DAY, -1, convert(convert(now(), date), timestamp)), date) THEN 'Gisteren' ELSE CASE WHEN convert(anon_grp2.agg2, date) = convert(now(), date) THEN 'Vannacht' ELSE '' END END, CASE WHEN anon_grp2.agg3 IS NULL THEN 'Niet gemeten' ELSE 'OK' END, CASE WHEN anon_grp2.agg4 > 0 THEN 'OK' ELSE 'Ontbreekt' END] in duplicate removal.'. Originally QueryPlannerException RuleAssignOutputElements.java:407. Enable more detailed logging to see the entire stacktrace. > This was the query that caused the problem: > select w.patientid as Patientid, > formattimestamp(w.valuetime,'yyyy-MM-dd HH:mm') as t2, > w.valuetime as Tijdstip, > max(w.bed) as Bed, max(w.Naam) as Naam, > case when convert(max(w.opname), date) = timestampadd(SQL_TSI_DAY, -1, convert(now() , date)) then 'Gisteren' > else > case when convert(max(w.opname), date) = convert(now(), date) then 'Vannacht' else > '' end end as Opname, > case when count(w.MondZorgAantal) is null then 'Niet gemeten' else 'OK' end as Comfort, > case when count(w.EvaluatieMond) > 0 then 'OK' else 'Ontbreekt' end as NRS > from > ( > select pi.patientid as Patientid, null as ValueTime, pi.bedabbr as Bed, concat(pi.PatientLastName, concat(', ',pi.PatientFirstName)) as Naam, pi.AdmTime as opname, null as MondZorgAantal, null as EvaluatieMond, patientStatusID > from prod_PV_PatientInfo pi > where pi.PatientStatusID = 1 and PatGroupAbbr like 'PICU%' and cast(pi.admTime as date) <> cast(now() as date) > union > select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname, > v.c as MondZorgAantal, null as EvaluatieMond, v.PatientStatusID from > (select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID > from prod_PV_DerivedVariables obs1 > join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) <> cast(now() as date) and PatGroupAbbr like 'PICU%' > where obs1.variableid = 30010003 > and cast(valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date)) > group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v > union > select v.PatientID as Patientid, v.ValueTime, null as Bed, null as Naam, null as opname, null as MondZorgAantal, v.c as EvaluatieMond, v.PatientStatusID from > (select obs1.PatientID, obs1.ValueTime, count(*) as c , pi.PatientStatusID > from prod_PV_ObservationVariables obs1 > join prod_PV_PatientInfo pi on pi.PatientID = obs1.PatientID and pi.PatientStatusID = 1 and cast(pi.admTime as date) < cast(now() as date) and PatGroupAbbr like 'PICU%' > where obs1.variableid = 15005534 > and cast(obs1.valuetime as date) = timestampadd(SQL_TSI_DAY, -1, cast(now() as date)) > group by obs1.patientid, obs1.ValueTime, timestampadd(SQL_TSI_DAY, -1, cast(now() as date)), pi.PatientStatusID)v > ) w > group by w.patientid, w.ValueTime > order by max(w.bed) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3960) Otherwise evaluatable constructs will inhibit pushdown

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-3960?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-3960. --------------------------------- > Otherwise evaluatable constructs will inhibit pushdown > ------------------------------------------------------ > > Key: TEIID-3960 > URL: https://issues.jboss.org/browse/TEIID-3960 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.7.2.6_2 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 9.0, 8.12.5, 8.13.1, 8.7.3.6_2 > > > TEIID-1522 introduced a corner case regression such that a constant projection was inlined (removing the need for a fake dependent join), but the resulting expressions were not seen as able to be pushded due to a curdate function preventing the pre-evaluation of non-pushable constructs. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4125) Problem with SOAP war generated in TD

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4125?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4125. --------------------------------- > Problem with SOAP war generated in TD > ------------------------------------- > > Key: TEIID-4125 > URL: https://issues.jboss.org/browse/TEIID-4125 > Project: Teiid > Issue Type: Bug > Components: Server > Affects Versions: 8.12.5 > Reporter: Matus Makovy > Assignee: Van Halbert > Priority: Critical > Fix For: 9.0, 8.12.5 > > Attachments: ProductInfoVdb.war, Untitled.zip > > > I don't know if this is a Teiid or Teiid Designer issue. > When I generate a SOAP war from VDB and try to deploy it to server, I get following exception: > {code} > Deployment failed: ProductInfoVdb.war: {"outcome" : "failed", "failure-description" : {"JBAS014671: Failed services" : {"jboss.deployment.unit.\"ProductInfoVdb.war\".INSTALL" : "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"ProductInfoVdb.war\".INSTALL: JBAS018733: Failed to process phase INSTALL of deployment \"ProductInfoVdb.war\"\n Caused by: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory\n Caused by: java.lang.ClassNotFoundException: org.apache.commons.logging.LogFactory from [Module \"org.springframework.spring:main\" from local module loader @ed17bee (finder: local module finder @2a33fae0 (roots: /Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/dv,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/base/.overlays/layer-base-jboss-eap-6.4.3.CP,/Users/mmakovy/server-installer/dv-6.3.0.DR3/target/jboss-eap-6.4/modules/system/layers/base))]"}}, "rolled-back" : true} > {code} > The whole "test script" should be accessible here: https://mojo.redhat.com/docs/DOC-995324 > This happens *only with DV-6.3.0.DR3*. When I deploy this war to DV 6.2 server, everything works as expected. > I attached project in zip file (Untitled.zip) and generated WAR. The WAR file was generated in TD 10.0.0.Beta2, but I tried to generate the war in 9.0.5 Designer and the result was the same. > I marked this as Critical, but if it is a Designer issue I think it should be marked as blocker. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4110) Odata - date functions does't accept date string as a parameter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4110?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4110. --------------------------------- > Odata - date functions does't accept date string as a parameter > --------------------------------------------------------------- > > Key: TEIID-4110 > URL: https://issues.jboss.org/browse/TEIID-4110 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Date functions year, month, day, hour, minute and second doesn't accept date string(DateTimeOffset) as a parameter. > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=m... eq EmployeeID > *Result:* Employee with ID 1 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter... eq intkey > *Result:* {"error": {"code": null, "message": "TEIID30069 The function 'MONTH(?)' has more than one possible signature." }} > *Expected result:* Entity with intkey 1 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4103) OData - wrong string indexing in string functions indexof and substring

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4103?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4103. --------------------------------- > OData - wrong string indexing in string functions indexof and substring > ------------------------------------------------------------------------ > > Key: TEIID-4103 > URL: https://issues.jboss.org/browse/TEIID-4103 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > By documentation \[1\] function indexof returns the zero-based character position of the first occurrence of the second parameter value in the first parameter value. > Function substring doens't have explicitly specified indexing, but based on _Example 60_ \[2\] is function substring _zero-based_ too. > *indexof* > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter...,'alue') eq 1 > *Result:* No entities > *Expected result:* Entity with intkey 1,2,3,4,8,9,10,11,12 > *substring* > Reference service which supports OData V4: > *URL:* http://services.odata.org/V4/Northwind/Northwind.svc/Customers/?$filter=i...,'lfreds') eq 1 > *Result:* Customer with CompanyName equals "Alfreds Futterkiste" > *ULR:* http://localhost:8080/odata4/olingo_basic/Source/SimpleDataTable/?$filter..., 1) eq 'alue_asdf' > *Result:* No entities > *Expected result:* Entity with intkey 10 > \[1\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... > \[2\] https://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-u... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4085) OData doesn't support mulitiple usage of arithmetic operators

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4085?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4085. --------------------------------- > OData doesn't support mulitiple usage of arithmetic operators > -------------------------------------------------------------- > > Key: TEIID-4085 > URL: https://issues.jboss.org/browse/TEIID-4085 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > Cannot use more than one arithmetic operator in single OData query. Each arithmetic operator has same problem: add,sub,mul,div and mod. > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null,"message": "TEIID30067 Type was null for (? + ?) in function ((? + ?) + ?)"}} > *Expected result:* Entity with intkey 7 > See: [\[OData-ABNF\]|http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/abnf/odata-abnf-construction-rules.txt] _Line:_ 384 and 561 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4087) OData - Math function round doesn't accept decimal number as parameter

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4087?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4087. --------------------------------- > OData - Math function round doesn't accept decimal number as parameter > ---------------------------------------------------------------------- > > Key: TEIID-4087 > URL: https://issues.jboss.org/browse/TEIID-4087 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Labels: Alpha3 > Fix For: 9.0, 8.12.5 > > > Reference service which supports OData V4: > *ULR:* http://services.odata.org/V4/Northwind/Northwind.svc/Employees/?$filter=E... > *Result:* Employee with ID 4 > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error": {"code": null, "message": "TEIID30558 Error converting parameter number 1 with value \"4,2\" of class java.math.BigDecimal to expected type integer." }} > *Expected result:* Entity with intkey 4 -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4082) OData - null literal is not supported

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4082?page=com.atlassian.jira.plugin... ] Steven Hawkins closed TEIID-4082. --------------------------------- > OData - null literal is not supported > ------------------------------------- > > Key: TEIID-4082 > URL: https://issues.jboss.org/browse/TEIID-4082 > Project: Teiid > Issue Type: Sub-task > Components: OData > Reporter: Michal Sanitrak > Assignee: Ramesh Reddy > Fix For: 9.0, 8.12.5 > > > *URL:* http://localhost:8080/odata4/olingo_basic/Source/SimpleTableView/?$filter... > *Actual result:* {"error":{"code": null,"message": "OData Library: An exception without message text was thrown."}} > *Expected result:* Return all entities where stringval equals _null_ > See: http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part1-pr... > http://docs.oasis-open.org/odata/odata/v4.0/errata02/os/complete/part2-ur... -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4237) INNER JOIN returns incorrect results

by RH Bugzilla Integration (JIRA)

[ https://issues.jboss.org/browse/TEIID-4237?page=com.atlassian.jira.plugin... ] RH Bugzilla Integration commented on TEIID-4237: ------------------------------------------------ Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug 1341763|https://bugzilla.redhat.com/show_bug.cgi?id=1341763] from NEW to MODIFIED > INNER JOIN returns incorrect results > ------------------------------------ > > Key: TEIID-4237 > URL: https://issues.jboss.org/browse/TEIID-4237 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Affects Versions: 8.12 > Environment: teiid-8.12-Beta1 on Red Hat JBoss Enterprise Application Platform - Version 6.3.0.GA > Reporter: dalex dalex > Assignee: Steven Hawkins > Priority: Blocker > Fix For: 9.0, 8.7.6, 8.12.5, 8.7.7.6_2, 8.13.5 > > > Running the following query: > {code:sql} > select avg(t1.a) from > (select 3 as a, 3 as b union all > select 1 as a, 1 as b union all > select 3 as a, 3 as b) as t1 > join (select 1 as a, 1 as b union all > select 1 as a, 1 as b union all > select 2 as a, 2 as b union all > select 2 as a, 2 as b union all > select 3 as a, 3 as b union all > select 3 as a, 3 as b) as t2 on t1.a=t2.a > {code} > on teiid causes incorrect result: 2 in comparing with mysql which returns 2.333. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3617) Provide an option to Limit per user based connections

by Van Halbert (JIRA)

[ https://issues.jboss.org/browse/TEIID-3617?page=com.atlassian.jira.plugin... ] Van Halbert commented on TEIID-3617: ------------------------------------ This feature will need a web-console enhancement too. > Provide an option to Limit per user based connections > ----------------------------------------------------- > > Key: TEIID-3617 > URL: https://issues.jboss.org/browse/TEIID-3617 > Project: Teiid > Issue Type: Feature Request > Components: Server > Reporter: Xian Liu > Assignee: Kylin Soong > Fix For: 9.1 > > > we deploy teiid for users to get data, but some users will create many connections to teiid and they are not necessary, I need to find a good way to limit each user account can only get like 50 connections or so -- This message was sent by Atlassian JIRA (v6.4.11#64026)

8 years, 3 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues June 2016