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

Useless extraction of generic DDL trigger [CORE4415] #4737

Closed
firebird-issue-importer opened this issue May 1, 2014 · 4 comments
Closed

Comments

@firebird-issue-importer
Copy link

firebird-issue-importer commented May 1, 2014

Submitted by: Claudio Valderrama C. (robocop)

The example uses the SHOW command, but extracting a script produces the same result:

SQL> create trigger tr before any ddl statement as begin end;
SQL> show trigger tr;
TR, Sequence: 0, Type: BEFORE CREATE TABLE OR ALTER TABLE OR DROP TABLE OR
CREATE PROCEDURE OR ALTER PROCEDURE OR DROP PROCEDURE OR CREATE FUNCTION OR
ALTER FUNCTION OR DROP FUNCTION OR CREATE TRIGGER OR ALTER TRIGGER OR DROP
TRIGGER OR OR CREATE EXCEPTION OR ALTER EXCEPTION OR DROP EXCEPTION OR
CREATE VIEW OR ALTER VIEW OR DROP VIEW OR CREATE DOMAIN OR ALTER DOMAIN OR
DROP DOMAIN OR CREATE ROLE OR ALTER ROLE OR DROP ROLE OR CREATE INDEX OR
ALTER INDEX OR DROP INDEX OR CREATE SEQUENCE OR ALTER SEQUENCE OR DROP
SEQUENCE OR CREATE USER OR ALTER USER OR DROP USER OR CREATE COLLATION OR
DROP COLLATION OR ALTER CHARACTER SET OR CREATE PACKAGE OR ALTER PACKAGE OR
DROP PACKAGE OR CREATE PACKAGE BODY OR DROP PACKAGE BODY OR CREATE MAPPING
OR ALTER MAPPING OR DROP MAPPING OR <unknown> OR <unknown> OR <unknown> OR
<unknown> OR <unknown> OR <unknown> OR <unknown> OR <unknown> OR <unknown>
OR <unknown> OR <unknown> OR <unknown> OR <unknown> OR <unknown> OR
<unknown>, Active
as begin end
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Commits: 8162336 FirebirdSQL/fbt-repository@65534ef

====== Test Details ======

Confirmed excessive output in WI-T3.0.0.30809 Firebird 3.0 Alpha 2
TR, Sequence: 0, Type: BEFORE CREATE TABLE OR ALTER TABLE OR DROP TABLE OR ... OR <unknown>, Active // length = 967 characters.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 5, 2014

Modified by: @asfernandes

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented May 6, 2014

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

Fix Version: 3.0 Beta 1 [ 10332 ]

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 3, 2015

Modified by: @pavel-zotov

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

QA Status: Done successfully

Test Details: Confirmed excessive output in WI-T3.0.0.30809 Firebird 3.0 Alpha 2
TR, Sequence: 0, Type: BEFORE CREATE TABLE OR ALTER TABLE OR DROP TABLE OR ... OR <unknown>, Active // length = 967 characters.

@firebird-issue-importer
Copy link
Author

firebird-issue-importer commented Jun 3, 2015

Modified by: @pavel-zotov

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

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