Subject | Strange trigger creation behaviour? |
---|---|
Author | semprolbat |
Post date | 2010-06-17T23:14:24Z |
Is this behavious as designed??
C:\DOCUME~1\-\LOCALS~1\Temp>isql -user sysdba -pass masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "db.fdb";
SQL> create table a(id integer);
SQL> create view b(id) as select id from a;
SQL>
SQL> create trigger "c" for "b"
CON> before insert as
CON> begin
CON> end;
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-b
-At line 1, column 20
SQL>
SQL> create trigger "d" for b
CON> before insert as
CON> begin
CON> end;
SQL>
SQL> create trigger "e" for "B"
CON> before insert as
CON> begin
CON> end;
SQL> show version;
ISQL Version: WI-V2.1.3.18185 Firebird 2.1
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.1.3.18185 Firebird 2.1"
Firebird/x86/Windows NT (remote server), version "WI-V2.1.3.18185 Firebird 2.1/X
Net (-)/P11"
Firebird/x86/Windows NT (remote interface), version "WI-V2.1.3.18185 Firebird 2.
1/XNet (-)/P11"
on disk structure version 11.1
C:\DOCUME~1\-\LOCALS~1\Temp>isql -user sysdba -pass masterkey
Use CONNECT or CREATE DATABASE to specify a database
SQL> create database "db.fdb";
SQL> create table a(id integer);
SQL> create view b(id) as select id from a;
SQL>
SQL> create trigger "c" for "b"
CON> before insert as
CON> begin
CON> end;
Statement failed, SQLCODE = -204
Dynamic SQL Error
-SQL error code = -204
-Table unknown
-b
-At line 1, column 20
SQL>
SQL> create trigger "d" for b
CON> before insert as
CON> begin
CON> end;
SQL>
SQL> create trigger "e" for "B"
CON> before insert as
CON> begin
CON> end;
SQL> show version;
ISQL Version: WI-V2.1.3.18185 Firebird 2.1
Server version:
Firebird/x86/Windows NT (access method), version "WI-V2.1.3.18185 Firebird 2.1"
Firebird/x86/Windows NT (remote server), version "WI-V2.1.3.18185 Firebird 2.1/X
Net (-)/P11"
Firebird/x86/Windows NT (remote interface), version "WI-V2.1.3.18185 Firebird 2.
1/XNet (-)/P11"
on disk structure version 11.1