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.
| Summary: | Fault occurs in data type Default value. | ||
|---|---|---|---|
| Product: | db | Reporter: | issues@www <issues> |
| Component: | Code | Assignee: | Radko Najman <rnajman> |
| Status: | CLOSED FIXED | ||
| Severity: | blocker | CC: | jf4jbug |
| Priority: | P4 | ||
| Version: | 3.x | ||
| Hardware: | Sun | ||
| OS: | Solaris | ||
| Issue Type: | DEFECT | Exception Reporter: | |
Fixed. Default values of character data types are encapsulated in one '(apostrophe) character now. Bug is not fixed correctly.
How to reproduce:
1) Create table with one VARCHAR column with default value: "DEFVAL1".
I'm using MSSQL driver.
2) Grab its structure.
3) Delete table.
4) Recreate table.
5) ERROR - See Command from recreating table. It is:
create table "Test!"
(
"COL" CHAR(20) default '('DEFVAL1')'
)
6) NOTE - It should be like this (no outter single-quotes exists):
create table "Test!"
(
"COL" CHAR(20) default ('DEFVAL1')
)
Fixed in trunk. Workaround for MSSQLServer - default value is encapsulated in () so I can't generate '()' VERIFIED Resolved for 3.3.x or earlier, no new info since then -> closing. |
Description: The reappearance method of a bug. 1. A table is created.(Image1.tif and Image2.tif) "Create Table" a dialog -- "name", "type(CHAR or VARCHARA2)", "size", and a "default value(1)" -- it sets up and a "OK" button is pushed. 2.Greb Structure.(TEST1.grab) "Greb Structure" a dialog -- "file name",it sets up a "Save" button is pushed. 3.Delete Table. The table created by "1." is deleted. 4.Recrate Table. "Recreate Table" a dialog -- The file created by" 2." is chosen and the button "OPEN" is pushed. 5.Name the Table.(Image3.tif) "Name the Table" a dialog -- The button "OK" is pushed. 6.Error.(Image4.tif) An "Error" dialog displays. Create Table Type(CHAR or VARCHARA2). Since ''1'' is in default value, it becomes an error. It will OK, if '1' is in default value. --It generates also en build/C locale. *Build:010629_ee_ja,010629_ee_en *OS:Solaris *JDK:JDK1.3.1 *Oracle 8i v8.1.7/Oracle thin driver ------------------------------------ *Build:010714_ee_ja,010714_ee_en *OS:Solaris *JDK:JDK1.3.1 *IBM DB2/DB2 jdbc driver ------------------------ xxx@xxxx 2001-07-23 In the case of "MS SQL 2000/weblogic driver", it became the following errors. 6.Error.(Image5.tif) An "Error" dialog displays. Create Table Type(CHAR or VARCHARA2). Since '('1')' is in default value, it becomes an error. It will OK, if '1' is in default value. *Build:010714_ee_ja,010714_ee_en *OS:Solaris *JDK:JDK1.3.1 *MS SQL 2000/weblogic driver ---------------------------- xxx@xxxx 2001-07-24 Evaluation: The problem is that for character data types is the default value encapsulated in two '(apostrophe) characters instead of one in the generated DDL command. There is an easy workaround for this - user can modify the command and remove the redundant ' character. A comment.