Verified on the v0110 build installed on a cluster.  This problem is now fixed:

>>cqd hybrid_query_cache 'off';

--- SQL operation complete.
>> drop schema myschema cascade;

*** ERROR[1003] Schema TRAFODION.MYSCHEMA does not exist.

--- SQL operation failed with errors.
>> create schema myschema;

--- SQL operation complete.
>> set schema myschema;

--- SQL operation complete.
>>
>>Create Table BTA1P006
+> (
+> sbin0_4 Integer not null,
+> varchar0_uniq VarChar(8) not null,
+> sdec0_100 Numeric(9,0) not null,
+> sdec1_20 Numeric(5,0) not null,
+> udec1_nuniq Numeric(4,0) unsigned,
+>
+>char2_2 Char(2) not null,
+> sbin2_nuniq Largeint ,
+> sdec2_500 Numeric(9,0) signed not null,
+> udec3_n100 Numeric(9,0) unsigned,
+> ubin3_n2000 Numeric(4,0) unsigned,
+> char3_4 Char(8) not null,
+>
+>sdec4_n20 Numeric(4,0) ,
+> sbin4_n1000 Smallint ,
+> char4_n10 Char(8) ,
+> char5_n20 Char(8) ,
+> sdec5_10 Numeric(9,0) signed not null,
+> ubin5_n500 Numeric(9,0) unsigned ,
+>
+>sbin6_nuniq Largeint ,
+> sdec6_4 Numeric(4,0) signed not null,
+> char6_n100 Char(8) ,
+> sbin7_n20 Smallint ,
+> char7_500 Char(8) not null,
+> udec7_n10 Numeric(4,0) unsigned,
+>
+>ubin8_10 Numeric(4,0) unsigned not null,
+> char8_n1000 Char(8) ,
+> sdec8_4 Numeric(9,0) unsigned not null,
+> sdec9_uniq Numeric(18,0) signed not null,
+> char9_100 Char(2) not null,
+>
+>char10_nuniq Char(8) ,
+> udec10_uniq Numeric(9,0) unsigned not null,
+> udec11_2000 Numeric(9,0) unsigned not null,
+> sbin11_100 Integer not null,
+> char11_uniq Char(8) not null,
+>
+>ubin12_2 Numeric(4,0) unsigned not null,
+> sdec12_n1000 Numeric(18,0) signed ,
+> char12_n2000 Char(8) ,
+> udec13_500 Numeric(9,0) unsigned not null,
+>
+>char13_1000 Char(8) not null,
+>
+>sbin14_1000 Integer not null,
+> udec14_100 Numeric(4,0) unsigned not null,
+> char14_n500 Char(8) ,
+> sbinneg15_nuniq Largeint ,
+> sdecneg15_100 Numeric(9,0) signed not null,
+> char15_100 VarChar(8) not null,
+>
+>ubin16_n10 Numeric(4,0) unsigned ,
+> sdec16_uniq Numeric(18,0) signed not null,
+> char16_n20 Char(5) ,
+> sbin17_uniq Largeint not null,
+> sdec17_nuniq Numeric(18,0) ,
+> char17_2 VarChar(7) not null
+>
+>, primary key ( sdec9_uniq ASC
+> , sdec0_100 DESC
+> , sdec1_20 ASC )
+> );

--- SQL operation complete.
>>
>>Insert Into BTA1P006
+> Values (
+> -0, 'CJAAAAAC', -81, -2, 1973,
+> 'AA', -702, -202, 81, 81, 'BAAAAAAA',
+> -4, -724, NULL , 'BDAAAAAA', -3, 473, -- (5)
+> -702, -2, 'CCAAAAAA', -1, 'ABAAEAAA', NULL ,
+> 4, 'GFAAFAAA', 0, -201, 'BX',
+> 'CJAAAAAC', 702, 81, -81, 'AAAAMAAB', -- (10)
+> 0, -724, 'GFAAFAAA', 473, 'GEAAKAAA',
+> -702, 2, 'CGAAAAAA', -4081, -81, 'BGAAAAAA', -- (15)
+> NULL , -4724, 'AEAA', -76757, -1973, 'BAAA'
+> ),(
+> -1, 'AEAAJAAB', -44, -6, 60,
+> 'AA', -3766, -266, 44, 344, 'AAAAAAAA',
+> -9, -509, NULL , 'AAAAAAAA', -0, 60, -- (5)
+> -3766, -2, 'CQAAAAAA', -4, 'EAAAGAAA', NULL ,
+> 9, 'DBAAAAAA', 1, -200, 'AK',
+> 'AEAAJAAB', 3766, 344, -44, 'EKAACAAE', -- (10)
+> 1, -509, 'DBAAAAAB', 60, 'EFAAIAAA',
+> -766, 66, 'AGAAEAAA', -4344, -44, 'ATAAAAA', -- (15)
+> NULL , -2509, 'BE ', -37055, -60, 'AAAA'
+> ),(
+> -2, 'CCAAFAAC', -52, -12, 2086,
+> 'AA', -772, -272, 52, 1552, 'AAAAAAAA',
+> -18, -678, NULL , 'CBAAAAAA', -6, 86, -- (5)
+> -772, -0, 'AWAAAAAA', -12, 'DAAAGAAA', NULL ,
+> 8, 'DEAAMAAA', 2, -101, 'CL',
+> 'CCAAFAAC', 772, 1552, -52, 'DKAADAAC', -- (10)
+> 0, -678, 'DEAAMAAA', 86, 'AHAAGAAA',
+> -772, 72, 'CEAAHAAA', -3552, -52, 'ACAAAAAA', -- (15)
+> NULL , -3678, 'AB', -49700, -2086, 'AAAAAA'
+> ),(
+> -2, 'AIAALAAA', -89, -5, 812,
+> 'BA', -2065, -65, 89, 389, 'BAAAAAAA',
+> -14, -594, NULL , 'ACAAAAAA', -2, 312, -- (5)
+> -2065, -1, 'BPAAAAAA', -9, 'CFAAEAAA', NULL ,
+> 4, 'FKAAIAAA', 2, -100, 'AM',
+> 'AIAALAAA', 2065, 389, -89, 'CCAAKAAE', -- (10)
+> 0, -594, 'FKAAIAAA', 312, 'AJAAGAAA',
+> -65, 65, 'ABAAEAAA', -2389, -89, 'BOAAAAA',
+> NULL , -1594, 'AA', -15935, -812, 'AAAAAAA' -- (15)
+> )
+> ;

