Werk #15298: mk_oracle: restore compatibility with oracle 12c

Component

Agent bakery

Title

mk_oracle: restore compatibility with oracle 12c

Date

Oct 24, 2023

Level

Trivial Change

Class

Bug Fix

Compatibility

Compatible - no manual interaction needed

Checkmk versions & editions

2.3.0b1 Not yet released	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.3.0b1	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)
2.2.0p18	Checkmk Raw (CRE), Checkmk Enterprise (CEE), Checkmk Cloud (CCE), Checkmk MSP (CME)

Werk #14839 added the function listagg to one of our queries.

Older versions of oracle database expect a WITHIN statement after the listagg function. This was added to assure compatibility with older databases.

To the list of all Werks