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

["Arvind Narain (JIRA)" <ji...@apache.org>]

Arvind Narain created TRAFODION-3288:
----------------------------------------

             Summary: trafci queries with multiple param return an 'invalid desc index' error
                 Key: TRAFODION-3288
                 URL: https://issues.apache.org/jira/browse/TRAFODION-3288
             Project: Apache Trafodion
          Issue Type: Bug
          Components: client-ci
            Reporter: Arvind Narain
            Assignee: Anoop Sharma


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



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)