Иммем DDL
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
/******************************************************************************/
/*** Generated by IBExpert 2016.6.22.1 01.08.2016 9:58:18 ***/
/******************************************************************************/
SET SQL DIALECT 3;
SET NAMES WIN1251;
CREATE DATABASE 'TEST.FDB '
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 16384
DEFAULT CHARACTER SET WIN1251 COLLATION WIN1251;
/******************************************************************************/
/*** Tables ***/
/******************************************************************************/
CREATE TABLE "TABLE_A" (
"ID" INTEGER NOT NULL,
"SOME_DATA" INTEGER
);
CREATE TABLE "TABLE_B" (
"ID" INTEGER NOT NULL,
"TABLE_A_ID" INTEGER,
"SOME_DATA" SMALLINT,
"PARENT_ID" SMALLINT
);
INSERT INTO "TABLE_A" ("ID", "SOME_DATA") VALUES (1, 10);
COMMIT WORK;
INSERT INTO "TABLE_B" ("ID", "TABLE_A_ID", "SOME_DATA", "PARENT_ID") VALUES (1, 1, 555, NULL);
INSERT INTO "TABLE_B" ("ID", "TABLE_A_ID", "SOME_DATA", "PARENT_ID") VALUES (2, 1, 222, 1);
COMMIT WORK;
/******************************************************************************/
/*** Primary keys ***/
/******************************************************************************/
ALTER TABLE "TABLE_A" ADD CONSTRAINT "PK_TABLE_A" PRIMARY KEY ("ID");
ALTER TABLE "TABLE_B" ADD CONSTRAINT "PK_TABLE_B" PRIMARY KEY ("ID");
/******************************************************************************/
/*** Foreign keys ***/
/******************************************************************************/
ALTER TABLE "TABLE_B" ADD CONSTRAINT "FK_TABLE_B_1" FOREIGN KEY ("TABLE_A_ID") REFERENCES "TABLE_A" ("ID") ON DELETE CASCADE;
ALTER TABLE "TABLE_B" ADD CONSTRAINT "FK_TABLE_B_2" FOREIGN KEY ("PARENT_ID") REFERENCES "TABLE_B" ("ID") ON DELETE CASCADE;
При попытке удаления
1.
DELETE FROM TABLE_A WHERE (ID = 1)
получаю
The cursor identified in the UPDATE or DELETE statement is not positioned on a row.
no current record for fetch operation.
At trigger 'CHECK_1'.
в Firebird 2.5.2 это работало!
Это баг fb 3.0 или баг был в fb 2.5 и это не должно работать?
