My Oracle Support Banner

Union All Of Two Queries Runs, But A Single Query With "OR" Crashes. (Doc ID 2963769.1)

Last updated on OCTOBER 06, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 19.12.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Selecting from a view that has a pipeline function - twice and using "union all" works, but doing same with a single query that uses "OR", crashes.

Following error occurs.


ORA-07445: exception encountered: core dump [koxsihread()+84]

----- Call Stack -----
 ksedst1 <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd
 <- sslssSynchHdlr <- sslsshandler <- sighandler <- koxsihread
 <- kodpunp <- kgmtgpob <- kgmtimob <- kgmtconv <- kgmgaicn
 <- kgmpia_process_in_args <- kgmexwi <- kgmexec <- evapls <- evaopn2
 <- qerocnFetch <- qerocFetch <- qerjotFetch <- qeruaFetch <- opifch2
 <- opifch <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr
 <- opidrv <- sou2o <- opimai_real <- ssthrdmain <- main
 <- libc_start_main <- start

Changes

 Upgraded to 19c

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.