Issue Details (XML | Word | Printable)

Key: CORE-4415
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Adriano dos Santos Fernandes
Reporter: Claudio Valderrama C.
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Firebird Core

Useless extraction of generic DDL trigger

Created: 01/May/14 05:43 PM   Updated: 03/Jun/15 06:36 PM
Component/s: ISQL
Affects Version/s: 3.0 Alpha 1, 3.0 Alpha 2
Fix Version/s: 3.0 Beta 1

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.


 Description  « Hide
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
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
There are no subversion log entries for this issue yet.