yahoo-eng-team team mailing list archive

Thread
Date

[Bug 1230102] Re: For oracle database, the usage of REGEXP is not correct for List Servers by filter.

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Thierry Carrez <thierry.carrez+lp@xxxxxxxxx>
Date: Wed, 04 Dec 2013 10:29:33 -0000
Reply-to: Bug 1230102 <1230102@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: nova
       Status: Fix Committed => Fix Released

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to OpenStack Compute (nova).
https://bugs.launchpad.net/bugs/1230102

Title:
  For oracle database, the usage of REGEXP is not correct for List
  Servers by filter.

Status in OpenStack Compute (Nova):
  Fix Released

Bug description:
  The REGEXP_LIKE operator for oracle db backend is not correct.

  For the MySql database, the following SQL syntax is right:
  ---
  select xxx from xxx where column REGEXP pattern
  ---

  But for Oracle database, the following SQL syntax is not right:
  ---
  select xxx from xxx where column REGEXP_LIKE pattern
  ---

  It should be:
  ---
  select xxx from xxx where REGEXP_LIKE (column, pattern)
  ---

To manage notifications about this bug go to:
https://bugs.launchpad.net/nova/+bug/1230102/+subscriptions