List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:August 20 1999 5:38am
Subject:Re: eq_ref optimization -- please help
View as plain text  
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
Thread
eq_ref optimization -- please helpjeremy brand19 Aug
  • Re: eq_ref optimization -- please helpMartin Ramsch19 Aug
    • Re: eq_ref optimization -- please helpjeremy brand19 Aug
      • Re: eq_ref optimization -- please helpBenjamin Pflugmann20 Aug
        • Re: eq_ref optimization -- please helpjeremy brand20 Aug
          • Re: eq_ref optimization -- please helpBenjamin Pflugmann20 Aug
            • Re: eq_ref optimization -- please helpjeremy brand20 Aug
              • Re: eq_ref optimization -- please helpPaul DuBois20 Aug
                • Re: eq_ref optimization -- please helpjeremy brand20 Aug