From: Daevid Vincent
Date: March 6 2003 2:36am
Subject: Foreign keys and being FIRST index
List-Archive: http://lists.mysql.com/mysql/134076
Message-Id: <005c01c2e389$30c07860$dc0aa8c0@Locutus>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

http://www.mysql.com/doc/en/SEC457.html states that "there must be an index
where the foreign key and the referenced key are listed as the FIRST
columns." Will this restriction be lifted soon? It is incredibly
frustrating. I don't see why they have to be indexes, and more importantly,
I don't see why they have to be FIRST! Ugh.