This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.

Bug 32783

Summary:	Invalid DEFAULT statement in CREATE TABLE
Product:	db	Reporter:	Martin Schovanek <mschovanek>
Component:	Code	Assignee:	Radko Najman <rnajman>
Status:	VERIFIED FIXED
Severity:	blocker
Priority:	P3
Version:	3.x
Hardware:	PC
OS:	Windows ME/2000
Issue Type:	DEFECT	Exception Reporter:

Description Martin Schovanek 2003-04-10 10:31:23 UTC

[S1S5 Build 030408, Oracle 9i]

Create Table command places CREATE TABLE statement after 
NOT NULL statement but valid syntax is:

(column) (datatype) DEFAULT (expr) ((constraint) | 
(ref_constraint)*)

see:
http://download-
west.oracle.com/docs/cd/B10501_01/server.920/a96540/stateme
nts_73a.htm#2073172

Comment 1 Martin Schovanek 2003-04-10 11:11:53 UTC

Sorry for typo, the description should be:

Create Table command places DEFAULT statement after NOT NULL statement
but valid syntax is:
...

Steps to reproduce:
------------------
1) right-click the Tables node and choose 'Create Table ...'
2) fill-in Column name, Default value and select Key
3) click OK

Comment 2 Radko Najman 2003-09-09 16:55:03 UTC

Fixed

Comment 3 Martin Schovanek 2003-10-07 11:54:28 UTC

VERIFIED