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)