Description
steps to repro:
- create standard bucket `temp_bucket`
- CREATE primary index ON temp_bucket
- INSERT INTO temp_bucket VALUES(UUID(), {"CUSTOMER_ID":551,"MSISDN":UUID(), "ICCID":UUID()})
- INSERT INTO temp_bucket (KEY UUID(), VALUE d) SELECT {"CUSTOMER_ID":551,"MSISDN":UUID(),"ICCID":UUID()} AS d FROM temp_bucket WHERE CUSTOMER_ID == 551;
- repeat step 4 9 times
- CREATE INDEX `xi1` ON `temp_bucket`(`CUSTOMER_ID`,`MSISDN`);
- CREATE INDEX `ai_SIM` ON `temp_bucket`(distinct pairs({`CUSTOMER_ID`, `ICCID`, `MSISDN` }));
- select TIM_ID, MSISDN from temp_bucket WHERE CUSTOMER_ID = 551 ORDER BY MSISDN ASC LIMIT 2 OFFSET 0
Last query returns 2 results which is correct, but sometimes it returns 0 results. Just run it several times from web interface.
Attachments
Issue Links
- is a backport of
-
MB-31336 unstable result set
- Closed