title: XPath query in DB2
body: <p>I'm performing the following query in DB2 on a XML column and it works fine:</p>
  
  <pre><code>SELECT  
  FROM customer
  WHERE contains(search_text, 
  '
  @xpath:''/customer/number[. contains("123456")]''
  ', 'RESULTLIMIT = 100')=1;
  </code></pre>
  
  <p>but the following query doesn't work:</p>
  
  <pre><code>SELECT  
  FROM customer
  WHERE contains(search_text, 
  '
  @xpath:''/customer/number[. = "123456"]''
  ', 'RESULTLIMIT = 100')=1;
  </code></pre>
  
  <p>Any ideas why the second query doesn't work?
  The error I get is:
  ERROR [38H10] [IBM][DB2/LINUXX8664] SQL20423N  Error occurred during text search processing on server "localhost" using index "CISC_CUSTOMER". The error message is ""IQQS0032E The query cannot be processe".</p>
  
  <pre><code>&lt;customer&gt;
  &lt;number&gt;
  123456
  &lt;/number&gt;
  &lt;firstname&gt;
  John 
  &lt;/firstname&gt;
  &lt;lastname&gt;
  Smith
  &lt;/lastname&gt;
  &lt;/customer&gt;
  </code></pre>