Internal Error in TDV when using HAVING clause

Internal Error in TDV when using HAVING clause

book

Article ID: KB0081644

calendar_today

Updated On:

Description

Problem Reported : When user is trying executing a specific piece of SQL an Internal Error was generated.

SQL:

SELECT 1982 test_col

FROM  /shared/shared/Tibco_POC/L1_Logical/UseCase2/vPopYear2_2 "vPopYear2_2"

WHERE CASE WHEN 'Y' = 'Y' THEN 1 ELSE 2 END = 1

HAVING COUNT(1) > 0

Error:

Caused by: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0

  at java.util.ArrayList.rangeCheck(Unknown Source)

Issue/Introduction

Internal Error in TDV when using HAVING clause

Resolution

As a workaround, set the configuration : "Disable Union Pre-Aggregation" to true  and execute the query.

Powered by Wolken Software