Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 341936 - Oracle driver indicates VERSION is reserved word
Summary: Oracle driver indicates VERSION is reserved word
Status: NEW
Alias: None
Product: Data Tools
Classification: Tools
Component: Enablement (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows 7
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Project Inbox CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-04-05 11:48 EDT by Brian Vosburgh CLA
Modified: 2011-04-05 13:39 EDT (History)
0 users

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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)
)