Issues

Select view

  • Select search mode

 
50 of 59

Oracle DDL files use outdated syntax

Won't Fix

Description

The syntax used in the auto-generated DDL files for oracle use old syntax that is less than optimal on Oracle 10g et seq. In particular, "timestamp" datatype should be used instead of "date", and "varchar2(255 char)" should be used instead of "varchar2(255)".

Environment

None

Test Plan

None

Attachments

1

Details

Assignee

Reporter

Components

Priority

Created January 4, 2011 at 8:43 AM
Updated March 23, 2012 at 8:19 AM
Resolved March 23, 2012 at 7:41 AM

Activity

Jim EngJanuary 4, 2011 at 9:10 AM

That files includes two extra columns and an extra index: EVAL_EVALUATION.LOCAL_SELECTOR, EVAL_EMAIL_TEMPLATE.EID and eval_emailtemplate_eid. Those will be covered under separate tickets.

Jim EngJanuary 4, 2011 at 9:04 AM

Attaching copy of DDL script for Oracle 10g.