--- 4 row(s) inserted.
>>
>>select t.varchar0_uniq as t_varchar0_uniq
+> , t.char2_2 as t_char2_2
+> , t.char3_4 as t_char3_4
+> , u.varchar0_uniq as u_varchar0_uniq
+> , u.char2_2 as u_char2_2
+> from BTA1P006 t, BTA1P006 u
+> where (t.char2_2, 'AA', t.char3_4 ,'CJAAAAAC')
+> =('AA' ,u.char2_2 , 'AAAAAAAA' , u.varchar0_uniq)
+> order by 1, 2
+> ;

T_VARCHAR0_UNIQ  T_CHAR2_2  T_CHAR3_4  U_VARCHAR0_UNIQ  U_CHAR2_2
---------------  ---------  ---------  ---------------  ---------

AEAAJAAB         AA         AAAAAAAA   CJAAAAAC         AA
CCAAFAAC         AA         AAAAAAAA   CJAAAAAC         AA

--- 2 row(s) selected.
>>
>>cqd hybrid_query_cache 'on';

--- SQL operation complete.
>> drop schema myschema cascade;

--- SQL operation complete.
>> create schema myschema;

--- SQL operation complete.
>> set schema myschema;

--- SQL operation complete.
>>
>>Create Table BTA1P006
+> (
+> sbin0_4 Integer not null,
+> varchar0_uniq VarChar(8) not null,
+> sdec0_100 Numeric(9,0) not null,
+> sdec1_20 Numeric(5,0) not null,
+> udec1_nuniq Numeric(4,0) unsigned,
+>
+>char2_2 Char(2) not null,
+> sbin2_nuniq Largeint ,
+> sdec2_500 Numeric(9,0) signed not null,
+> udec3_n100 Numeric(9,0) unsigned,
+> ubin3_n2000 Numeric(4,0) unsigned,
+> char3_4 Char(8) not null,
+>
+>sdec4_n20 Numeric(4,0) ,
+> sbin4_n1000 Smallint ,
+> char4_n10 Char(8) ,
+> char5_n20 Char(8) ,
+> sdec5_10 Numeric(9,0) signed not null,
+> ubin5_n500 Numeric(9,0) unsigned ,
+>
+>sbin6_nuniq Largeint ,
+> sdec6_4 Numeric(4,0) signed not null,
+> char6_n100 Char(8) ,
+> sbin7_n20 Smallint ,
+> char7_500 Char(8) not null,
+> udec7_n10 Numeric(4,0) unsigned,
+>
+>ubin8_10 Numeric(4,0) unsigned not null,
+> char8_n1000 Char(8) ,
+> sdec8_4 Numeric(9,0) unsigned not null,
+> sdec9_uniq Numeric(18,0) signed not null,
+> char9_100 Char(2) not null,
+>
+>char10_nuniq Char(8) ,
+> udec10_uniq Numeric(9,0) unsigned not null,
+> udec11_2000 Numeric(9,0) unsigned not null,
+> sbin11_100 Integer not null,
+> char11_uniq Char(8) not null,
+>
+>ubin12_2 Numeric(4,0) unsigned not null,
+> sdec12_n1000 Numeric(18,0) signed ,
+> char12_n2000 Char(8) ,
+> udec13_500 Numeric(9,0) unsigned not null,
+>
+>char13_1000 Char(8) not null,
+>
+>sbin14_1000 Integer not null,
+> udec14_100 Numeric(4,0) unsigned not null,
+> char14_n500 Char(8) ,
+> sbinneg15_nuniq Largeint ,
+> sdecneg15_100 Numeric(9,0) signed not null,
+> char15_100 VarChar(8) not null,
+>
+>ubin16_n10 Numeric(4,0) unsigned ,
+> sdec16_uniq Numeric(18,0) signed not null,
+> char16_n20 Char(5) ,
+> sbin17_uniq Largeint not null,
+> sdec17_nuniq Numeric(18,0) ,
+> char17_2 VarChar(7) not null
+>
+>, primary key ( sdec9_uniq ASC
+> , sdec0_100 DESC
+> , sdec1_20 ASC )
+> );

--- SQL operation complete.
>>
>>Insert Into BTA1P006
+> Values (
+> -0, 'CJAAAAAC', -81, -2, 1973,
+> 'AA', -702, -202, 81, 81, 'BAAAAAAA',
+> -4, -724, NULL , 'BDAAAAAA', -3, 473, -- (5)
+> -702, -2, 'CCAAAAAA', -1, 'ABAAEAAA', NULL ,
+> 4, 'GFAAFAAA', 0, -201, 'BX',
+> 'CJAAAAAC', 702, 81, -81, 'AAAAMAAB', -- (10)
+> 0, -724, 'GFAAFAAA', 473, 'GEAAKAAA',
+> -702, 2, 'CGAAAAAA', -4081, -81, 'BGAAAAAA', -- (15)
+> NULL , -4724, 'AEAA', -76757, -1973, 'BAAA'
+> ),(
+> -1, 'AEAAJAAB', -44, -6, 60,
+> 'AA', -3766, -266, 44, 344, 'AAAAAAAA',
+> -9, -509, NULL , 'AAAAAAAA', -0, 60, -- (5)
+> -3766, -2, 'CQAAAAAA', -4, 'EAAAGAAA', NULL ,
+> 9, 'DBAAAAAA', 1, -200, 'AK',
+> 'AEAAJAAB', 3766, 344, -44, 'EKAACAAE', -- (10)
+> 1, -509, 'DBAAAAAB', 60, 'EFAAIAAA',
+> -766, 66, 'AGAAEAAA', -4344, -44, 'ATAAAAA', -- (15)
+> NULL , -2509, 'BE ', -37055, -60, 'AAAA'
+> ),(
+> -2, 'CCAAFAAC', -52, -12, 2086,
+> 'AA', -772, -272, 52, 1552, 'AAAAAAAA',
+> -18, -678, NULL , 'CBAAAAAA', -6, 86, -- (5)
+> -772, -0, 'AWAAAAAA', -12, 'DAAAGAAA', NULL ,
+> 8, 'DEAAMAAA', 2, -101, 'CL',
+> 'CCAAFAAC', 772, 1552, -52, 'DKAADAAC', -- (10)
+> 0, -678, 'DEAAMAAA', 86, 'AHAAGAAA',
+> -772, 72, 'CEAAHAAA', -3552, -52, 'ACAAAAAA', -- (15)
+> NULL , -3678, 'AB', -49700, -2086, 'AAAAAA'
+> ),(
+> -2, 'AIAALAAA', -89, -5, 812,
+> 'BA', -2065, -65, 89, 389, 'BAAAAAAA',
+> -14, -594, NULL , 'ACAAAAAA', -2, 312, -- (5)
+> -2065, -1, 'BPAAAAAA', -9, 'CFAAEAAA', NULL ,
+> 4, 'FKAAIAAA', 2, -100, 'AM',
+> 'AIAALAAA', 2065, 389, -89, 'CCAAKAAE', -- (10)
+> 0, -594, 'FKAAIAAA', 312, 'AJAAGAAA',
+> -65, 65, 'ABAAEAAA', -2389, -89, 'BOAAAAA',
+> NULL , -1594, 'AA', -15935, -812, 'AAAAAAA' -- (15)
+> )
+> ;

--- 4 row(s) inserted.
>>
>>select t.varchar0_uniq as t_varchar0_uniq
+> , t.char2_2 as t_char2_2
+> , t.char3_4 as t_char3_4
+> , u.varchar0_uniq as u_varchar0_uniq
+> , u.char2_2 as u_char2_2
+> from BTA1P006 t, BTA1P006 u
+> where (t.char2_2, 'AA', t.char3_4 ,'CJAAAAAC')
+> =('AA' ,u.char2_2 , 'AAAAAAAA' , u.varchar0_uniq)
+> order by 1, 2
+> ;

T_VARCHAR0_UNIQ  T_CHAR2_2  T_CHAR3_4  U_VARCHAR0_UNIQ  U_CHAR2_2
---------------  ---------  ---------  ---------------  ---------

AEAAJAAB         AA         AAAAAAAA   CJAAAAAC         AA
CCAAFAAC         AA         AAAAAAAA   CJAAAAAC         AA

--- 2 row(s) selected.
>>
>>drop schema myschema cascade;

--- SQL operation complete.
>>
>>exit;