August 2016 - teiid-issues - Jboss List Archives

[JBoss JIRA] (TEIID-3795) Order of VARIADIC parameters is not preserved

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3795?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-3795: ---------------------------------- > Order of VARIADIC parameters is not preserved > --------------------------------------------- > > Key: TEIID-3795 > URL: https://issues.jboss.org/browse/TEIID-3795 > Project: Teiid > Issue Type: Bug > Reporter: Salvatore R > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > It seems that the order of VARIADIC arguments passed to a stored procedure is not always preserved. > For example, I defined a procedure in a virtual model in the VDB as follows: > {code:sql} > <model visible = "true" type = "VIRTUAL" name = "test_variadic"> > <metadata type = "DDL"><![CDATA[ > CREATE PROCEDURE p1(VARIADIC parameters string) > AS BEGIN > declare integer i = 1; > WHILE(i <= array_length(parameters)) > BEGIN > exec "SYSADMIN.logMsg"("level" => 'INFO', "context" => 'test', "msg" => 'param '|| parameters[i]); > i = i + 1; > END > END; > ]]> > </metadata> > </model> > {code} > The procedure just prints to the console the passed arguments. > When I call the procedure: > {code:sql} > exec "test_variadic.p1"('1' , '2', '3' , '4', '5' , '6', '7' , '8', '9' , '10', '11' , '12', '13' , '14', '15' , '16', '17' , '18', '19' , '20') > {code} > only the first 15 parameters are printed in the same order as they are passed, as shown in the log below: > {code} > 22:44:26,117 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 1 > 22:44:26,118 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 2 > 22:44:26,119 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 3 > 22:44:26,122 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 4 > 22:44:26,123 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 5 > 22:44:26,125 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 6 > 22:44:26,127 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 7 > 22:44:26,130 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 8 > 22:44:26,132 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 9 > 22:44:26,134 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 10 > 22:44:26,138 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 11 > 22:44:26,138 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 12 > 22:44:26,140 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 13 > 22:44:26,143 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 14 > 22:44:26,144 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 15 > 22:44:26,147 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 17 > 22:44:26,149 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 16 > 22:44:26,151 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 19 > 22:44:26,153 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 18 > 22:44:26,156 INFO [test] (Worker2_QueryProcessorQueue21) AbdPCQQAsiSL param 20 > {code} -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2921) Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2921?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-2921: --------------------------------- Fix Version/s: 8.7.9.6_2 > Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions > -------------------------------------------------------------------------------------------------- > > Key: TEIID-2921 > URL: https://issues.jboss.org/browse/TEIID-2921 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.8 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 7.7.10, 8.8, 8.7.9.6_2 > > > Current logic is written to only support simple ordering expressions. User desires the ability to use non-simple Order By statements (for example: including a case statement) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2921) Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2921?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-2921. -------------------------------- Resolution: Done > Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions > -------------------------------------------------------------------------------------------------- > > Key: TEIID-2921 > URL: https://issues.jboss.org/browse/TEIID-2921 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.8 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 8.7.9.6_2, 8.8, 7.7.10 > > > Current logic is written to only support simple ordering expressions. User desires the ability to use non-simple Order By statements (for example: including a case statement) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-2921) Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-2921?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-2921: ---------------------------------- > Allow the projection raising (or order pushing) logic to work with non-simple ordering expressions > -------------------------------------------------------------------------------------------------- > > Key: TEIID-2921 > URL: https://issues.jboss.org/browse/TEIID-2921 > Project: Teiid > Issue Type: Feature Request > Components: Query Engine > Affects Versions: 7.7.8 > Reporter: Johnathon Lee > Assignee: Steven Hawkins > Fix For: 7.7.10, 8.8 > > > Current logic is written to only support simple ordering expressions. User desires the ability to use non-simple Order By statements (for example: including a case statement) -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3807) quantified comparison results dependent on null ordering

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3807?page=com.atlassian.jira.plugin... ] Johnathon Lee reopened TEIID-3807: ---------------------------------- > quantified comparison results dependent on null ordering > -------------------------------------------------------- > > Key: TEIID-3807 > URL: https://issues.jboss.org/browse/TEIID-3807 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13 > > > The handling of null and it's affect on the result is dependent upon it's position in the the subquery result. > Specifically if null occurs before something that would otherwise evaluate to true for an all comparison the result will be true and not the expected null. Or if null occurs before something that would be otherwise false in a some comparison, then false will be returned rather than the expected null. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3807) quantified comparison results dependent on null ordering

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3807?page=com.atlassian.jira.plugin... ] Johnathon Lee updated TEIID-3807: --------------------------------- Fix Version/s: 8.7.9.6_2 > quantified comparison results dependent on null ordering > -------------------------------------------------------- > > Key: TEIID-3807 > URL: https://issues.jboss.org/browse/TEIID-3807 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.12.2, 8.13, 8.7.9.6_2 > > > The handling of null and it's affect on the result is dependent upon it's position in the the subquery result. > Specifically if null occurs before something that would otherwise evaluate to true for an all comparison the result will be true and not the expected null. Or if null occurs before something that would be otherwise false in a some comparison, then false will be returned rather than the expected null. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-3807) quantified comparison results dependent on null ordering

by Johnathon Lee (JIRA)

[ https://issues.jboss.org/browse/TEIID-3807?page=com.atlassian.jira.plugin... ] Johnathon Lee closed TEIID-3807. -------------------------------- Resolution: Done > quantified comparison results dependent on null ordering > -------------------------------------------------------- > > Key: TEIID-3807 > URL: https://issues.jboss.org/browse/TEIID-3807 > Project: Teiid > Issue Type: Bug > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 8.7.9.6_2, 8.13, 8.12.2 > > > The handling of null and it's affect on the result is dependent upon it's position in the the subquery result. > Specifically if null occurs before something that would otherwise evaluate to true for an all comparison the result will be true and not the expected null. Or if null occurs before something that would be otherwise false in a some comparison, then false will be returned rather than the expected null. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4419) Allow pre-evaluation of uncorrelated scalar subqueries in more circumstances

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4419?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4419. ----------------------------------- Fix Version/s: 9.1 Resolution: Done Added logic to detect uncorrelated scalar subqueries against common tables and mark them as needing to be pre-evaluated which mimics older planning behavior. > Allow pre-evaluation of uncorrelated scalar subqueries in more circumstances > ---------------------------------------------------------------------------- > > Key: TEIID-4419 > URL: https://issues.jboss.org/browse/TEIID-4419 > Project: Teiid > Issue Type: Enhancement > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > In some instances it is better to pre-evaluate uncorrelated scalar subqueries rather than pushing down. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4420) AccessNode should display subplans in plan

by Steven Hawkins (JIRA)

[ https://issues.jboss.org/browse/TEIID-4420?page=com.atlassian.jira.plugin... ] Steven Hawkins resolved TEIID-4420. ----------------------------------- Resolution: Done Added subplans to the Query if they exist. > AccessNode should display subplans in plan > ------------------------------------------ > > Key: TEIID-4420 > URL: https://issues.jboss.org/browse/TEIID-4420 > Project: Teiid > Issue Type: Quality Risk > Components: Query Engine > Reporter: Steven Hawkins > Assignee: Steven Hawkins > Fix For: 9.1 > > > The plan description for AccessNodes does not include any of the evaluatable subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

[JBoss JIRA] (TEIID-4420) AccessNode should display subplans in plan

by Steven Hawkins (JIRA)

Steven Hawkins created TEIID-4420: ------------------------------------- Summary: AccessNode should display subplans in plan Key: TEIID-4420 URL: https://issues.jboss.org/browse/TEIID-4420 Project: Teiid Issue Type: Quality Risk Components: Query Engine Reporter: Steven Hawkins Assignee: Steven Hawkins Fix For: 9.1 The plan description for AccessNodes does not include any of the evaluatable subqueries. -- This message was sent by Atlassian JIRA (v6.4.11#64026)

7 years, 8 months

1
0
0 / 0

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

teiid-issues August 2016