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
make syntax for "create trigger" compliant with SQL2003 [CORE711] #1083
Comments
Commented by: Alice F. Bird (firebirds) Date: 2005-11-22 12:02 MySQL: PostgreSQL: MSSQL: Oracle: Each DBMS accepts syntax : |
Commented by: Alice F. Bird (firebirds) Date: 2005-11-22 12:02 Your Feature Request has already been been recorded in the Additionally, we currently don't use the SF Feature Request Thanks for your interest in the project. |
Modified by: Alice F. Bird (firebirds)description: SFID: 1363616# Would it possible to change sql syntax for "create SQL2003: Current FB: Of course current FB extension {INSERT OR DELETE OR Future FB ?: Laco. => SFID: 1363616# Would it possible to change sql syntax for "create SQL2003: Current FB: Of course current FB extension {INSERT OR DELETE OR Future FB ?: Laco. |
Modified by: @dyemanovpriority: Major [ 3 ] => Trivial [ 5 ] Fix Version: 3.0 [ 10048 ] SF_ID: 1363616 => |
Modified by: @asfernandesFix Version: 2.1 [ 10041 ] assignee: Adriano dos Santos Fernandes [ asfernandes ] SF_ID: 1363616 => Fix Version: 3.0 [ 10048 ] => |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] SF_ID: 1363616 => |
Commented by: lacak (lacak) Great . Thank you ! |
Modified by: @pcisarFix Version: 2.1 Alpha 1 [ 10150 ] SF_ID: 1363616 => Fix Version: 2.1.0 [ 10041 ] => |
Commented by: lacak (lacak) Looking again at SQL:2003 and current implementation in FB 2.1, I see there a little difference : SQL:2003 does not specify "AS" before <triggered SQL statement> So I suggest change it slightly : 1. Omit "AS" or make it optional These changes will make syntax of CREATE TRIGGER much more close to SQL:2003 and also to other implementations (Oracle, PostgreSQL,MySQL) |
Modified by: @pcisarWorkflow: jira [ 10735 ] => Firebird [ 15122 ] |
Commented by: @pmakowski Q/A tested |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: lacak (lacak)
Jira_subtask_outward CORE2489
Is related to QA127
SFID: 1363616#
Submitted By: lacak
Would it possible to change sql syntax for "create
trigger" to be compliant with SQL2003 Standard ?
SQL2003:
--------
CREATE TRIGGER <trigger name>
{BEFORE | AFTER}
{INSERT | DELETE | UPDATE [ OF <trigger column
list> ]}
ON <table name>
[ REFERENCING <transition table or variable list> ]
[ FOR EACH { ROW | STATEMENT } ]
[ WHEN <left paren> <search condition> <right paren> ]
<triggered SQL statement>
Current FB:
-----------
CREATE TRIGGER <trigger name> FOR <table name>
[ACTIVE | INACTIVE]
{BEFORE | AFTER} <multiple_action>
[POSITION number]
AS trigger_body
Of course current FB extension {INSERT OR DELETE OR
UPDATE} is very useful.
Future FB ?:
------------
CREATE TRIGGER <trigger name>
{BEFORE | AFTER}
<multiple_action>
ON <table name>
AS trigger_body
Laco.
Commits: 570b6cd
The text was updated successfully, but these errors were encountered: