At 21:42, 19990804, Peter Zaitsev wrote:
>I'm using mysql 3.22.25 on linux.
>
>I had two table referenced by a foreign key.
>table one had primary key unsigned mediumint
>table two had a foreign key but the type was unsigned smallint
>
>values of the key stayed in unsigned smallint range but then
>running queries with KEY1=KEY2 in there clause the key was not
>used. The question is is this is a planned feature or unplanned
>bug ?
I don't know that it's a planned feature, but it's certainly a
documented behaviour.
Tim