From 8b0f82b9b8ae8a892e67a55dd3dc10154a4cef00 Mon Sep 17 00:00:00 2001
From: "bar@mysql.com/bar.intranet.mysql.r18.ru" <>
Date: Fri, 29 Sep 2006 16:29:39 +0500
Subject: Bug#21263 mysql client XML output does not distinguish between NULL
 and string 'NULL'

  Fix: "mysql --xml" now print NULL values the same way that "mysqldump --xml" does:

    <field name="name" xsi:nil="true" />

  to distinguish from empty strings:

    <field name="name"></field>

  and from string "NULL":

    <field name="name">NULL</field>
---
 mysql-test/r/client_xml.result | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'mysql-test')

diff --git a/mysql-test/r/client_xml.result b/mysql-test/r/client_xml.result
index 24c05c7f9d6..7395b2433e8 100644
--- a/mysql-test/r/client_xml.result
+++ b/mysql-test/r/client_xml.result
@@ -68,7 +68,7 @@ insert into t1 values (1, 2, 'a&b a<b a>b');
 <resultset statement="select null from dual
 ">
   <row>
-	<field name="NULL">NULL</field>
+	<field name="NULL" xsi:nil="true" />
   </row>
 </resultset>
 drop table t1;
-- 
cgit v1.2.1