Querytool Beta 20.1.537 / itgenclr009 / Loop statement broken on the Invantive interpreter

Questions
1

Good morning,
it seems that something is broken in Querytool Beta 20.1.537.
a simple loop statement like

declare
     l_test integer := 0;
begin
      for i in 1..10 loop
      l_test := l_test + 1;
      end loop;
end;

will end with a itgenclr009 error.

I don’t see the issue with .529, that means there is a tweak inserted in between .529 and .537

Also it seems impossible to roll-back for downloading previous versions like .529 (I have a machine where only .537 is installed, I wanted to install .529).
May be you should keep links of previous version somewhere ?

Thanks

https://download.invantive.com/current/Invantive%20Query%20Tool-current.msi

Capture d’écran 2021-09-15 à 12.23.55
Capture d’écran 2021-09-15 à 12.23.551692×595 115 KB

itgenclr009: Nombre incorrect d’arguments fournis pour l’appel de la méthode ‘System.Object GetVariableValue(Invantive.Basics.GlobalState, Invantive.Basics.ExecutionOptions, Invantive.Data.ISparseArray, Int32, System.String, System.String)’.Bericht ID: 4d114e32-d536-4f92-a7b6-ad44edd737bfOpgetreden (UTC): 15/09/2021 10:13:08
declare l_test integer := 0;begin for i in 1…10 loop l_test := l_test + 1; end loop;end;System.ArgumentException à System.Linq.Expressions.Expression.ValidateArgumentCount(MethodBase method, ExpressionType nodeKind, Int32 count, ParameterInfo pis) à System.Linq.Expressions.Expression.ValidateArgumentTypes(MethodBase method, ExpressionType nodeKind, ReadOnlyCollection1& arguments) à System.Linq.Expressions.Expression.Call(Expression instance, MethodInfo method, IEnumerable1 arguments) à System.Linq.Expressions.Expression.Call(MethodInfo method, Expression arguments) à Invantive.Sql.PSqlVariable…ctor(GlobalState owner, ExecutionOptions executionOptions, IProviderManager manager, Int32 index, String name, String dotnetDataType, String databaseDataType, Type type) à Invantive.Sql.V1.PSqlScope.AddVariable(GlobalState owner, ExecutionOptions executionOptions, String name, String dotnetDataType, String databaseDataType, Type type) à Invantive.Sql.V1.PSqlParser.AddVariable(GlobalState owner, ExecutionOptions executionOptions, ParserRuleContext ctx, PSqlScope scope, String name, String dotnetDataType, String databaseDataType, Type type) à Invantive.Sql.V1.PSqlParser.ParsePSqlBlock(GlobalState owner, ExecutionOptions executionOptions, PSqlDeclareSectionContext declareSection, PSqlBodyNoBatchSeparatorContext body, PSqlScope parentScope, HM queryPlanState) à Invantive.Sql.V1.PSqlStatementTree.OnExecute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, ExpressionParser expressionParser) à Invantive.Sql.V1.QueryTree.Execute(GlobalState owner, ExecutionOptions executionOptions, ParameterList parameters, ExpressionParser expressionParser) à Invantive.Sql.V1.QueryPlan.ForcePlan(GlobalState owner, ExecutionOptions executionOptions) à Invantive.Sql.V1.QueryPlan.Fetch(GlobalState owner, ExecutionOptions executionOptions, ObjectDefinition objectDefinition, String sqlStatement) à Invantive.Data.ConnectionManager.UG.H(QueryPlan ) à System.Linq.Enumerable.WhereSelectArrayIterator2.MoveNext() à System.Linq.Buffer1…ctor(IEnumerable1 source) à System.Linq.Enumerable.ToArray[TSource](IEnumerable1 source) à Invantive.Data.ConnectionManager.ExecuteAndCombineQueryPlansV1(GlobalState owner, ExecutionOptions executionOptions, QueryPlan queryPlans, String sqlStatement, ParameterList parameters) à Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)— Fin de la trace de la pile à partir de l’emplacement précédent au niveau duquel l’exception a été levée — à System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() à Invantive.Data.ConnectionManager.ExecuteProviderPassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule) à Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule)— Fin de la trace de la pile à partir de l’emplacement précédent au niveau duquel l’exception a été levée — à System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() à Invantive.Data.ConnectionManager.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters, String callSafeNameOverrule) à Invantive.Data.ActionProceduresBase.PassthroughSqlActionTable(GlobalState owner, ExecutionOptions executionOptions, String actionSql, ParameterList parameters) à Invantive.Producer.Windows.Forms.QueryToolResults.LEQ(GlobalState , ExecutionOptions , IProgressNotifier , String , ParameterList , Boolean , Boolean , Boolean , Boolean ) dans C:\Users\gle3.WS212\Documents\ws-master\Invantive.Producer\src\Invantive.Producer.Windows.Forms\QueryTool\QueryToolTraceViewModel.cs:ligne 17 à Invantive.Producer.Windows.Forms.QueryToolResults.EEQ(GlobalState , ExecutionOptions , String , ParameterList ) dans C:\Users\gle3.WS212\Documents\ws-master\Invantive.Producer\src\Invantive.Producer.Windows.Forms\QueryTool\QueryToolDbmsOutputViewModel.cs:ligne 126

2

Update:
the issue does not appear with PROD 20.2.27.

Stephane