3380150 - Signal 11 in function opt_like_and() with configurable parameters ‘statement cache size’ >0 and ‘enable literal autoparam’=1 -- SAP ASE

• A query having LIKE CLAUSE sometimes caused signal 11 in function opt_like_and() with stack trace.
• Configurable parameters ‘statement cache size’ > 0 and ‘enable literal autoparam = 1’.
• Boot time trace flag -T7739 is on, this trace flag enables literal parameterization for strings in LIKE pattern and escape clause.
• Statement cache memory usage (including SQL text and their query plans) had reached ‘statement cache size’ limit.

SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL01 HF2

CR 828452, 828452, -T7739, LIKE, like clause, literal parameterization, set literal_autoparam off , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem