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 251115 - Show SQL Script for INSERT with Generated Values
Summary: Show SQL Script for INSERT with Generated Values
Status: NEW
Alias: None
Product: db
Classification: Unclassified
Component: Show Data (show other bugs)
Version: 8.1
Hardware: PC Linux
: P4 normal (vote)
Assignee: Libor Fischmeistr
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-03-12 00:59 UTC by olehoppe
Modified: 2015-03-12 00:59 UTC (History)
0 users

See Also:
Issue Type: ENHANCEMENT
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 olehoppe 2015-03-12 00:59:42 UTC 
This is a follow-up to Bug ID 250467.

Currently the context menu option "Show SQL Script for INSERT" on a query result table won't include columns that (partly) contain auto-increment values, because there are DBMSs like Derby that do not allow inserting values into auto-increment columns.

But as there are popular DBMSs like MySQL and PostgreSQL that allow inserting values into auto-increment columns it would be nice to have the option of getting such columns included in the generated SQL script. This could be made available in the UI e.g. by two sub-menu options under "Show SQL Script for INSERT", like "With Generated Values" and "Without Generated Values".