2197581 - Error 512 or Signal 11 at CgEvals::_CgCompVcol raised by subquery with large IN - SAP ASE

• A user queries with a larger IN list in the subquery fails with Error 512 :

Msg 512, Level 16, State 4: Server 'ASE_157',
Line 1: Subquery returned more than 1 value.
This is illegal when the subquery follows=, !=, <, <= , >, >=, or when the subquery is used as an expression.Command has been aborted 

and / or

• ASE errorlog reports infected with signal 11 at address CgEvals::_CgCompVcol followed by a stack trace:

Current process (0x7ed000f) infected with signal 11 (SIGSEGV)
Address 0x0x0000000001805ec2 (CgEvals::_CgCompVcol(tree*)

CgEvals::_CgCompVcol
CgEvals::_CgCompExpr
CgEvals::_CgCompAggOp

• This has also been observed when running complex query with a CIS (proxy) table

• SAP Adaptive Server Enterprise (ASE) 15.7
• SAP Adaptive Server Enterprise (ASE) 16.0

CR783679, CR#783679, 783679, SEGV, segmentation, storage, access, violation, fault, segfault, kisignal, stacktrace, traceflagm 478, worktables, reformatting, -TF478 , CgEvals::_CgCompExpr(tree*) , CgEvals::_CgCompAggOp(tree*) , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem