Issue Details (XML | Word | Printable)

Key: CORE-863
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Dmitry Yemanov
Reporter: Michael Trowe
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

INSERT without values

Created: 20/Jul/06 04:04 AM   Updated: 07/Apr/08 11:16 AM
Component/s: Engine
Affects Version/s: None
Fix Version/s: 2.1 Alpha 1

Time Tracking:
Not Specified

Issue Links:
Relate
 


 Description  « Hide
if there is a table, all values are set by default-values or by an before-insert-trigger I think it should be possible to insert a row without any given values:
INSERT INTO table;

 All   Comments   Work Log   Change History   Version Control   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Dmitry Yemanov added a comment - 20/Jul/06 04:25 AM
In SQL-2003 spec:
  INSERT INTO <table> DEFAULT VALUES;
and I agree it could be supported. But as for triggers, it's impossible as the INSERT statement has no knowledge about them.

Philippe Makowski added a comment - 07/Apr/08 11:16 AM
Q/A tested