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 128272 - recreate table with grab file doesn't work sometime
Summary: recreate table with grab file doesn't work sometime
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: SQL Editor (show other bugs)
Version: 6.x
Hardware: PC Linux
: P3 blocker (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks: 152818
  Show dependency tree
 
Reported: 2008-02-25 03:27 UTC by hiarcs
Modified: 2013-08-01 12:52 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
Exception Reporter:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description hiarcs 2008-02-25 03:27:53 UTC
I created a table like this:
---- SQL Code ----
CREATE TABLE PEOPLE
	(PERSON_ID INT NOT NULL GENERATED ALWAYS AS IDENTITY
	CONSTRAINT PEOPLE_PK PRIMARY KEY, PERSON VARCHAR(26))
---- End ----
and then I "grab structure" it, it's ok, but when I try to recreate it with the grab file, things goes wrong.
the script generated looks like that, and can't be executed:
---- Script generate by Netbeans ---
create table "HIARCS".PEOPLE
(
	PERSON_ID INTEGER default AUTOINCREMENT: start 1 increment 1 not null primary key,
	PERSON VARCHAR(26)
)
---- End ----

I know it's difficult to deal with different SQL db, so I don't expect we can grab and recreate anything anytime. But 
the point is, I don't received any msg or warning during the grab operation, so I may delete the sql command and think 
"with this grab file everything is ok", it could make me miserable later. On the other hand, I can open a sql file with 
Netbeans but can't find an easy way to save the command into .sql file (maybe I missed), so in my opinion it will be 
better if we:
1. raise a waring when people grab
2. allow people save command as sql file
3. when people recreate table with grab file, Edit table script, run it and success, update the grab file if possible.
Comment 1 Jiri Rechtacek 2009-10-16 14:13:04 UTC
Reassigned to new owner.