XML Function ExtractValue() Returns NULL Instead of Empty String On MySQL Server 5.6.28 & 5.6.29 (Doc ID 2129212.1)

Last updated on JUNE 27, 2016

Applies to:

MySQL Server - Version 5.6 to 5.6 [Release 5.6]
Information in this document applies to any platform.

Symptoms

When the following code is executed on the 5.5 version:

set @x = 'HOLA';
set @y = 'Default Value';
select ExtractValue( @x, '/MESSAGE/DATA2' ) into @y;
select @y;

the output value of @y is: '' (empty string)

But when the same code is executed on the 5.6.28, or 5.6.29 version, the output value of @y is: NULL

Changes

Issue introduced in versions 5.6.28 and 5.6.29.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms