Re: InnoDB 3.23.52, foreign keys and update/cascade problem

2002-09-23 Thread Paul DuBois
At 12:10 -0700 9/23/02, j.random.programmer wrote: >Hi all: > >I'm seeing a strange problem updating a field if >that field is referenced as a FK in another table. > >Consider: > >CREATE TABLE A ( > id INTEGER NOT NULL AUTO_INCREMENT, > name VARCHAR(20), > PRIM

Re: InnoDB 3.23.52, foreign keys and update/cascade problem

2002-09-23 Thread j.random.programmer
Hi all: I'm seeing a strange problem updating a field if that field is referenced as a FK in another table. Consider: CREATE TABLE A ( id INTEGER NOT NULL AUTO_INCREMENT, name VARCHAR(20), PRIMARY KEY (id) ); CREATE TABLE B ( id INTEGER N