Re: Insider #60: Highlights: Logo contest, Cool SMI queries, IDS Training, Chat wit the lab, Calendar

On Tue, 05 Jul 2005 18:28:47 -0400, "Art S. Kagel" <kagel@bloomberg.net> wrote: >ogj@tollpost.no wrote: >> "IIUG Emailer" <emailer@iiug.org> writes: >> >> >>>IUG Insider (Issue #60) June 2005 >>> >>>Highlights: Logo contest, Cool SMI queries, IDS Training, Chat wit the lab, Calendar >> >> >> [...] (snipped) > >As to you seeing all of your temp tables with both 0x0020 & 0x0040 set, I >dunno. 0x0020 in ti_flags indicates a temp table automatically created by >the engine to satisfy a join condition or to support a SCROLL CURSOR or >REPEATABLE READ isolation query. If ti_flags contains the bit 0x0040 set >that indicates a temp table created explicitely by a user with CREATE TEMP >TABLE... or SELECT...INTO TEMP... Then final value, 0x4000, is only >described as a special function temp table which does not require bitmap >maintenance. Anyone out there know why 'yvind is seeing combinations of >these flags set? John? Madison? I'm not sure . . . I'll have to dig a bit further. I've seen either / or, not combinations . . . . > >Also missing is an attribution. I believe Jake Solomon first showed a >version of this one to me. > >Art S. Kagel