Re: eq_ref optimization -- please help

[Paul DuBois]

At 10:34 PM -0700 8/19/99, jeremy brand wrote:
>this has been resolved..  After changing the INT(9) to CHAR(5) the explain
>is doing what i expected.  
>
>On that note, i though I was going to loose auto_increment on that id
>field, but apparently char's will auto increment also.. weird..  I did do
>some tests and a newly inserted row does autoincrement correctly.. not
>what I had expected. but hey.. it works


No.  It will appear to work for a while, then it will start to malfunction.
AUTO_INCREMENT should be applied only to integer types.

-- 
Paul DuBois, paul@stripped