Useless extraction of generic DDL trigger
-----------------------------------------
Key: CORE-4415
URL: http://tracker.firebirdsql.org/browse/CORE-4415
Project: Firebird Core
Issue Type: Bug
Components: ISQL
Affects Versions: 3.0 Alpha 2, 3.0 Alpha 1
Reporter: Claudio Valderrama C.
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
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos. Get
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
