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 155142 - Default value isn't validated
Summary: Default value isn't validated
Status: RESOLVED FIXED
Alias: None
Product: db
Classification: Unclassified
Component: Code (show other bugs)
Version: 6.x
Hardware: All All
: P3 blocker (vote)
Assignee: Jiri Skrivanek
URL:
Keywords:
Depends on:
Blocks: 152581
  Show dependency tree
 
Reported: 2008-12-10 14:33 UTC by Roman Mostyka
Modified: 2009-06-18 19:30 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 Roman Mostyka 2008-12-10 14:33:46 UTC 
1. Connect to "travel" Java DB and expand it's node.
2. Rightclick "Tables" node and choose "Create Table...".
3. Set table name, column name, set VARCHAR for the column type, set size to 3, set "test" as default value and click "OK".

Result: Table is created and there is no error message appears that default value doesn't fit size of column.
Then, when user tries to insert record with default value, error arises.
Comment 1 Jiri Rechtacek 2009-02-10 15:22:18 UTC 
Reassigned to new owner.
Comment 2 Jiri Skrivanek 2009-06-18 08:26:10 UTC 
Fixed.
core-main #0ae38c88ad49
Comment 3 Quality Engineering 2009-06-18 19:30:33 UTC 
Integrated into 'main-golden', will be available in build *200906181401* on http://bits.netbeans.org/dev/nightly/ (upload may still be in progress)
Changeset: http://hg.netbeans.org/main-golden/rev/0ae38c88ad49
User: Jiri Skrivanek <jskrivanek@netbeans.org>
Log: #155142 - Check size of default value for VARCHAR.