Open
Bug 553287
Opened 15 years ago
Updated 12 years ago
[ORACLE] DB/Oracle.pm __BZ_EMPTY_STR__ breaks New Charts regexp queries
Categories
(Bugzilla :: Database, defect)
Tracking
()
NEW
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.
|
Reporter | |
Updated•15 years ago
|
Version: unspecified → 3.6
|
||
Comment 1•15 years ago
|
||
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
|
||
Comment 2•13 years ago
|
||
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.
Description
•