Thread: Re: [BUGS] temp tables failes in transaction mode

> I believe this is fixed in 6.5.1.

Nope, it is not.  I just tried the same SQL code on my newly upgraded
server.  Instead of crashing, it hangs.  Server uses 50% CPU and
nothing happends.

I did not upgrade the binary data when upgraded from 6.5 to 6.5.1.
README said binary format hasn't changed.
--
##>  Petter Reinholdtsen <##    | pere@td.org.uit.no
 O-  <SCRIPT Language="Javascript">window.close()</SCRIPT>
http://www.hungry.com/~pere/    | Go Mozilla, go! Go!

>
> > I believe this is fixed in 6.5.1.
>
> Nope, it is not.  I just tried the same SQL code on my newly upgraded
> server.  Instead of crashing, it hangs.  Server uses 50% CPU and
> nothing happends.
>
> I did not upgrade the binary data when upgraded from 6.5 to 6.5.1.
> README said binary format hasn't changed.
> --
> ##>  Petter Reinholdtsen <##    | pere@td.org.uit.no
>  O-  <SCRIPT Language="Javascript">window.close()</SCRIPT>
> http://www.hungry.com/~pere/    | Go Mozilla, go! Go!
>

We have since fixed this, but the fix will only appear in 6.6.  It
required quite a bit of changes.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Petter Reinholdtsen <pere@hungry.com> writes:
>> I believe this is fixed in 6.5.1.

> Nope, it is not.  I just tried the same SQL code on my newly upgraded
> server.  Instead of crashing, it hangs.  Server uses 50% CPU and
> nothing happends.

This bug is still there in REL6_5, but it seems to be fixed in the
current (i.e., 6.6 development) sources.  I didn't bother to track
down the exact cause of the crash; I'm sure it is associated with
the temp-table-related fixes that just got done this weekend.

            regards, tom lane