Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 341936

Summary: Oracle driver indicates VERSION is reserved word
Product: [Tools] Data Tools Reporter: Brian Vosburgh <brian.vosburgh>
Component: EnablementAssignee: Project Inbox <dtp.enablement-inbox>
Status: NEW --- QA Contact:
Severity: normal    
Priority: P3    
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows 7   
Whiteboard:

Description Brian Vosburgh CLA 2011-04-05 11:48:19 EDT
The DTP-supplied Oracle implementation of DatabaseDefinition.isSQLKeyword("VERSION") returns 'true'. This is incorrect.
Comment 1 Brian Fitzpatrick CLA 2011-04-05 11:59:22 EDT
Brian, do you have any specifics here? What version of Oracle? What version of DTP? 

We've been pointing people to simply use Oracle's version of the enablement plug-ins and should probably just deprecate what's in Enablement at this point.
Comment 2 Brian Vosburgh CLA 2011-04-05 13:39:33 EDT
We are using the DTP build required by the WTP Indigo M6 build: dtp-sdk-1.9.0M6-201103110500.zip.

Oracle 11g Release 1 (11.1.0.7) does not indicate "VERSION" is a reserved word. The following DDL executes without a problem:

create table foo (
	id NUMBER(10) PRIMARY KEY,
	name VARCHAR2(20),
	version NUMBER(10)
)