Skip to Content
0
Oct 29, 2009 at 06:14 PM

SQL error -3102 = Invalid subtrans structure

41 Views

Hello,

I get a strange error updating through a view if the underlying table contains a blob.

I'm using 7.7.06.09 (WIN32)

To reproduce I can run the following script using loadercli

-


error.sql----


CREATE TABLE FOO

(

"A" Fixed (10,0) NOT NULL,

"B" Fixed (21,11),

CONSTRAINT SYSPRIMARYKEY PRIMARY KEY("A")

)

//

CREATE TABLE BAR

(

"A" Fixed (10,0) NOT NULL,

"C" Blob,

CONSTRAINT SYSPRIMARYKEY PRIMARY KEY("A")

)

//

ALTER TABLE "BAR" FOREIGN KEY "AA" ("A") REFERENCES "FOO" ("A") ON DELETE CASCADE

//

CREATE VIEW "KILLROY" AS SELECT FOO.A,FOO.B,BAR.C FROM BAR,FOO WHERE FOO.A = BAR.A AND BAR.A = FOO.A WITH CHECK OPTION

//

INSERT INTO "KILLROY" SET A = 1, B = 1

//

INSERT INTO "KILLROY" SET A = 2, B = 2

//

UPDATE "KILLROY" SET B = 10 WHERE A = 1

-


end of script----


Is there anything I can do to prevent this error from happening?

Best Regards,

Stefan Gustafsson