INSERT without values [CORE863]

[firebird-issue-importer]

Submitted by: Michael Trowe (bubble76)

Is related to QA124

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;

Commits: 651607f

[firebird-issue-importer]

Modified by: Michael Trowe (bubble76)

description: if there is a table, all values are ???? 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;

=>

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;

[firebird-issue-importer]

Commented by: @dyemanov

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.

[firebird-issue-importer]

Modified by: @dyemanov

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

[firebird-issue-importer]

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

[firebird-issue-importer]

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

[firebird-issue-importer]

Modified by: @pcisar

Link: This issue is related to QA124 [ QA124 ]

[firebird-issue-importer]

Modified by: @pcisar

Workflow: jira [ 11085 ] => Firebird [ 14316 ]

[firebird-issue-importer]

Commented by: @pmakowski

Q/A tested

[firebird-issue-importer]

Modified by: @pmakowski

status: Resolved [ 5 ] => Closed [ 6 ]

[firebird-issue-importer]

Modified by: @pavel-zotov

QA Status: No test