Open Bug 553287 Opened 14 years ago Updated 11 years ago

[ORACLE] DB/Oracle.pm __BZ_EMPTY_STR__ breaks New Charts regexp queries

Categories

(Bugzilla :: Database, defect)

Product:
Bugzilla
Component:
Database
Type:
defect
Priority:
Not set
Severity:
minor

Tracking

()

People

(Reporter: davidt, Unassigned)

Details

User-Agent:       Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2) Gecko/20100115 Firefox/3.6
Build Identifier: bugzill 3.6.0

Because Oracle treats an empty string as NULL DB/Oracle.pm translates '' to/from '__BZ_EMPTY_STR__'.

The standard 'New Reports' 'All Open' and 'All Closed' data set queries use 'RESOLUTION does not match regexp .' and 'RESOLUTION matches regexp .' to identify open/closed bugs respectively.

The "resolution" '__BZ_EMPTY_STR__' matches /./, so all bugs are reported as CLOSED.  This is clearly incorrect, but I see no obvious solution.  To work around the problem I will probably alter the queries to check against __BZ_EMPTY_STR__ instead...

Reproducible: Always

Steps to Reproduce:
1. Install bugzilla on Oracle.
2. Create some open and closed bugs over a few days.
3. Use the 'New Charts' reporting function to view an 'All Open' or 'All Closed' dataset.
Actual Results:  
All bugs are listed as 'closed'.

Expected Results:  
A mix of open and closed bugs should be shown.
Version: unspecified → 3.6
  This sounds like we just really need an "is not empty" clause, which I think we have a bug for.
Severity: normal → minor
Status: UNCONFIRMED → NEW
Ever confirmed: true
Summary: DB/Oracle.pm __BZ_EMPTY_STR__ breaks New Reports regexp queries → [ORACLE] DB/Oracle.pm __BZ_EMPTY_STR__ breaks New Charts regexp queries
I will take a look at this to see what I can do.

Regards,
Leo
You need to log in before you can comment on or make changes to this bug.