Description
I have seen this hang/incorrect behavior before also, but could not reproduce it consistenty before.
1. Load beer-sample
2. create primary index on beer-sample.
3. CREATE INDEX `bid` ON `beer-sample`(`brewery_id`)
4. Execute following query:
SELECT b1 from `beer-sample` b1
LEFT OUTER JOIN `beer-sample` b2 ON KEY b2.brewery_id FOR b1
INNER JOIN `beer-sample` b3 ON KEYS b2.brewery_id
LEFT OUTER JOIN `beer-sample` b4 ON KEYS b3.brewery_id
LEFT OUTER JOIN `beer-sample` b5 ON KEY b5.brewery_id FOR b4;
5. Results are displayed correctly, but after that UI just hangs, click next or previous gives result as "processing".