Description
To reproduce:
select * from `travel-sample` where type1 = "hotel" or type2 = "route";
Click on "advise" button;
Two recommended indexes:
CREATE INDEX adv_type1 ON `travel-sample`(`type1`)
CREATE INDEX adv_type2 ON `travel-sample`(`type2`)
Click on "CREATE AND BUILD INDEXES" button;
Either index1 or index2 will be created instead of both.
Attachments
Issue Links
- duplicates
-
MB-37735 Index Advisor: "Create & Build Indexes" only creates one index
- Closed
For Gerrit Dashboard: MB-37535 | ||||||
---|---|---|---|---|---|---|
# | Subject | Branch | Project | Status | CR | V |
121152,3 | MB-37535 - multiple advised indexes not created | master | query-ui | Status: MERGED | +2 | +1 |
121153,2 | MB-37535 - multiple advised indexes not created | mad-hatter | query-ui | Status: MERGED | +2 | +1 |