Closed Bug 247544 Opened 20 years ago Closed 20 years ago

There is a column named 'date' in series_data, which Oracle doesn't like

Categories

(Bugzilla :: Installation & Upgrading, defect)

Product:
Bugzilla
Component:
Installation & Upgrading
Type:
defect
Priority:
Not set
Severity:
normal

Tracking

()

Status:
RESOLVED FIXED
Milestone:
Bugzilla 2.18

People

(Reporter: jdubrule, Assigned: gerv)

References

Details

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040404 Firefox/0.8
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040404 Firefox/0.8

In checksetup.pl, the table named 'series_data' has a column named 'date', which
is a reserved word in Oracle.

Reproducible: Always
Steps to Reproduce:
Run checksetup.pl

Actual Results:  
ERROR at line 2:
ORA-00904: invalid column name


Expected Results:  
Table Created.
Blocks: bz-oracle
Status: UNCONFIRMED → NEW
Ever confirmed: true
OS: Linux → All
Hardware: PC → All
Target Milestone: --- → Bugzilla 2.20
Yeah, the lack of context-sensitive column nameing annoys me about oracle.. :)
Grr. And this one, too. :-|

Do we want this and its friend bug 247547 for 2.18? Dave?

Gerv
Assignee: zach → gerv
Flags: blocking2.18?
normally I would say schema changes are scary on a branch, but I'll OK this 
(and the other one) for 2.18 provided they go in as part of your charting
megapatch, since they are both related to chart schema. :)
Flags: blocking2.18? → blocking2.18+
Target Milestone: Bugzilla 2.20 → Bugzilla 2.18
FYI, while you're getting this, there's a "value" column in the same table... 
value is a reserved word in several databases as well.
Depends on: 225687
Fixed by checkin for bug 225687.

Gerv
Status: NEW → RESOLVED
Closed: 20 years ago
Resolution: --- → FIXED
QA Contact: matty_is_a_geek → default-qa
You need to log in before you can comment on or make changes to this bug.