Если в максимально упрощенном варианте.
Таблица.
CREATE TABLE APP_TEXTS (
TEXT_ID INTEGER NOT NULL,
TEXT BLOB SUB_TYPE 1 SEGMENT SIZE 254 NOT NULL,
DATE_CREATION TIMESTAMP NOT NULL,
DATE_LASTVERSION TIMESTAMP NOT NULL,
VERSION_NUMBER INTEGER NOT NULL,
TEXT_NAME VARCHAR(82) DEFAULT 'unknown' NOT NULL,
SUBVERSION INTEGER,
TEXT_TYPE INTEGER NOT NULL,
TEXT_PID INTEGER NOT NULL,
TEXT_ORDER INTEGER,
USER_ID INTEGER
);
триггеров нет. Вообще ничего кроме таблицы нет. Таблица вообще пустая.
Такой вот блок
EXECUTE BLOCK
AS BEGIN
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=0 WHERE TEXT_ID=100102;
UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=1 WHERE TEXT_ID=100042;
UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=2 WHERE TEXT_ID=100061;
UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=3 WHERE TEXT_ID=100038;
UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=4 WHERE TEXT_ID=67;
UPDATE APP_TEXTS SET TEXT_PID=67, TEXT_ORDER=5 WHERE TEXT_ID=68;
UPDATE APP_TEXTS SET TEXT_PID=68, TEXT_ORDER=6 WHERE TEXT_ID=19;
UPDATE APP_TEXTS SET TEXT_PID=67, TEXT_ORDER=7 WHERE TEXT_ID=69;
UPDATE APP_TEXTS SET TEXT_PID=69, TEXT_ORDER=8 WHERE TEXT_ID=21;
UPDATE APP_TEXTS SET TEXT_PID=69, TEXT_ORDER=9 WHERE TEXT_ID=17;
UPDATE APP_TEXTS SET TEXT_PID=100102, TEXT_ORDER=10 WHERE TEXT_ID=100107;
UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=11 WHERE TEXT_ID=100017;
UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=12 WHERE TEXT_ID=100018;
UPDATE APP_TEXTS SET TEXT_PID=100107, TEXT_ORDER=13 WHERE TEXT_ID=100019;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=14 WHERE TEXT_ID=100073;
UPDATE APP_TEXTS SET TEXT_PID=100073, TEXT_ORDER=15 WHERE TEXT_ID=100074;
UPDATE APP_TEXTS SET TEXT_PID=100074, TEXT_ORDER=16 WHERE TEXT_ID=100075;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=17 WHERE TEXT_ID=35;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=18 WHERE TEXT_ID=64;
UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=19 WHERE TEXT_ID=65;
UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=20 WHERE TEXT_ID=62;
UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=21 WHERE TEXT_ID=63;
UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=22 WHERE TEXT_ID=100071;
UPDATE APP_TEXTS SET TEXT_PID=65, TEXT_ORDER=23 WHERE TEXT_ID=100072;
UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=24 WHERE TEXT_ID=70;
UPDATE APP_TEXTS SET TEXT_PID=64, TEXT_ORDER=25 WHERE TEXT_ID=71;
UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=26 WHERE TEXT_ID=27;
UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=27 WHERE TEXT_ID=29;
UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=28 WHERE TEXT_ID=33;
UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=29 WHERE TEXT_ID=100078;
UPDATE APP_TEXTS SET TEXT_PID=100078, TEXT_ORDER=30 WHERE TEXT_ID=100079;
UPDATE APP_TEXTS SET TEXT_PID=100078, TEXT_ORDER=31 WHERE TEXT_ID=100080;
UPDATE APP_TEXTS SET TEXT_PID=71, TEXT_ORDER=32 WHERE TEXT_ID=100085;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=33 WHERE TEXT_ID=66;
UPDATE APP_TEXTS SET TEXT_PID=66, TEXT_ORDER=34 WHERE TEXT_ID=13;
UPDATE APP_TEXTS SET TEXT_PID=66, TEXT_ORDER=35 WHERE TEXT_ID=15;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=36 WHERE TEXT_ID=72;
UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=37 WHERE TEXT_ID=100001;
UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=38 WHERE TEXT_ID=100002;
UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=39 WHERE TEXT_ID=43;
UPDATE APP_TEXTS SET TEXT_PID=43, TEXT_ORDER=40 WHERE TEXT_ID=100012;
UPDATE APP_TEXTS SET TEXT_PID=43, TEXT_ORDER=41 WHERE TEXT_ID=100044;
UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=42 WHERE TEXT_ID=100064;
UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=43 WHERE TEXT_ID=100065;
UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=44 WHERE TEXT_ID=100066;
UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=45 WHERE TEXT_ID=100067;
UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=46 WHERE TEXT_ID=100068;
UPDATE APP_TEXTS SET TEXT_PID=100064, TEXT_ORDER=47 WHERE TEXT_ID=100069;
UPDATE APP_TEXTS SET TEXT_PID=100069, TEXT_ORDER=48 WHERE TEXT_ID=100070;
UPDATE APP_TEXTS SET TEXT_PID=72, TEXT_ORDER=49 WHERE TEXT_ID=100013;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=50 WHERE TEXT_ID=73;
UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=51 WHERE TEXT_ID=94;
UPDATE APP_TEXTS SET TEXT_PID=94, TEXT_ORDER=52 WHERE TEXT_ID=95;
UPDATE APP_TEXTS SET TEXT_PID=95, TEXT_ORDER=53 WHERE TEXT_ID=96;
UPDATE APP_TEXTS SET TEXT_PID=96, TEXT_ORDER=54 WHERE TEXT_ID=97;
UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=55 WHERE TEXT_ID=45;
UPDATE APP_TEXTS SET TEXT_PID=73, TEXT_ORDER=56 WHERE TEXT_ID=100009;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=57 WHERE TEXT_ID=74;
UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=58 WHERE TEXT_ID=75;
UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=59 WHERE TEXT_ID=76;
UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=60 WHERE TEXT_ID=23;
UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=61 WHERE TEXT_ID=25;
UPDATE APP_TEXTS SET TEXT_PID=75, TEXT_ORDER=62 WHERE TEXT_ID=31;
UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=63 WHERE TEXT_ID=37;
UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=64 WHERE TEXT_ID=39;
UPDATE APP_TEXTS SET TEXT_PID=74, TEXT_ORDER=65 WHERE TEXT_ID=100104;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=66 WHERE TEXT_ID=77;
UPDATE APP_TEXTS SET TEXT_PID=77, TEXT_ORDER=67 WHERE TEXT_ID=78;
UPDATE APP_TEXTS SET TEXT_PID=78, TEXT_ORDER=68 WHERE TEXT_ID=100076;
UPDATE APP_TEXTS SET TEXT_PID=78, TEXT_ORDER=69 WHERE TEXT_ID=79;
UPDATE APP_TEXTS SET TEXT_PID=77, TEXT_ORDER=70 WHERE TEXT_ID=80;
UPDATE APP_TEXTS SET TEXT_PID=80, TEXT_ORDER=71 WHERE TEXT_ID=81;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=72 WHERE TEXT_ID=82;
UPDATE APP_TEXTS SET TEXT_PID=82, TEXT_ORDER=73 WHERE TEXT_ID=83;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=74 WHERE TEXT_ID=84;
UPDATE APP_TEXTS SET TEXT_PID=84, TEXT_ORDER=75 WHERE TEXT_ID=87;
UPDATE APP_TEXTS SET TEXT_PID=87, TEXT_ORDER=76 WHERE TEXT_ID=85;
UPDATE APP_TEXTS SET TEXT_PID=87, TEXT_ORDER=77 WHERE TEXT_ID=86;
UPDATE APP_TEXTS SET TEXT_PID=84, TEXT_ORDER=78 WHERE TEXT_ID=88;
UPDATE APP_TEXTS SET TEXT_PID=88, TEXT_ORDER=79 WHERE TEXT_ID=89;
UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=80 WHERE TEXT_ID=90;
UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=81 WHERE TEXT_ID=91;
UPDATE APP_TEXTS SET TEXT_PID=89, TEXT_ORDER=82 WHERE TEXT_ID=93;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=83 WHERE TEXT_ID=98;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=84 WHERE TEXT_ID=99;
UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=85 WHERE TEXT_ID=100;
UPDATE APP_TEXTS SET TEXT_PID=100, TEXT_ORDER=86 WHERE TEXT_ID=101;
UPDATE APP_TEXTS SET TEXT_PID=100, TEXT_ORDER=87 WHERE TEXT_ID=102;
UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=88 WHERE TEXT_ID=103;
UPDATE APP_TEXTS SET TEXT_PID=103, TEXT_ORDER=89 WHERE TEXT_ID=104;
UPDATE APP_TEXTS SET TEXT_PID=103, TEXT_ORDER=90 WHERE TEXT_ID=105;
UPDATE APP_TEXTS SET TEXT_PID=99, TEXT_ORDER=91 WHERE TEXT_ID=100106;
UPDATE APP_TEXTS SET TEXT_PID=100106, TEXT_ORDER=92 WHERE TEXT_ID=11;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=93 WHERE TEXT_ID=107;
UPDATE APP_TEXTS SET TEXT_PID=107, TEXT_ORDER=94 WHERE TEXT_ID=108;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=95 WHERE TEXT_ID=100063;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=96 WHERE TEXT_ID=100082;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=97 WHERE TEXT_ID=100084;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=98 WHERE TEXT_ID=100086;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=99 WHERE TEXT_ID=100060;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=100 WHERE TEXT_ID=100052;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=101 WHERE TEXT_ID=100058;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=102 WHERE TEXT_ID=100048;
UPDATE APP_TEXTS SET TEXT_PID=100082, TEXT_ORDER=103 WHERE TEXT_ID=100051;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=104 WHERE TEXT_ID=100087;
UPDATE APP_TEXTS SET TEXT_PID=100087, TEXT_ORDER=105 WHERE TEXT_ID=100088;
UPDATE APP_TEXTS SET TEXT_PID=100087, TEXT_ORDER=106 WHERE TEXT_ID=100081;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=107 WHERE TEXT_ID=100089;
UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=108 WHERE TEXT_ID=100090;
UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=109 WHERE TEXT_ID=100083;
UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=110 WHERE TEXT_ID=100091;
UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=111 WHERE TEXT_ID=100092;
UPDATE APP_TEXTS SET TEXT_PID=100089, TEXT_ORDER=112 WHERE TEXT_ID=100093;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=113 WHERE TEXT_ID=100094;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=114 WHERE TEXT_ID=100035;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=115 WHERE TEXT_ID=100030;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=116 WHERE TEXT_ID=100028;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=117 WHERE TEXT_ID=100045;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=118 WHERE TEXT_ID=100006;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=119 WHERE TEXT_ID=100008;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=120 WHERE TEXT_ID=100039;
UPDATE APP_TEXTS SET TEXT_PID=100094, TEXT_ORDER=121 WHERE TEXT_ID=100054;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=122 WHERE TEXT_ID=100095;
UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=123 WHERE TEXT_ID=100004;
UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=124 WHERE TEXT_ID=100005;
UPDATE APP_TEXTS SET TEXT_PID=100095, TEXT_ORDER=125 WHERE TEXT_ID=100056;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=126 WHERE TEXT_ID=100096;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=127 WHERE TEXT_ID=100016;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=128 WHERE TEXT_ID=100023;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=129 WHERE TEXT_ID=100024;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=130 WHERE TEXT_ID=100041;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=131 WHERE TEXT_ID=100043;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=132 WHERE TEXT_ID=100053;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=133 WHERE TEXT_ID=100050;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=134 WHERE TEXT_ID=100046;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=135 WHERE TEXT_ID=100049;
UPDATE APP_TEXTS SET TEXT_PID=100096, TEXT_ORDER=136 WHERE TEXT_ID=100059;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=137 WHERE TEXT_ID=100099;
UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=138 WHERE TEXT_ID=100021;
UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=139 WHERE TEXT_ID=100037;
UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=140 WHERE TEXT_ID=100007;
UPDATE APP_TEXTS SET TEXT_PID=100099, TEXT_ORDER=141 WHERE TEXT_ID=100047;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=142 WHERE TEXT_ID=100100;
UPDATE APP_TEXTS SET TEXT_PID=100100, TEXT_ORDER=143 WHERE TEXT_ID=100036;
UPDATE APP_TEXTS SET TEXT_PID=100100, TEXT_ORDER=144 WHERE TEXT_ID=100040;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=145 WHERE TEXT_ID=100103;
UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=146 WHERE TEXT_ID=100010;
UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=147 WHERE TEXT_ID=100011;
UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=148 WHERE TEXT_ID=100027;
UPDATE APP_TEXTS SET TEXT_PID=100103, TEXT_ORDER=149 WHERE TEXT_ID=100015;
UPDATE APP_TEXTS SET TEXT_PID=-1, TEXT_ORDER=150 WHERE TEXT_ID=100101;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=151 WHERE TEXT_ID=100029;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=152 WHERE TEXT_ID=100034;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=153 WHERE TEXT_ID=100032;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=154 WHERE TEXT_ID=100026;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=155 WHERE TEXT_ID=100014;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=156 WHERE TEXT_ID=100020;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=157 WHERE TEXT_ID=100033;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=158 WHERE TEXT_ID=100031;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=159 WHERE TEXT_ID=100025;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=160 WHERE TEXT_ID=100055;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=161 WHERE TEXT_ID=100062;
UPDATE APP_TEXTS SET TEXT_PID=100101, TEXT_ORDER=162 WHERE TEXT_ID=100022;
END
размер блока - 11729 байт, т.е. далеко до 64 Кб. Количество операторов -
163.
Получаем ошибку
invalid request BLR at offset 6420.
Too many Contexts of Relation/Procedure/Views. Maximum allowed is 255.
Если уменшить количество операторов до 127 - т.е. до половины 255, то
такой блок выполняется.
--~--~---------~--~----~------------~-------~--~----~
-~----------~----~----~----~------~----~------~--~---
