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

Status: RESOLVED FIXED

(Bugzilla :: Installation & Upgrading, defect)

Description

[Jeff Dubrule]

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.

Comment 1

[Bradley Baetz (:bbaetz)]

Yeah, the lack of context-sensitive column nameing annoys me about oracle.. :)

Comment 2

[Gervase Markham [:gerv]]

Grr. And this one, too. :-|

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

Gerv

Comment 3

[Dave Miller [:justdave]]

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. :)

Comment 4

[Dave Miller [:justdave]]

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.

Comment 5

[Gervase Markham [:gerv]]

Fixed by checkin for bug 225687.

Gerv