[TRAFODION-3288] trafci queries with multiple param return an 'invalid desc index' error

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: client-ci
• Assignee: Anoop Sharma
• Reporter: Arvind Narain
• Created: 19/Mar/19 17:55
• Updated: 19/Mar/19 17:55

Description

In the following example, executing the prepared query q6 using params ?p0 and ?p1 returns a 29007 error complaining about invalid descriptor index. This only occurs in trafci. The same error is not seen in sqlci.

 

Seen after the following fix went in:

https://github.com/apache/trafodion/pull/1803

TRAFODION-3157 Add support for BINARY/VARBINARY datatype

 

From trafci:

SQL>drop schema if exists trafodion.mytest cascade;

— SQL operation complete.

SQL>create schema if not exists trafodion.mytest;

— SQL operation complete.

SQL>set schema trafodion.mytest;

— SQL operation complete.

SQL>create table a5table1
+>( ref_num largeint
+>, z_text char(3)
+>, emp_num smallint
+>);

— SQL operation complete.

SQL>insert into a5table1 values (100,'abc',99), (100,'abd',99);

— 2 row(s) inserted.

SQL>set param ?p0 100;

SQL>set param ?p1 200;

SQL>prepare q6 from
+>select * from a5table1
+>where (ref_num, z_text, emp_num) between (?p0,'abd',?p0)
+>and (?p1,'abd',?p1) ;

— SQL command prepared.

SQL>execute q6;

• • • ERROR[29007] Invalid descriptor index