MySQL Bugs: #64559: Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES

Bug #64559	Add support of ANSI SQL syntax : INSERT INTO <table name> DEFAULT VALUES
Submitted:	6 Mar 2012 7:32	Modified:	6 Mar 2012 14:40
Reporter:	[ name withheld ]	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: DML	Severity:	S4 (Feature request)
Version:		OS:	Any
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
As described by SQL1992 and supported by most of RDBMS :

<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

An <insert columns and source> that specifies DEFAULT VALUES is equivalent to an <insert columns and source> that specifies a <query expression> of the form

VALUES (DEFAULT, . . . )

where the number of "DEFAULT" entries is equal to the number of columns of T.

How to repeat:
This is FR so no repeat

Thank you for the feature request.