[jira] [Created] (DERBY-6444) Add support for INSERT INTO table DEFAULT VALUES syntax

["Lukas Eder (JIRA)" <ji...@apache.org>]

Lukas Eder created DERBY-6444:
---------------------------------

             Summary: Add support for INSERT INTO table DEFAULT VALUES syntax
                 Key: DERBY-6444
                 URL: https://issues.apache.org/jira/browse/DERBY-6444
             Project: Derby
          Issue Type: Improvement
          Components: SQL
    Affects Versions: 10.10.1.1
            Reporter: Lukas Eder
            Priority: Minor


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>




--
This message was sent by Atlassian JIRA
(v6.1.5#6160)