On Sat, Mar 25, 2017 at 6:04 PM, Amit Kapila <amit.kapil...@gmail.com> wrote: > On Tue, Mar 21, 2017 at 5:51 PM, Dilip Kumar <dilipbal...@gmail.com> wrote: >> On Tue, Mar 21, 2017 at 4:47 PM, Thomas Munro >> <thomas.mu...@enterprisedb.com> wrote: >>> I noticed a failure in the inet.sql test while running the regression >>> tests with parallelism cranked up, and can reproduce it interactively >>> as follows. After an spgist index is created and the plan changes to >>> the one shown below, the query returns no rows. >> >> Thanks for reporting. Seems like we are getting issues related to >> TBM_ONE_PAGE and TBM_EMPTY. >> >> I think in this area we need more testing, reason these are not tested >> properly because these are not the natural case for parallel bitmap. >> I think in next few days I will test more such cases by forcing the >> parallel bitmap. >> > > Okay, is your testing complete? > >> Here is the patch to fix the issue in hand. I have also run the >> regress suit with force_parallel_mode=regress and all the test are >> passing. >> > > Thomas, did you get chance to verify Dilip's latest patch? > > I have added this issue in PostgreSQL 10 Open Items list so that we > don't loose track of this issue.
The result is correct with this patch. I ran make installcheck then the same steps as above and the query result was correct after creating the index. -- Thomas Munro http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers