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 - Invalid DEFAULT statement in CREATE TABLE
Summary: Invalid DEFAULT statement in CREATE TABLE
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 3.x
Hardware: PC Windows ME/2000
: P3 blocker (vote)
Assignee: Radko Najman
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-04-10 10:31 UTC by Martin Schovanek
Modified: 2003-12-11 14:20 UTC (History)
0 users

See Also:
Issue Type: DEFECT
Exception Reporter:

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 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