Re: MySQL RE: insertion problem !!

2002-02-12 Thread Heikki Tuuri
Chetan, the type of the column user_id is different in your two tables: in the parent table it is UNSIGNED, but signed in the child table. The internal storage format of a signed integer is different from an unsigned integer. That is why adding the child row fails. I changed now InnoDB-3.23.48 s

Re: MySQL RE: insertion problem !!

2002-02-07 Thread Heikki Tuuri
Chetan, the type of the column user_id is different in your two tables: in the parent table it is UNSIGNED, but signed in the child table. The internal storage format of a signed integer is different from an unsigned integer. That is why adding the child row fails. I changed now InnoDB-3.23.48 s