[DERBY-6444] Add support for INSERT INTO table DEFAULT VALUES syntax

• Type: Improvement
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 10.10.1.1
• Component/s: SQL
• Labels: features
• Urgency: Normal
• Bug behavior facts: Deviation from standard
• Assignee: Unassigned
• Reporter: Lukas Eder
• Created: 31/Dec/13 20:32
• Updated: 31/Dec/13 20:32

Description

Many other databases support specific syntax to create an "empty" or "default" record in a table:

INSERT INTO table DEFAULT VALUES

The above syntax is equivalent to this:

INSERT INTO table (v1, v2, ..., vn) VALUES (DEFAULT, DEFAULT, ..., DEFAULT)

Just to name a few databases that support this syntax:

• CUBRID
• Firebird
• H2
• HSQLDB
• Ingres
• PostgreSQL
• SQLite
• SQL Server
• Sybase

For convenience it would be great if the SQL-92 Standard (http://www.andrew.cmu.edu/user/shadow/sql/sql1992.txt) would be implemented:

13.8 <insert statement>

Function

Create new rows in a table.

Format

<insert statement> ::=
INSERT INTO <table name>
<insert columns and source>

<insert columns and source> ::=
[ <left paren> <insert column list> <right paren> ]
<query expression>

DEFAULT VALUES

<insert column list> ::= <column name list>