XML Function ExtractValue() Returns NULL Instead of Empty String On MySQL Server 5.6.28 & 5.6.29
Last updated on FEBRUARY 23, 2018
Applies to:MySQL Server - Version 5.6 to 5.6 [Release 5.6]
Information in this document applies to any platform.
When the following code is executed on the 5.5 version:
set @y = 'Default Value';
select ExtractValue( @x, '/MESSAGE/DATA2' ) into @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
Issue introduced in versions 5.6.28 and 5.6.29.
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