Re: [HACKERS] Table collision in join.sql and aggregates.sql

2017-03-31 Thread Douglas Doole
D'oh! The "temp" declaration had been removed from our test since we don't use temp tables. I missed that when applying it to the community code. You can ignore me now. On Fri, Mar 31, 2017 at 4:01 PM Tom Lane wrote: > Douglas Doole writes: > > As we've been merging our code with 9.6, a couple

Re: [HACKERS] Table collision in join.sql and aggregates.sql

2017-03-31 Thread Tom Lane
Douglas Doole writes: > As we've been merging our code with 9.6, a couple developers have had > one-off failures in the join.sql and aggregates.sql test because the tables > T1, T2 and T3 have the wrong definitions. > Digging into it, I found that both files create the tables T1, T2, and T3 > for

[HACKERS] Table collision in join.sql and aggregates.sql

2017-03-31 Thread Douglas Doole
As we've been merging our code with 9.6, a couple developers have had one-off failures in the join.sql and aggregates.sql test because the tables T1, T2 and T3 have the wrong definitions. Digging into it, I found that both files create the tables T1, T2, and T3 for a short period of time and then