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 77218 - [55cat] Error when creating a table with a default value
Summary: [55cat] Error when creating a table with a default value
Status: VERIFIED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 5.x
Hardware: PC All
: P3 blocker (vote)
Assignee: Andrei Badea
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-01 11:21 UTC by cezariusz
Modified: 2007-01-23 09:45 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 cezariusz 2006-06-01 11:21:59 UTC 
[ BUILD # : 200605180200 ]
[ JDK VERSION : 1.5.0_06 ]

Firebird 2.0 RC2
Jaybird 2.0.1

When creating a table and setting a default value for the primary key column, the following error occurs:

Unable to execute command:
create table test
(
  sample_column INT not null default 1 primary key
)
GDS Exception. 335544569. Dynamic SQL Error.
SQL error code = -104
Token unknown - line 3, char 29
default
Comment 1 Andrei Badea 2006-06-02 10:33:13 UTC 
Should probably be "sample_column INT default 1 not null primary key".
Comment 2 cezariusz 2006-06-02 11:04:59 UTC 
Yes, default should be before not null.
Comment 3 Andrei Badea 2006-08-13 21:29:36 UTC 
Fixed.

Checking in dbspec.plist;
/cvs/db/libsrc/org/netbeans/lib/ddl/resources/dbspec.plist,v  <--  dbspec.plist
new revision: 1.48.2.2.2.3; previous revision: 1.48.2.2.2.2
done
Comment 4 Lukasz Grela 2007-01-23 09:45:16 UTC 
v.