Description
Apache Calcite 1.22.0 introduced the SQL operators EXISTS_NODE, EXTRACT_XML, XML_TRANSFORM and EXTRACT_VALUE do not restrict XML External Entity references in their configuration, making them vulnerable to a potential XML External Entity (XXE) attack. Therefore any client exposing these operators, typically by using Oracle dialect (the first three) or MySQL dialect (the last one), is affected by this vulnerability (the extent of it will depend on the user under which the application is running). From Apache Calcite 1.32.0 onwards, Document Type Declarations and XML External Entity resolution are disabled on the impacted operators.
Remediation
References
http://www.openwall.com/lists/oss-security/2022/11/21/3
https://lists.apache.org/thread/ohdnhlgm6jvt3srw8l7spkm2d5vwm082
Related Vulnerabilities
CVE-2022-26850 Vulnerability in maven package org.apache.nifi:nifi-single-user-utils
CVE-2023-46650 Vulnerability in maven package com.coravy.hudson.plugins.github:github
CVE-2023-50768 Vulnerability in maven package org.sonatype.nexus.ci:nexus-jenkins-plugin
CVE-2022-25923 Vulnerability in npm package exec-local-bin
CVE-2023-34455 Vulnerability in maven package org.xerial.snappy:snappy-java