My Oracle Support Banner

Segmentation Fault for Timesten SQL With Aggregate Function MIN() And CASE (Doc ID 2503390.1)

Last updated on OCTOBER 15, 2019

Applies to:

Oracle TimesTen In-Memory Database - Version 11.2.2.8.0 and later
Information in this document applies to any platform.

Symptoms

On : Timesten 11.2.2.8.0 version

When execute the following SQL statement, we have seen segmentation fault
The SQL statement is:

SELECT
 ID_MES, MIN(CASE WHEN ID = 'ABC' THEN XYZ ELSE NULL END) GGGGGG, MIN(CASE WHEN ID = 'CDE' THEN XYZ ELSE NULL END) GGG
FROM XXXXX
GROUP BY ID;



From core dump the stack looks like below


Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.