List:General Discussion« Previous MessageNext Message »
From:Stephen Brownlow Date:May 27 2002 4:58am
Subject:Re: [7241] Indexes on columns that are declared differently?
View as plain text  
I am hoping that a MySQL person will give a definite answer to my question.

Thanks,
Stephen

----- Original Message ----- 
From: "Dan Nelson" <dnelson@stripped>
Newsgroups: mailing.database.mysql
Sent: Monday, May 20, 2002 3:18 PM
Subject: Re: [7241] Indexes on columns that are declared differently?


> In the last episode (May 20), Stephen Brownlow said:
> > The MySQL online manual says that MySQL cannot use indexes
> > efficiently unless the columns have the same type and the same
> > length.
> > 
> > I can see no release notes that this problem has been fixed.
> > 
> > My question: Is this still a problem?
> 
> Probably.  I doubt anyone's even trying to fix it, since a field-length
> mismatch between related fields means that one or the other fields has
> the wrong length.  You'll never get a 20-character string to match if
> the other table's field definition is char(10); either make both 10, or
> both 20 :)


Thread
[7241] Indexes on columns that are declared differently?Stephen Brownlow20 May
  • Re: [7241] Indexes on columns that are declared differently?Dan Nelson20 May
Re: [7241] Indexes on columns that are declared differently?Stephen Brownlow27 May