You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
/* Trigger: MACRO_BI */
CREATE TRIGGER MACRO_BI FOR MACRO
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (http://NEW.ID IS NULL) THEN http://NEW.ID = GEN_ID(GEN_MACRO_ID,1);
END
^
SET TERM ; ^
INSERT INTO PARAM (ID, P1) VALUES (2, 11);
-- This command doesn't insert a record, but should
update or insert into MACRO (T1, CODE)
values ( (select ID from PARAM where P1 = 11), 'fsdfdsf')
matching (T1);
Submitted by: @asfernandes
Is related to QA270
I'm creating this ticket just for documentation purposes. It doesn't require any code change, because fix for it is the same one of CORE2117.
Reported on a Russian forum:
SET SQL DIALECT 3;
SET NAMES WIN1251;
CREATE DATABASE 'localhost:C:\Firebird2.1\Base\TEST.FDB'
USER 'SYSDBA' PASSWORD '1'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251;
CREATE GENERATOR GEN_MACRO_ID;
CREATE TABLE MACRO (
ID INTEGER NOT NULL,
T1 INTEGER,
CODE VARCHAR(50)
);
CREATE TABLE PARAM (
ID INTEGER NOT NULL,
P1 INTEGER
);
ALTER TABLE MACRO ADD CONSTRAINT PK_MACRO PRIMARY KEY (ID);
ALTER TABLE PARAM ADD CONSTRAINT PK_PARAM PRIMARY KEY (ID);
ALTER TABLE MACRO ADD CONSTRAINT FK_MACRO_1 FOREIGN KEY (T1) REFERENCES PARAM (ID);
SET TERM ^ ;
/* Trigger: MACRO_BI */
CREATE TRIGGER MACRO_BI FOR MACRO
ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
IF (http://NEW.ID IS NULL) THEN
http://NEW.ID = GEN_ID(GEN_MACRO_ID,1);
END
^
SET TERM ; ^
INSERT INTO PARAM (ID, P1) VALUES (2, 11);
-- This command doesn't insert a record, but should
update or insert into MACRO (T1, CODE)
values ( (select ID from PARAM where P1 = 11), 'fsdfdsf')
matching (T1);
Commits: 2223e6a
The text was updated successfully, but these errors were encountered: