id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,focuses
11322,Changes needed to schema for new options table keys,nacin,ryan,"Looks like dbDelta is attempting to modify the new option_name and autoloaded_options keys. Not a blocker as I first thought -- dbDelta fails silently -- but $wp_queries is invalid in dbDelta's eyes, so it should be changed.
This is due to the very finicky nature of dbDelta, in this case requiring the word ""KEY"" in addition to ""UNIQUE"" and not wanting spaces between fields in an index.
Ideally, dbDelta can be improved in the future by preventing such stumbles, particularly with regard to whitespace.
The Codex should probably be updated as well. It currently identifies the two spaces required for primary keys and the need to use KEY over INDEX, but it doesn't mention other whitespace requirements.
Xref: #11266, #10404",defect (bug),closed,high,2.9,Database,2.9,major,fixed,has-patch,,