MySQL Forums
Forum List  »  InnoDB

Re: SQLSTATE[42000]: Syntax error or access violation: 1070 Too many key parts specified; max 16 parts allowed
Posted by: Peter Brawley
Date: June 29, 2019 12:12PM

A core Magento table violates a MySQL limit?

I believe Magento allows you to see which cols are to be used for FT indexes. Some backends may allow more than 16. MySQL does not. If Magento let you specify more than what MySQL allows, that's a Magento bug.

Options: ReplyQuote

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.