>>obey TEST_13_4(tests);
>>
>>------------------------------------------------------------------
>>--          TEST CASE
>>------------------------------------------------------------------
>>
>>INSERT INTO tab VALUES (1,2,3,4);

--- 1 row(s) inserted.
>> -- should actually insert (5,2,3,9)
>>INSERT INTO tab VALUES (2,3,4,5);

--- 1 row(s) inserted.
>> -- should actually insert (7,3,4,12)
>>
>>-- tab should contain:
>>-- (5,2,3,9)
>>-- (7,3,4,12)
>>SELECT * FROM tab order by a;

A            B            C            D          
-----------  -----------  -----------  -----------

          5            2            3            9
          7            3            4           12

--- 2 row(s) selected.
>> -- check result
>>
>>
>>---------------------------------
>>-- DEFINE TRIGGER btrig3
>>---------------------------------
>>
>>CREATE TRIGGER btrig3
+>BEFORE UPDATE OF (b)
+>ON tab
+>REFERENCING NEW AS newR, OLD AS oldR
+>FOR EACH ROW
+>SET newR.c = oldR.b;

--- SQL operation complete.
>>
>>UPDATE tab SET B=10;

--- 2 row(s) updated.
>>
>>-- tab should contain:
>>-- (5,10,2,9)
>>-- (7,10,3,12)
>>SELECT * FROM tab order by a;

A            B            C            D          
-----------  -----------  -----------  -----------

          5           10            2            9
          7           10            3           12

--- 2 row(s) selected.
>> -- check result 
>>
>>
>>-- the following ddl should fail:
>>
>>CREATE TRIGGER btrig4
+>BEFORE UPDATE OF (b)
+>ON tab
+>REFERENCING NEW AS newR, OLD AS oldR
+>FOR EACH ROW
+>SET newR.a = oldR.b;

*** ERROR[4033] Column A is a primary or clustering key column and cannot be updated.

*** ERROR[1079] SQL was not able to prepare the statement.

--- SQL operation failed with errors.
>>
>>-- the following ddl should fail:
>>
>>CREATE TRIGGER btrig5
+>BEFORE UPDATE OF (c)
+>ON tab
+>REFERENCING NEW AS newR, OLD AS oldR
+>FOR EACH ROW
+>SET newR.d = oldR.b;

*** ERROR[4033] Column D is a primary or clustering key column and cannot be updated.

*** ERROR[1079] SQL was not able to prepare the statement.

--- SQL operation failed with errors.
>>
>>------------------------------------------------------------------
>>--           END
>>------------------------------------------------------------------
>>LOG;
