Re: [Maria-discuss] bug or not bug? ;-)

[Alexandre Almeida]

yes, it makes sense.
Can I assume they are "created" at the time that my show (a select in  
fact) perform?



<<inline: alexandre(jpg).jpg>>

Em 05/05/2010, às 17:22, Antony Curtis escreveu:

Information schema tables are materialized as temporary tables.
Not a bug, just a side effect of the way how they are implemented.

On Wednesday, May 05, 2010, at 11:41AM, "Alexandre Almeida" <alexan...@hti.com.br 
> wrote:
Guys,

        everytime I run the following command:

                 show global status like 'created%tmp%tables'

        the created_tmp_tables is incremented by 1.

	Is that right? I mean, which relationship between a show global  
(that
will perform a minimum select at information_schema) and a new
temporary table?

        I would appreciate your comments.

Alex






_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp




_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp