Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

INSERT without values [CORE863] #1253

Closed
firebird-automations opened this issue Jul 20, 2006 · 10 comments
Closed

INSERT without values [CORE863] #1253

firebird-automations opened this issue Jul 20, 2006 · 10 comments

Comments

@firebird-automations
Copy link
Collaborator

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

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-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

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

resolution: Fixed [ 1 ]

Fix Version: 2.1 [ 10041 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA124 [ QA124 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@firebird-automations
Copy link
Collaborator Author

Commented by: @pmakowski

Q/A tested

@firebird-automations
Copy link
Collaborator Author

Modified by: @pmakowski

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

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants